1. Copying Databases to Other Servers
http://msdn.microsoft.com/en-us/library/ms190436.aspx

2.How to: Upgrade SQL Server with the Copy Database Wizard
http://msdn.microsoft.com/en-us/library/ms190775.aspx

(两种方法,截图总结如附件)