This CHECKPOINT Behavior Quiz asks what lets SQL Server reuse transaction log space under the SIMPLE and FULL recovery models. The answers differ, and a tested script shows both. It also shows how one open transaction keeps the log from being reused.
DACPAC vs BACPAC Quiz: Which File Carries Your Data?
This DACPAC vs BACPAC Quiz asks which file moves a database with its rows to Azure SQL Database. The answer is the BACPAC. A tested script shows what each file describes, and the SqlPackage commands show how to use them.
SQL SERVER – Effect of Compressed Backup Setting at Server Level on Database Backup
A reader’s database backup got much smaller with no code change. The reason was the compressed backup setting at the server level. Here is the story.
SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012
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.