A client’s production database kept going into Recovery Pending on its own and coming back. The ERRORLOG showed OS error 32, file in use by another process.
SQL SERVER – Error: Property BackupDirectory is Not Available for Settings
Opening Restore in SSMS gave ‘Property BackupDirectory is not available for Settings’. I used a Profiler trace to find where it comes from and fixed it.
What is a Backup Timeline for Restore Process? – Interview Question of the Week #092
Question: What is a Backup Timeline for Restore Process?
Answer: One of the most popular interview question about Backup and Restore Database process.
SQL SERVER – Simple Example of BCP Command Line Utility
Need to export table data fast? A step by step, simple example of the BCP Command Line Utility, from finding bcp.exe to running the export.
Automated Restore Tests: Proving Backups Work Every Week
Schedule restore tests that select current backups, move files to an isolated server, run CHECKDB, record failures, and rotate databases.
Writing a Disaster Recovery Runbook: RPO, RTO and a Restore Test
Build a disaster recovery runbook around agreed RPO and RTO, usable backup chains, instance dependencies, clear roles, and restore tests.
How to Attach a Database Without Log File in SQL Server
To attach a database without log file, run CREATE DATABASE with FOR ATTACH_REBUILD_LOG, or remove the missing log in the SSMS Attach dialog. This tutorial builds a demo database, detaches it, and rebuilds the log on attach. It also explains when the rebuild is impossible and what to check afterward.