Export (0) Print
Expand All

Copy Database Wizard (Select a Destination Server)

Updated: 5 December 2005

Use this page to specify the server where the database will be moved or copied. After you select the authentication method and enter user information, click Next to establish the connection to the destination server and to validate server and user information.

ms189724.note(en-US,SQL.90).gifNote:
If you set the source and destination servers to the same server instance, you will make a copy of a database on the source server.

To use the Copy Database Wizard, you must establish a connection to both the source and destination servers by using a login that is a member of the sysadmin fixed server role. The destination server must be an instance of SQL Server 2005.

Destination server

Enter the name of the server or server instance to which the database or databases will be moved or copied, or click the browse (...) button to locate a destination server.

ms189724.note(en-US,SQL.90).gifNote:
You can use a destination that is a clustered server. The Copy Database Wizard will make sure that you select only shared drives on a clustered destination server.

Use Windows Authentication

Let a user connect through a Microsoft Windows 2000 user account.

Use SQL Server Authentication

Let a user connect by providing a SQL Server Authentication user name and password.

User name

Enter the user name to connect with. This option is available only if you have selected SQL Server Authentication.

Password

Enter the password for the login. This option is available only if you have selected SQL Server Authentication.

Next

Click to connect to the destination server and perform the following validations:

  • The destination server is SQL Server 2005.
  • The destination server is not SQL Server 2005 Express Edition.
  • SQL Server Agent is running on the destination server.
  • SQL Server 2005 Management Tools are installed on the destination server.
  • The user is a member of the sysadmin fixed server roles.

Community Additions

ADD
Show:
© 2014 Microsoft