Microsoft KB Archive/119717

{|
 * width="100%"|

PRB: SQL Transfer Manager Fails with Destination/Source Error

 * }

Q119717

-

The information in this article applies to:


 * Microsoft SQL Server versions 4.2x, 6.0

-

SYMPTOMS
When you use SQL Server Transfer Manager to transfer a database from one server to another where the database names are the same, the transfer may fail with the error:

The destination database must be different from the source database

CAUSE
If the source server and destination server have different names, two situations may cause the above error.

The first situation is that either the source or destination server name used was actually an alias server name that points to the same server. This situation can be checked by running the SQL Server Client Configuration Utility on the computer running Transfer Manager and checking the entries in the "Advanced" configuration window for aliases.

The second situation is that one of the server installations was a copy of the other. Either the MASTER.DAT may have been copied over or a MASTER database dump was loaded. This means that the entry for the local server in the SYSSERVERS table is identical for both the source and destination servers, and the @@servername global variable will contain the same name.

To confirm that this is the problem, run the following query on both servers:

  select @@servername

WORKAROUND
If "select @@servername" returns the same results on both the destination and source servers, you will need to determine which server needs to be updated. You can then run the following script to update the correct server:

  sp_configure allow, 1 go  reconfigure with override go  update master..sysservers set srvname = "", srvnetname = "" where srvid = 0 go  sp_configure allow, 0 go  reconfigure with override go

You will then need to stop and start SQL Server to get the global variable @@servername to be updated with the correct server name.

Additional query words: sql6 Transfer Manager

Keywords : kbtool

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600 kbSQLServ420OS2