Migrating SQL Server 2000 to SQL Server 2005 - Part 1

In most of the projects, we used to work on migration work. In order to incorporate new features and advantages our application should be upgraded to support advanced software systems. SQL Server 2000 databases can be upgraded to newer version to support Database mirroring, Support to Ranking functions, Performance improvements and many more. During migration, we need to take backup of our existing SQL Server 2000 database and restore the same in SQL Server Management Studio.
1. Right click Databases -> Restore Database.









2. Click Restore Databases, you will be getting a restore window. Select the database name and specify the source for restore -> specify the *.bak file from your local drive by clicking “Add” button.

In some cases, we won’t have backup files. Instead, we will be having Database files as,
a. Master Database file (Primary) - MDF
b. Secondary Database file (Secondary) – NDF (Optional one)
c. Log Database file (Log File) – LDF
In this case, we have to detach these files from the existing SQL Server 2000 databases and attach the same using SSMS.
Right click Databases ->Attach -> Click Add button in the databases to attach and specify the mdf file location.

Now, you got your database right...

Happy Learning!!!

Regards,

Venkatesan prabu. J