Copy Database From one Server to Another 1

[DDR]

Hi all. Wich is the best method to copy a database? using the wizard or doing a backup of the db then restoring it on the other server? Any other suggestions for copying entire Databases? I'm a novice in SQL server and a little advice will be appreciated.

 

[Guest_imported]

The fastest way is to make a backup file of the database, which will give you the database schema and data (and other extended properties and such). Although, I often use DTS (script generation) when I need to only copy the database schema.

 

[fluteplr]

Backup and restore is much faster. Be careful about users and logins though.

If there are logins on the old server that do not exist on the new server and will need to be there, you will want to set them up on the new server before restoring the backup.

 

[DDR]

Thank you for the repply!!. I'll use the back up method to make sure that all the data and and properties are imported.
Logins are not a problem since I use windows logins.