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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 How to identify which type of backup file

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2010-04-19 : 11:42:54
Hi Experts,
i've faced this question in an interview.

How to identify a backup file whether it is Full, Diff or Log backup file. assume i've not used any naming convention. (not given as .trn for log backup). the file is simply a (.bak) file. how can i identify?

thanks in advance

Arnav
Even you learn 1%, Learn it with 100% confidence.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-04-19 : 11:49:37
RESTORE HEADERONLY gives you that info:
http://msdn.microsoft.com/en-us/library/ms178536.aspx


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -