Move a database from one server to another server in SQL Server 2008

There are many ways to move/copy a database from one server to another server using SQL Server Tools.i) Detach the database from the old server and attach it in the new server. This is purely offline operation and it moves the database instead of copying it.Refer http://msdn.microsoft.com/en-us/library/ms190209.aspx : how to use attach/detach database in SQL Server Management…

21