Restore a MS SQL 2000 backup over MS SQL 2005 instance

Dje

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

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.

Dje

Thanks petey.