Restore Multiple Databases from single backup file at same time

Question

4.00/5 (1 vote)

See more:

Hello,
I am using following query to restore the database. It’s working fine and I am able to restored the database.

SQL

RESTORE DATABASE RestoreDBName
 FROM DISK = 'D:BackUpYourBaackUpFile.bak'
 WITH MOVE 'MDFLogicalName' TO 'D:RestoreDBName.mdf',
 MOVE 'LDFLogicalName' TO 'D:RestoreDBName.ldf',
 NOUNLOAD, REPLACE, STATS = 10;

But there is a scenario in my application, in which multiple user can request for restoring the database from the single backup file( in SQL Server).
I am using SQL Packages for restoring DB, however I am getting restoration failed error when more than one user trying to restore the DB at the same time.
If there are 5 users trying to restore the DB from the single backup file, then only 3 are able to get restore done and rest 2 users are getting the error for restoration failed.

It would be appreciable if anyone suggest me the solution to get this problem resolved.

Thanks in advance.
_Rahul

Posted 30-May-12 2:47am

RD Sh

Updated 30-May-12 2:57am

Maciej Los

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Corporal Agarn · Answer 1 · 2012-05-30T03:13:00

Solution 1

Is it possible to copy the backup file to the user so they can restore from it?

If you need to restore a backup to multiple computers have you thought about using some sort of replication? (Mirroring)

Posted 30-May-12 3:13am

Corporal Agarn

Comments

RD Sh 30-May-12 10:17am

It’s okay if I copy the backup file for every requested user, but would it be okay to copy from a single backup file(which is 300 MB in size) for every requested user on the same moment?

Corporal Agarn 30-May-12 10:43am

Why are they at the same moment? It seems that they could access the original database (read-only) and save the trouble.
Anyway, coping 300 MB should not be a big problem. It is like copying any file.

RD Sh 30-May-12 23:23pm

No, they can't access the original database. There are certain changes in the restored database once the restore done.

Time being, I will copy the backup file for the requested db user and restore the database from copied backup file.

Thanks djj