Yes, you can restore SQL7 backups (db and/or log) to SQL2000 (or Yukon).
The upgrade will happen after the restore is complete (WITH RECOVERY).
We do not support WITH STANDBY when an upgrade is needed.
--
Gang He
Software Design Engineer
Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"James Cheung" <fu********@yahoo.com> wrote in message
news:9d*************************@posting.google.co m...
Is it possible to load both the SQL 7 database and transaction log
backups to SQL 2000 ? I assume it will perform the upgrade during the
load.
Thanks,
James