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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Restore transaction logs with multiple files

Author  Topic 

codir
Starting Member

1 Post

Posted - 2009-08-12 : 19:08:49
I have multiple files, and in each file there are multiple transaction log backups appended.

I need to create and application that will go through all the files and within each file go through each backup and restore to a specific point in time.

The part I don't know is how to list the appended backups in a file and extract the start and end date for each

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-08-13 : 10:55:01
RESTORE HEADERONLY
FROM DISK = 'C:\MyBackups.bak'

Look it up in BOL
Go to Top of Page
   

- Advertisement -