Always, always, ALWAYS restore a SQL Server database with the NORECOVERY option.
It’s trivial to switch the database online.
Not trivial to recover from an accidental restore with RECOVERY (the default)
‘nuff said.
Filed under: Blog Tagged: Backup/Recovery, disaster recovery, sql server, syndicated 
Remember kids...
Anyone who knows me knows that I’m a big proponent of automating routine tasks. If I have to do...
2012-01-26 (first published: 2012-01-23)
3,523 reads
I want to say a few things about database backups that you need to know.
Wait a minute, haven’t you written...
2012-01-16 (first published: 2012-01-11)
5,132 reads
I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show...
2012-01-03 (first published: 2011-12-30)
72,797 reads
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...
2011-04-05
1,493 reads
In the early days of SQL Server you could not run a log backup while a full backup was running....
2011-02-07
1,926 reads
