Always restore with NORECOVERY

Steve Jones, 2012-05-28 (first published: 2012-05-24)

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

Share

Share

Rate

Related content