Database Experts:Copy Database on SQL Server 2008 R2

Copy Database from One SQL Server to Another SQL Server using Copy Database Wizard Use this link to know more about Copy Database, Copy Database Wizard Source:SQL Server 2005 Destination:SQL Server 2008R2 1.Connect to Source database. 2.Right click on Databases-->DatabaseName-->Task-->Copy Database. Choose best method to suits you. Map Database to move or copy. Wait while for completion of Copy of Database.