Toad World® Forums

Copy/Move Database - will not start SQLAgent in the correct SQL Server Instance.


#1

In the graphic below, I was attempting for the first time to test the feature
Copy/Move database. When it came up with the message below.

Well The Wizard could not start the SQL Server Agent. This may be because it
is trying to start SQL Server Agent (MSSQLSERVER) which is a SQL Server 2008 R2,
a SQL Server instance that was not started as show below in the graphic below my
signature.

I further speculate that it (Wizard) did not know that there was another
instance SQL Server Agent (SS_2005_DEV), and it wanted to start SQL Server Agent
(MSSQLSERVER).

So I then started the aforementioned service and got this error.

So I consider this a bug because it is nominal to have more than one instance of
SQL Server running on a system regardless of the version. I was able to
prove that this was the case for I then started the SQL Server 2008 R2 à (SQL
Server (MSSQLSERVER)) and then the Wizard went to the next step. The wizard
completed and the job ran to a proper and satisfactory completion.

WOW !!! It worked …. Regardless… Soo the bottom line here is the
software needs to check for existence of a SQL Server Agent for other than the
Default of

(SQL Server (MSSQLSERVER))

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678-414-0090 my cell Primary

image001.gif

image004.jpeg

image007.jpeg

image009.jpeg

image010.jpeg

image011.png