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.
SQL SERVER – Fix Error – Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512
SSMS backup failed with ‘Cannot use the backup file because it was originally formatted with sector size 4096’. Here is why it happens and the easy fix.
How to Attach MDF Data File Without LDF Log File – Interview Question of the Week #078
Lost or corrupted your log file? Learn how to attach an MDF data file without the LDF log file, using T-SQL or SQL Server Management Studio.
Tail-Log Backup: Saving the Last Transactions Before a Restore
Take a tail-log backup before an approved restore, understand NORECOVERY and damaged-database options, and rehearse the full recovery chain.
What is a Master Database in SQL Server? – Interview Question of the Week #076
A reader told me he had dropped his master database. So here is the basic question: what is a master database in SQL Server, and why does it matter?
SQL SERVER 2016 – How to Import New Sample Database WideWorldImporters
SQL Server 2016 has a new sample database WideWorldImporters that replaces AdventureWorks. Here is how to install it on your server.