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 db from several .bak files

Author  Topic 

chih
Posting Yak Master

154 Posts

Posted - 2007-03-21 : 02:47:26
Hi,

I backup db into several .bak files to reduce backup time. but how can I restore them back? Do I have to do it by scripts? Can I restore it by using management studio?

cheers

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-03-21 : 12:30:33
in object explorer, right click on the "databases" folder and you'll see "restore database..."


www.elsasoft.org
Go to Top of Page

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-03-22 : 01:34:14
You can do both ways...
Check BOL for systax to use script...

MohammedU
Go to Top of Page

chih
Posting Yak Master

154 Posts

Posted - 2007-03-22 : 01:40:36
what is BOL?
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-03-22 : 05:13:52
BOL = Books Online - the Help files that come with SQL Server (also available on Microsoft's web site)

Kristen
Go to Top of Page
   

- Advertisement -