Printed 2015/11/26 04:28PM

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
Copyright © 2002-2015 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.