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 |
|
mohan.dba
Starting Member
1 Post |
 Posted - 2011-12-09 : 06:53:31
|
| how to check backup is valid or not in mssqld.mohan |
|
|
lappin
Posting Yak Master
182 Posts |
Posted - 2011-12-09 : 07:13:48
|
| http://www.mssqltips.com/sqlservertip/1093/verifying-backups-with-the-restore-verifyonly-statement/ |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-12-09 : 13:33:49
|
| The only way to sure a backup is good is to actually restore from that backup. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-12-10 : 07:09:39
|
| ... and then preferably run DBCC CHECKDB. You can do this on another machine, which will prove that the database on primary machine was not corrupted (at the time the Full Backup was taken) |
|
|
|
|
|
|
sql backup