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.

Comments

Popular posts from this blog

Agent Installation on Windows Server. SQL Server (Failover Cluster) target addition in OEM 12c

Oracle 10g/11g Linux:SMS the alert logs ORA- errors generated in timestamp

Oracle 11g: Install Instant Client 11.2.0.3.0 on Linux x86_64 Server.