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

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts

How to get the exact property name while getting error (0)
PDB file is not showing Line Number in dot net application hosted on server (0)
Both Strings morethan 5 letters in length end of the words one vowel and one consonent is different (0)
how to check Any adjacent letters transposed between two strings(ex: JOHN, JHON) (1)
can't receive data after success login ? (1)
Implement Multi-Tenant in Azure Logic Apps (0)
Why ASP.Net Core 7.0 Web API showing as Connection refused? (0)
Iterating over columns of dataframe and print as rows in Python Django (0)
More ...