Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restore from Multiple Files Expand / Collapse
Author
Message
Posted Tuesday, January 11, 2011 10:56 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:38 PM
Points: 958, Visits: 3,266
Hello Everyone
I am in the planning stages of overwriting a database with a backup from another environment.

I took the backup by splitting the files because they were too large to copy across the network easily. I split them into 10 different files.

I am wanting to restore the database and allow the restore to overwrite the existing database, of the same name. How can I write the sql statement to do this? I don't believe I have ever had to do a restore this way.

Thanks in advance
Andrew SQLDBA
Post #1046028
Posted Tuesday, January 11, 2011 11:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:27 AM
Points: 6,997, Visits: 8,411
How did you split the backup files ?
Can you post your actual backup statement ?

If you used
BACKUP DATABASE AdventureWorks
TO DISK='X:\SQLServerBackups\AdventureWorks1.bak',
DISK='Y:\SQLServerBackups\AdventureWorks2.bak',
DISK='Z:\SQLServerBackups\AdventureWorks3.bak'

I would try this on a test system
RESTORE DATABASE MyDatabase
DISK='X:\SQLServerBackups\AdventureWorks1.bak',
DISK='Y:\SQLServerBackups\AdventureWorks2.bak',
DISK='Z:\SQLServerBackups\AdventureWorks3.bak'
WITH
NORECOVERY;

Keep in mind you can zip/7zip/ another compress tool your bak files to minimize copy network overhead.


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1046052
Posted Tuesday, January 11, 2011 12:33 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:38 PM
Points: 958, Visits: 3,266
Sorry, that did not work.

Andrew SQLDBA
Post #1046087
Posted Tuesday, January 11, 2011 1:03 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 07, 2014 3:56 AM
Points: 200, Visits: 778
Do you have to write script, can you just add the files in the GUI and do it that way?

'Only he who wanders finds new paths'
Post #1046106
Posted Tuesday, January 11, 2011 1:50 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:38 PM
Points: 958, Visits: 3,266
I cannot add more than on data file that way.

Besides that, I try to not use the GUI

Andrew SQLDBA
Post #1046145
Posted Tuesday, January 11, 2011 1:50 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 41,530, Visits: 34,447
AndrewSQLDBA (1/11/2011)
Sorry, that did not work.


Can you be a bit more specific? Did it throw an error and if so what error? Something else?

Can you post the backup command that you ran?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1046146
Posted Tuesday, January 11, 2011 2:51 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:38 PM
Points: 958, Visits: 3,266
Thank You Gila
I found my mistake

So silly, I am totally embarrassed

Andrew SQLDBA
Post #1046175
Posted Wednesday, January 12, 2011 12:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:27 AM
Points: 6,997, Visits: 8,411
A silly mistake happens to all of us every once in a while and with some even more frequent

Please provide the feedback on the backup creation script and the final restore that solved your problem.


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1046299
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse