Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- sys.dm_server_services - How to check if SQL Server service is running or not?
- Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
- Can we restore a database to an older version in SQL Server?
- How do I save all SQL Agent Jobs
- How to view SQL Server mount point space without access to server
- DBCC SHRINKFILE: page could not be moved because it is a work table page.
- SQL Agent Last Modified explanation
- Sql certificate chain was issued by an authority that is not trusted
- sqlserver-dba.com switching from feedburner to follow.it
- Taking transaction log backup and full back at the same time
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 (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
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.
Posted by: |