Is your database stuck in restoring state after you restored all backups? RESTORE DATABASE WITH RECOVERY brings it online. I show what to run and when.
SQL SERVER – A Practical Use of Backup Encryption
A backup in the wrong hands is a data leak waiting to happen. Here is a practical example of Backup Encryption in SQL Server 2014 to keep your backups safe.
Post-Restore Checklist: Owner, Trustworthy, Broker and Users
The restore finished with no errors, yet the app cannot connect. Here are the four settings a restore quietly changes, and how to fix them.
SQL SERVER – SSMS: Backup and Restore Events Report
Backups look trivial until the day a disk crashes. The Backup and Restore Events report in SSMS shows the history of those tasks for a database.
SQL SERVER – Backup to Azure Blob using SQL Server 2014 Management Studio
SQL Server 2014 Management Studio has a new URL option on the backup screen. Here is how to use backup to URL to take a database backup to Azure Blob storage.
Finding Databases That Have Never Been Backed Up
Your backup job is green, but is every database in it? Here is a read-only way to find the ones missing from msdb history.
Attach a Database in SQL Server and Detach It Safely
To attach a database, use CREATE DATABASE with FOR ATTACH and point it at the data and log files. This post detaches a demo database, attaches it again, shows the error that stops a detach, and compares the old sp_attach_db procedure with the current statement.