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 Programming
 to know what is there in a backup

Author  Topic 

saikiran
Starting Member

10 Posts

Posted - 2012-12-19 : 00:51:28
please anybody give me a information how can i see what is there in a backupfile without restoring .

sai

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2012-12-19 : 03:55:31
have a look at restore headeronly.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

saikiran
Starting Member

10 Posts

Posted - 2012-12-19 : 09:37:50
thank u for ur reply i found it "restore file list only from='path'

sai
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2012-12-19 : 21:16:49
Even when you try with Management Studio when you try to restore It will give you information about backups
Go to Top of Page

saikiran
Starting Member

10 Posts

Posted - 2012-12-20 : 03:55:52
k

sai
Go to Top of Page
   

- Advertisement -