Target Recovery Time is a new database option in SQL Server 2012. Set it above 0 and SQL Server uses indirect checkpoints to limit recovery time.
SQL SERVER – A Quick Script for Point in Time Recovery – Back Up and Restore
A quick script for point in time recovery: set up and back up a database, restore it to a point in time, then clean up. Three simple steps.
SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device.Operating system error 3 (The system cannot find the path specified.)
Got Msg 3201, Cannot open backup device, with operating system error 3? The folder in the backup path is missing. Create it and run the backup again.
Reading the Transaction Log With fn_dblog
fn_dblog can expose transaction-log records during a narrow investigation, but retention and missing user context make it a last resort.
SQL SERVER – Copy Database from Instance to Another Instance – Copy Paste in SQL Server
How to copy database from instance to another instance with the Copy Database Wizard, and automate it through SSIS and a SQL Server Agent job.
SQL SERVER – Making Database to Read Only – Changing Database to Read/Write
A reader attached a client database and it showed as Read Only. Two simple ALTER DATABASE scripts switch a database to READ_ONLY and back to READ_WRITE.
SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device . Operating system error 5(Access is denied.)
Msg 3201, cannot open backup device, operating system error 5 (Access is denied). The SQL Server service account needed permission on the disk.