Web Hosting India - a Delhi based cheap affordable shared reseller windows web hosting company.
Home About us FAQ Search Domain Search for a domain name
Bookmark this page

Web Hosting Company Contact Information
Contact web hosting company in New Delhi India

Convert MS SQL2000 database backup to SQL 2005 Database.



The procedure describes how we can convert a MS SQL2000 database to a SQL 2005 database.

  1. Backup your MS SQL2000 database. (Learn how to take a database backup in Plesk
  2. Move your SQL2000 backup file to the MSSQL 2005 Backup folder, which most probably in your computer be "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup". Alternatively, you can keep the SQL2000 backed up file anywhere you want, just remember the path.
  3. Now launch "SQL Server Management Studio Express".
  4. Now open a new query window by clicking on "New Query" from the Tool bar.
  5. We will now use the 'Restore With Move' command to Restore the MS SQL2000 backed up database and at the same time convert it to a MS SQL 2005 Database.
  6. The Query we will be using is listed below:
    RESTORE DATABASE (DatabaseName)
    FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\
                Backup\BackedUp2000DatabaseName'
    WITH MOVE 'DatabaseName' TO 'C:\Program Files\Microsoft SQL Server\
                MSSQL.1\MSSQL\Data\DatabaseName.MDF',
         MOVE 'DatabaseName_log' TO 'C:\Program Files\Microsoft SQL Server\
                MSSQL.1\MSSQL\Data\DatabaseName_Log.LDF'

    P.S. There are no line breaks in the directory paths. The lines have been broken to accommodate the query comfortably in the page.
    'From Disk' is the backed up file location. 'MOVE TO' is the location where the converted database and log file will be placed. You will need to use the commas and the inverted commas as indicated.
  7. Copy the query in the new query window and click 'Execute' or press F5 to run the query. You will get a message with Success Report.
  8. Refresh your "Databases" list and you should see your new database listed there.
  9. Right Click your database and click on "Properties" >> Select "Options" >> Within "Compatibility level" select "SQL Server 2005(90)" >> Click on "OK" and wait for the process to finish.
  10. Your database is now successfully converted to MS SQL2005 database.


Misc: