http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspxThere 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 copyingen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspx#10416616Tue, 07 May 2013 12:55:04 GMT91d46819-8472-40ad-a661-2c78acb4018c:10416616 '<p>jghjgh</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10416616" width="1" height="1">http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspx#10405266Tue, 26 Mar 2013 00:33:27 GMT91d46819-8472-40ad-a661-2c78acb4018c:10405266zlab<p>This is a complete procedure to transfer database and logins from an istance to a new one, scripting logins and relocating datafile and log files on the destination. Everything using metascripts.</p> <p><a rel="nofollow" target="_new" href="http://zaboilab.com/?page_id=368">zaboilab.com</a></p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10405266" width="1" height="1">http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspx#10387976Thu, 24 Jan 2013 15:51:29 GMT91d46819-8472-40ad-a661-2c78acb4018c:10387976Waqas M<p>Good work</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10387976" width="1" height="1">http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspx#10329834Sat, 14 Jul 2012 06:04:36 GMT91d46819-8472-40ad-a661-2c78acb4018c:10329834Ismail<p>Thanks. It solved my problem</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10329834" width="1" height="1">http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspx#10328315Tue, 10 Jul 2012 10:28:43 GMT91d46819-8472-40ad-a661-2c78acb4018c:10328315SiFlu<p>the origin database is on an english (language) server and should be copied to an german(language) server.... is it just backup and restore ?</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10328315" width="1" height="1">http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspx#10268164Wed, 15 Feb 2012 10:52:48 GMT91d46819-8472-40ad-a661-2c78acb4018c:10268164Shamim<p>Goood Explantion</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10268164" width="1" height="1">http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspx#10211487Thu, 15 Sep 2011 06:58:51 GMT91d46819-8472-40ad-a661-2c78acb4018c:10211487miamikk<p>Check out this article from Microsoft on transferring logins. </p> <p><a rel="nofollow" target="_new" href="http://support.microsoft.com/kb/918992">support.microsoft.com/.../918992</a></p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10211487" width="1" height="1">http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspx#10206580Tue, 06 Sep 2011 05:24:21 GMT91d46819-8472-40ad-a661-2c78acb4018c:10206580SREEKAR M [MSFT]<p>Hello Matheus</p> <p>Thanks for the comment.</p> <p>In order to copy logins as well, you can use </p> <p>i) Copy Database Wizard approach by selecting the server side options in the wizard</p> <p>ii) SMO Transfer by specifying scripting options.</p> <p>In the other scenarios, logins are not copied.</p> <p>Thanks</p> <p>Sreekar</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10206580" width="1" height="1">http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspx#10200498Thu, 25 Aug 2011 19:27:13 GMT91d46819-8472-40ad-a661-2c78acb4018c:10200498Matheus<p>What about the logins? Do you know how can I manage do migrate the logins??</p> <p>Thanks</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10200498" width="1" height="1">