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.
| Author |
Topic |
|
dejjan
Yak Posting Veteran
99 Posts |
 Posted - 2005-07-15 : 04:17:36
|
| Hello, maybe you could help me.I have a list of backup files in one folder:DBName_FULL_20050501_010000.bak (DBName_FULL_yyyymmdd_hhmmss.bak)DBName_LOG_20050501_100000.bakDBName_LOG_20050501_101500.bakDBName_LOG_20050501_103000.bak...and I want to restore DB. But I am not sure if 'DBName_LOG_20050501_100000.bak' is the first log file after Full Backup. How could I check it. I could run restore and wait for message that 'DBName_LOG_20050501_100000.bak' is not the first but my DB is around 100GB and I don't want to wait for half an hour.Is there any command or something which could read from bak files and gives me information I needThanks in advanced |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-15 : 04:35:28
|
| restore headeronlyfrom disk = 'C:\DBName_LOG_20050501_100000.bak'It gives you 'Backup start date' and 'Backup finish date' so that you can see and organize the order of the restore operation.Franco |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-15 : 08:28:01
|
| On the server that the backups were made using Enterprise Manager and the Restore Database option [i.e. on the Source database - best not to press the "Restore it now button" though!] will give you a graphic view of which Log backups (and Differential backups too if you have them) relate to which Full backupsKrisen |
|
|
|
|
|
|
Restore