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 servers 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. In this case you must rename the database at a later point in the wizard.
To use the Copy Database Wizard, you must establish a connection to both the source and destination server with a login that is a member of the sysadmin fixed server role. The two servers must conform to version rules. The destination server must be an instance of SQL Server.
Options
Destination server
Select the name of the server 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 you select only shared drives on a clustered destination server.
Use Windows Authentication
Allow a user to connect through a Microsoft Windows 2000 user account.Use SQL Server Authentication
Allow a user to connect by providing a SQL Server Authentication user name and password.User name
Enter the user name to connect with. This option is only available if you have selected SQL Server Authentication.Password
Enter the password for the login. This option is only available if you have selected SQL Server Authentication.Next
Connect to the server and validate the user. This process checks whether the user has the permissions listed above on the selected computers.