database restore in stuck while uploading in the remote server

Question

0.00/5 (No votes)

See more:

Dear Sir/Madam,

There is a problem in database restore and it is in stuck when i uploading the database back up file in the remote server.Now when i try to delete the database from the server and create another database it could not.Please help me, what should i do?

Suraj Bhakta

Posted 3-May-12 1:40am

suraj bhakta01

Add a Solution

Comments

Corporal Agarn 3-May-12 14:32pm

Are you copying the backup to the server where it is to be restored?
If SQL Server you may be able to restore again and tell it to overwrite. See option page.

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)

milenalukic · Answer 1 · 2012-05-03T13:32:00

Hi,

To restore a database you will need to modify it to single user. Then after it is restored change it back to multi user.

You do this by right clicking on the database and selecting properties. Go to options. Then on the right hand side scroll to the bottom and amend the Restrict Access value to single user.