How to restore SQL 2000 database to SQL 2008?

Fine Happy

AuthorEASEUS   Category Data Backup   Comments0   Post Time 2011-11-29 20:55:10 -0500

Restore a SQL Server 2000 or SQL Server 2005 database to SQL Server 2008, the database becomes available immediately and is then automatically upgraded. If the database has full-text indexes, the upgrade process either imports, resets, or rebuilds them, depending on the setting of the Full-Text Upgrade Option server property. If the upgrade option is set to Import or Rebuild, the full-text indexes will be unavailable during the upgrade. Depending on the amount of data being indexed, importing can take several hours, and rebuilding can take up to ten times longer. Note also that when the upgrade option is set to Import, if a full-text catalog is not available, the associated full-text indexes are rebuilt.

This document is about the solution to restore SQL 2000 database to SQL 2008 using SQL Server Management Studio and SQL backup and recovery software.

Under the full or bulk-logged recovery model, before you can restore a database in SQL Server Management Studio, you must back up the active transaction log (known as the tail of the log). See How to free backup SQL Server using SQL Server Management Studio?

To restore a database that is encrypted, you must have access to the certificate or asymmetric key that was used to encrypt the database. Without the certificate or asymmetric key, the database cannot be restored. As a result, the certificate that is used to encrypt the database encryption key must be retained as long as the backup is needed.
More detailed steps…

This document also recommends SQL backup and recovery software:
EaseUS Todo Backup Advanced Server, support Microsoft SQL Server 2008, 2005 and 2000. It can backup SQL Server database with full, differential or transaction log backups and save backup file to local hard disk or tape (see Tape backup vs disk backup), and restore database with a new name or move database files to a new location, restore database to the point of failure (See SQL Server disaster recovery plan).

Backup tutorial of EaseUS Todo Backup Advanced Server.

Free download this backup software to backup and restore SQL database.

Trackback URL Trackback: http://blog.easeus.com/action.php?action=tb&id=520

Tags Tags: sql backup and recovery software,easeus todo backup advanced server.,restore sql 2000 database to sql 2008

Comments List

Post a Comment

  • Name:
  • Email:
  • HomePage:
  • Comment:
  • Question:

Home | Solution | About Company | Contacts | Resource | Blog | Forum | Directory | Links | Sitemap

Copyright © 2005-2008 CHENGDU YIWO Tech Development Co., Ltd. ALL RIGHTS RESERVED.

Privacy Policy | License | Legal Counsel