Steps to upgrade SQL server 2000 database to SQL server 2005

Upgrading from Microsoft SQL Server 2000 database to SQL Server 2005 database involves the following steps:

I. Backup the SQL server 2000 database.
II. Importing the database from SQL Server 2000 to SQL Server 2005.

I. Backup the SQL Server 2000 Database.

Below mentioned steps is used to backup the database of SQL Server 2000.

i. Open SQL Server 2000 Enterprise Manager.
ii. Expand Microsoft SQL Servers.
iii. Expand ...

Updated 07-03-2009 at 03:07 AM by kenn

Categories

Uncategorized