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)
 Multiple Log Files SMO

Author  Topic 

MTmace
Starting Member

7 Posts

Posted - 2007-01-24 : 15:32:42
I need to restore a database that has a bak file and many log files. Is there a way I can do this with one recovery step?

Or do I need to use a different restore object for each file?

MTmace

madhuotp
Yak Posting Veteran

78 Posts

Posted - 2007-01-25 : 00:24:34
It can be done only in one step

use RESTORE FILELISTONLY to get the list of filenames.

Then just use the normal restore command with whatever option u need.

Madhu
Go to Top of Page
   

- Advertisement -