Discussion in 'SQL Server 2005 General DBA Questions' started by Joben, Jan 7, 2011.
What is the best way to move databases from one to another server?
You can find the same question in severals post in our Forums.
Use search option and back again.
There are many methods available, backup-restore, attach-detach,copy db etc.. go through BOL or msdn sites..
As Luis suggested this is a frequently asked question here, so you will find relevant information by searching on forums. Also here is the http://support.microsoft.com/kb/224071 KBA that will give a startup options.
Separate names with a comma.