SQLUSA

Microsoft SQL Server 2000

Best Practices

 

How to copy a database to a different server?

 

Backup the database with full-backup option. Copy over the backup file to destination server. Restore it with "MOVE FILE" options if the file folder structure and naming not the same.

Make sure the appropriate logins setup on the destination server.

Best in the World in SQL Server Training
 
SQLUSA.com Home Page