How can we help you today? How can we help you today?

Restore a MS SQL 2000 backup over MS SQL 2005 instance

Hi,

Is it possible to restore a .SQB taken on a MS SQL server 2000 instance to a MS SQL server 2005 instance ?
What's the cost of a such operation ?
Does the .SQB is automatically converted to 2005 by SQL Backup or will the DB be restored as a 2000 version and then upgraded to 2005 ?

Regards,
Jerome
Dje
0

Comments

2 comments

  • petey
    Yes, it is possible to restore a SQL 2000 database backup on a SQL 2005 instance. The conversion is performed by SQL Server.

    See http://www.yohz.com/sqb_data.html for details on how SQL Backup interacts with SQL Server.
    petey
    0
  • Dje
    Thanks petey.
    Dje
    0

Add comment

Please sign in to leave a comment.