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 |
|
jemacc
Starting Member
42 Posts |
 Posted - 2008-09-05 : 12:25:37
|
| I have backups from a database using multiple backup files, how is a restore created to support this--backup Database to multiple file.BACKUP DATABASE [yourddb] TO DISK = 'C:\yourdb_1.bak', DISK = 'D:\yourdb_2.bak', DISK = 'E:\yourdb_3.bak', DISK = 'F:\yourdb_4.bak' WITH INIT , NOUNLOAD , NAME = 'Database backup', NOSKIP , STATS = 10, NOFORMAT |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jemacc
Starting Member
42 Posts |
|
|
jemacc
Starting Member
42 Posts |
Posted - 2008-09-08 : 08:46:39
|
okay I found and test my answerRESTORE DATABASE [TEST] from DISK = N'C:\TEST_1.bak', DISK = N'C:\TEST_2.bak', DISK = N'C:\TEST_3.bak', DISK = N'C:\TEST_4.bak' WITH FILE= 1 ,NOUNLOAD ,REPLACE ,STATS = 10 CREATE DATABASE TESTquote:
Originally posted by jemacc
quote:
Originally posted by tkizer
What is your question?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
How do you restore the database that has multiple backup files?
|
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-13 : 23:54:38
|
Correction:quote:
Originally posted by jemacc
okay I found and test my answerRESTORE DATABASE [TEST] from DISK = N'C:\TEST_1.bak', DISK = N'D:\TEST_2.bak', DISK = N'E:\TEST_3.bak', DISK = N'F:\TEST_4.bak' WITH FILE= 1 ,NOUNLOAD ,REPLACE ,STATS = 10 CREATE DATABASE TESTquote:
Originally posted by jemacc
quote:
Originally posted by tkizer
What is your question?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
How do you restore the database that has multiple backup files?
|
|
|
|
|
|
|
|
|
Restore from multi file backup