SQL Server - what is the best to move a database between to another computer

[LouWilk]

Hi, I need to move several databases to another computer, is there a utility for this on SQL 2005 server? I hope I don't have to recreate the database and tables. I'm new to this, so thanks for the help. Lou

[scottgp]

I would think the easiest would be to detach them, copy them over, and reattach them. Alternatively, you can back them up and restore them. Both methods are pretty simple. Scott

[St_Pierce]

First a given, backup the database. Then you could use the backup to "restore" to the new computer. This works well because it should copy the permissions of the database too. here is some additional reading from microsoft's site, Hope this helps... http://support.microsoft.com/kb/314546/en-us There are other ways as well but this may be the easiest for someone new to SQL server.

St_Pierce My Store