SQL Database error when transferring from one server to another

Asked By Andre A Dykema 0 points N/A Posted on - 01/04/2014

Hello All,

When attempting to transfer an SQL database from one server to another server using the Copy Database Wizard, I get an error which says SQL agent is not running on the destination server and that the wizard will not function properly. Here is what I tried: From the SQL Server Management Studio, I choose the option ‘Copy Database’. Now on Select a source server page, I specify the server with the database to move. After entering the login information and authentication method, I establish a connection with the source server. Now from Select a Destination Server page I selected the server to which the database is to be moved. Then select a transfer method and try to transfer the database when I get stuck with this error. Can anyone please tell me how to resolve this issue and proceed with the transfer? Your help will be greatly appreciated.

SQL Server Agent does not appear to be running on the destination server. If SQL Server Agent is not

running on the destination server, Copy Database Wizard will not function properly. Do you want to

continue?

• Status: Open
• Question Views: 1106
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Nichols Fryman 15 points N/A #178118

SQL Database error when transferring from one server to another

Hi Andre,
The error is because the database copy settings are incorrect in the system.
To resolve this error follow the steps mentioned below:
1) Click 'Start', select 'SQL Server Database' option from the list
2) In the SQL Server window, click 'Management', select 'Run a wizard' option
3) Create a unique Sharepoint on the source computer where the files are to be copied
4) Open the active connections in the source database
5) Select the database and set it as single user mode
6) Detach the source database from the list of databases
7) Attach the database to the destination server
8) Remove the unique Sharepoint settings from the database
9) Place the database into the normal working state

About Nichols Fryman

Questions
0

Answers
701

Best Answers
99

• Vote Up 0 Vote Down

• Posted on - 01/07/2014
• Question Category: MySQL Server