troubleshooting Question
sql restore from 2 .bak files
asked on
What is the correct syntax. I need to restore one database called hat but I have 2 .bak files that need to be restored for 1 database. See my code below.. What is the correct way to write this?
RESTORE FILELISTONLY FROM disk = N'E:\Backups\hat0.bak'
RESTORE FILELISTONLY FROM disk = N'E:\Backups\hat1.bak'
-- Perform the restore of the database from the backup file.
-- Replace 'move' names (MDFLogicalName, LDFLogicalName) with those found in
-- the previous filelistonly command
restore database hat
from disk = N'E:\Backups\hat0.bak' and N'E:\Backups\hat1.bak'
with move 'hat_Data' to 'J:\MDFs\hat.mdf',
move 'hat_Log' to 'I:\Data\hat.ldf',
replace, stats=10;
RESTORE FILELISTONLY FROM disk = N'E:\Backups\hat0.bak'
RESTORE FILELISTONLY FROM disk = N'E:\Backups\hat1.bak'
-- Perform the restore of the database from the backup file.
-- Replace 'move' names (MDFLogicalName, LDFLogicalName) with those found in
-- the previous filelistonly command
restore database hat
from disk = N'E:\Backups\hat0.bak' and N'E:\Backups\hat1.bak'
with move 'hat_Data' to 'J:\MDFs\hat.mdf',
move 'hat_Log' to 'I:\Data\hat.ldf',
replace, stats=10;
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.