Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions Links


SQL Server DBA Jobs

Schrodinger’s backup - A warning for DBAs

30 December,2016 by Tom Collins

Schrodinger's backup - It’s about the restores not the backups. You can receive  many successful backup emails, but one restore failure can cause some serious havoc. What do you have in-place to maximise the probability of a successful restore?

Backups are easy , restores are hard.




The term  Schrodinger's backup comes from Schrodinger's cat experiment 

Read more on SQL Server Backup b& Restore topics 

Danger of maintaining SQL backup copies in different locations ...

Database backup does not cause blocking (SQL Server DBA)

Differential backup cannot be restored . BACKUP with COPY_ONLY ...

Database has more than 1000 virtual log files which is excessive

Backup history for a single SQL Server database (SQL Server DBA)




Author: Tom Collins (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on Schrodinger’s backup - A warning for DBAs | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer