Upgrade to Sql 2000 with minimal downtime

[Scott]

Hello,
I'm upgrading from SQL 7 to SQL 2000 on another box. To minimize the
downtime I would like to
1) backup my sql 7 database,
2) copy it to the new box with SQL 2000 already installed,
3) restore the database on the SQL 2000 box,
4) Shutdown my sql 7 database,
5) Copy the transaction logs to the SQL 2000 database,
6) Restore the transaction logs to the SQl 2000 database,
7) Bring up SQL 2000.

My only concern with this is restoring the transaction logs that were
created on SQL 7 to SQL 2000. Do you know if I can do this?

Do you see any (other) problem(s) with my plan.

Thanks, Scott

[John Bell]

Hi

Full backup/restore on their own should be quick enough!

Alternatively you can detach/attach (the data file and transaction log will
be automatically updated).

There may be some compatibility issues so you should test everything before
do a live cut over.

John

"Scott" <sc*******@eds.com> wrote in message
news:31**************************@posting.google.c om...

Hello,
I'm upgrading from SQL 7 to SQL 2000 on another box. To minimize the
downtime I would like too
1) backup my sql 7 database,
2) copy it to the new box with SQL 2000 already installed,
3) restore the database on the SQL 2000 box,
4) Shutdown my sql 7 database,
5) Copy the transaction logs to the SQL 2000 database,
6) Restore the transaction logs to the SQl 2000 database,
7) Bring up SQL 2000.

My only concern with this is restoring the transaction logs that were
created on SQL 7 to SQL 2000. Do you know if I can do this?

Do you see any (other) problem(s) with my plan.

Thanks, Scott