finding which file to restore from?

Question

finding which file to restore from?

SSCoach

Points: 19500

April 30, 2007 at 5:13 am

i know that a backup device can have multible backups within it, and you can restore to a specific one using the below script:

RESTORE DATABASE MyAdvWorks   FROM MyAdvWorks_1   WITH NORECOVERYRESTORE DATABASE MyAdvWorks   FROM MyAdvWorks_1   WITH FILE = 2

What i want to know is , besides using the SMSS interface, is there a script 
that can be used to tell you how many files in a particular backup device, and the
date those backups were created at?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

James Moore (Red Gate) SSCrazy Points: 2644 More actions · Answer 1

Winston,

Have a look at RESTORE HEADERONLY and RESTORE FILELISTONLY,

- James

--
James Moore
Red Gate Software Ltd

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 2

Apart from that have a look at the backup tables to know which file to restore from.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com