Copying Database Files from SQL Server 2005 to Higher Versions

Copying Database Files from SQL Server 2000 to Higher Versions

Try making a backup of your database, and restoring it into a brand new database.

• Create new DB.
• Make a full backup of your original.
• Right click on your new DB, hit restore.
• Navigate to your .BAK, and ensure the .mdf and .ldf match the new.

Note:In SQL Server 2005 Express edition there is no Copy Database Wizard, the n the above method is better for Copying database files from lower to higher editions.

If Copy Database Wizard available:

Following are the steps to copy database from one instance to another instance.

Specify Source Server

Specify Destination Server

Here you can select option if you want to keep the database ONLINE when it is being copied.

You can also select option of MOVE or COPY database as well.

Give appropriate database name.

On this screen you can select additional options to copy as well.

You create the package over here.

You can schedule the package using SQL Server Agent.

When this process is over it will show the success message and database will be copied to another server.