In sql server 2008, i have taken Full backup type of my database and database was successfully done.My question is while restoring it how can i check or know that my whole backup was perfect ?
A:
Martin Smith
2010-06-02 06:43:51
A:
The DB won't come on-line if something is wrong most likely.
Although, you can run RESTORE VERIFYONLY, you're more likely to restore the wrong DB or from the wrong backup file to be honest.
If you want you could run DBCC CHECKDB.
I tend to query a known table for the last "updateddatetime" column
gbn
2010-06-02 06:44:04
thanks buddy ,RESTORE VERIFYONLY does not attempt to verify the structure of the data contained in the backup volumes. i cant get wht is - structure of the data ?
Dhiva
2010-06-02 06:56:18
@Dhivagar: what do you mean? DBCC CHECKDB on a backup file?
gbn
2010-06-14 17:24:23