May 18, 2015 at 2:07 pm
One of the things I was told initially, make sure you backup your databases. And further, make sure your backups are good. After doing some reading - it looks as if using the checksum option may be the appropriate route to go. But should you stop there? It looks after you should copy the backup file to another server and restore the database there. And finally run a CheckDB against that database.
Is this your best option to confirm you have good backup files? Comments / URLs are appreciated.
Thanks.
Syntax:
backup database TestDB to disk = 'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\iCenter\TestDB.bak'
with NOINIT,CHECKSUM;
RESTORE VERIFYONLY
FROM DISK = 'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\iCenter\TestDB.bak'
WITH CHECKSUM
USE [TestDB]
GO
DBCC CHECKDB(N'TestDB') WITH NO_INFOMSGS
May 18, 2015 at 2:36 pm
jralston88 (5/18/2015)
One of the things I was told initially, make sure you backup your databases. And further, make sure your backups are good. After doing some reading - it looks as if using the checksum option may be the appropriate route to go. But should you stop there? It looks after you should copy the backup file to another server and restore the database there. And finally run a CheckDB against that database.Is this your best option to confirm you have good backup files? Comments / URLs are appreciated.
Thanks.
Backups are worthless, Restores are priceless.
To really test your backups you should restore the database either under a different name or to a different server used to test database restores.
May 19, 2015 at 4:57 am
I've got a short article[/url] on all the steps to really ensure that your backups are good.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply