Printed 2016/05/30 04:25PM

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