Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sumeshbnr
Starting Member
3 Posts |
 Posted - 2009-01-09 : 09:13:29
|
| Hi All,Is there any way to check a SQL backup files consistency ? We have a remote SQL server and we are keep backing up and transfer through FTP .Some times the unable to restore from the file when we need a restore.Thanks, |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-01-09 : 09:31:12
|
| Look for RESTORE VERIFYONLY in BOL. It will verify that backup is readable.Keep in mind that using the RESTORE VERIFYONLY statement is not a guarantee of reliable data restoration-it is merely to check the readability of the file. The only reliable way of knowing if backups will accurately able to restore the data is by performing an actual restore. |
 |
|
|
sumeshbnr
Starting Member
3 Posts |
Posted - 2009-01-09 : 11:22:25
|
| Many thanks |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-01-09 : 11:49:20
|
| If it is SQL Server 2005 or 2008 and the backup is down with the CHECKSUM option, even a single byte that is off in the backup data will cause RESTORE VERIFYONLY to report an error, so that is your best bet to make sure the backup file is good before you start a restore.CODO ERGO SUM |
|
|
|
|
|
|
check a SQL backup files consistency