Blog Post

Always restore with NORECOVERY

,

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

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating