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 2000 Forums
 SQL Server Administration (2000)
 backup and restore

Author  Topic 

acSQL
Starting Member

1 Post

Posted - 2008-08-05 : 19:05:12
Because the database was big, someone has divided the database into multiple .bak files. I don't know how they made that and my question is how I could restore the multiple .bak file into my sql2000 database? Any help will be appreciated.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-05 : 19:42:33
It's not a problem. Restore it in sequence and you should be good.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-05 : 22:59:54
>> how I could restore the multiple .bak file into my sql2000 database?

You have to restore from all those files at same time, like:

restore database db_name from disk = 'path\file1', disk = 'path\file2', disk = ... with ...
Go to Top of Page
   

- Advertisement -