Link to home
Create AccountLog in
Avatar of PDSWSS
PDSWSS

asked on

Why do I get the attached error message when I attempt to restore an SQL DB?

We have a test and production server. We have the same DB on both servers. The one on production is more current.

I have restored a backup of the  DB from the production server onto the test server many times in the past. This has been done with the admin account and remote desktop.
Now when I attempt to restore the same DB from production to the test server I get the attached error message. Please advise. Thanks,
Screen-Shot-2013-02-08-at-4.48.3.png
ASKER CERTIFIED SOLUTION
Avatar of Abhishek Chakravarty
Abhishek Chakravarty
Flag of India image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Anthony Perkins
Now when I attempt to restore the same DB from production to the test server I get the attached error message
There are a couple of reasons:
1.  You are not using the REPLACE clause.
2.  There are users already connected to the target database you are trying to overwrite.
Avatar of PDSWSS
PDSWSS

ASKER

The admin passwords for the 2 servers are different. Since I was using the admin password to
restore the DB from the other server it would not allow it.

Thanks for your input.
Avatar of PDSWSS

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for PDSWSS's comment #a38877465

for the following reason:

I realized that I should not have been using the admin password to restore from the other server since the passwords do not match. Thanks,
Avatar of PDSWSS

ASKER

Please reopen this question.

AC perkins provided the correct solution. This expert provided the solution to why my AD password also did not work. Would like to give this expert the points. Thanks
AC perkins provided the correct solution. This expert provided the solution to why my AD password also did not work. Would like to give this expert the points.
I suspect the author meant abhichakravarty.  I will go ahead are reopen the question so they can close it appropriately.
Avatar of PDSWSS

ASKER

No ac perkins wrote below and #1 is the solution.  

There are a couple of reasons:
1.  You are not using the REPLACE clause.
2.  There are users already connected to the target database you are trying to overwrite.

However, not clear to me how ac perkins provided the correct solution and can also decide to reopen the question. To me that is a clear conflict of interest.