I have an archive database which is about 100GB+ and sets as .bak file. Try coping this file through a network which takes few hours by a normal copy and paste stuff.
The next day, the copy is finish but I need to know whether the copy is valid (complete). Is there anyway to find this? Cause looking the size what I found is not enough unless there are other ways.
Also ... I am thinking to test this copied backup file by doing a restore but it will take time and I don't have space at the moment. Is there any way to test the backup are still intact and valid backup. I know with SQL 2005 there is functionality for this but I am using SQL Server 2000 (SP3a).
But if restore verifyonly returns success it doesn't guarantee that the file is restoreable. The only way to know that is to actually perform a restore.
rlaubert - are you thinking of the improvements in SQL2005 where "restore verifyonly" goes quite a long way towards being confident that the backup is sound? ... but it still needs a Restore and some sort of validation like DBCC CHECKDB to be 100% sure
Check database backup
Posted - 03/05/2007 : 17:18:39
