Copy Database Wizard (Select a Destination Server)
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.
Note
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.
Options
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.Note
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.