backup fails after moving db to new server

Question

backup fails after moving db to new server

SQLBill

SSC Guru

Points: 51440
More actions
June 26, 2003 at 7:01 am

#151867

I moved a database from one virtual server to another. I detached it from VS1, moved the .mdf and .ldf to their new drives and attached them to VS2.
I used Enterprise Manager to do the detach and attach. I can access the database, I can query the database, my users can get what they need from the database. I just can't back it up. I can successfully backup all my other databases on VS2, so I apparently missed something when I moved the database over.
What did I miss doing? Any suggestions?
-SQLBill

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

How are you doing your backups.

My guess would be that your backups are executed under the security context of a login which doesn't have access to your database.

M

[font="Verdana"]Markus Bohse[/font]

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 2

What error messages did you get? Login with 'sa' privilege to backup it to see whether you still have problem.

SQLBill SSC Guru Points: 51440 More actions · Answer 3

I'm running the backup as a scheduled job. It's step 6 in a 6 step job. All steps are database backups and 6 is the only one that fails.

The only error message is in the job history and that says it failed at step 6 (which is the database I can't backup). There are no messages in the Error Log nor in the os Event Logs. The message doesn't say anything about access issues. It just says it failed at step 6.

I checked the job to ensure it wasn't set to stop after step 5 and that it's not set to report failure after success.

I am running the jobs under DBO, I am the owner and sysadmin for SQL Server.

-SQLBill

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 4

I would try backup it from Query Anazyer and you may see some error message if it fails too. If it runs successfully, I would follow MarkusB suggestion to check the Agent service account privileges at both NT and SQL Server.

SQLBill SSC Guru Points: 51440 More actions · Answer 5

Here's more information:

I have a job set up that backs up this database. It's set to run as DBO. It fails. I run it under QA as me and it succeeds. I change the job to set it to run as me and it works fine.

How do I get DBO to work on this database again?

-SQLBill