How to identity the .BAK file is Valid / Not ?

Posted by Sarvesh under Sql Server on 11/10/2009 | Views : 1536 | Status : [Member] | Replies : 1
hi experts

i have one .bak (db backup file). how to identity the backups are valid and can be restored without any error ?

thanks in advance
sarvesh s




Responses

Posted by: Pandians on: 11/11/2009 [Member] [MVP] Silver

Up
0
Down
Hi Sarvesh

It will list the Logical Name, Physical Path, Size and LSN information (or) It will throw an Err :
RESTORE FILELISTONLY FROM DISK='<BACKUP FILE PATH>'

It will confirm that the Backupfile can be readable / not (or) It will throw an Err :
RESTORE VERIFYONLY FROM DISK='<BACKUP FILE PATH>'

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Sarvesh, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response