SQL Database error when transferring from one server to another

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 15 points N/A #178118

SQL Database error when transferring from one server to another

qa-featured

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

Related Questions