469,927 Members | 1,777 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

Load SQL 7 database and transaction log backups to SQL 2000

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
Jul 20 '05 #1
4 1357
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

Jul 20 '05 #2
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. Does Microsoft has any formal documentation on that ?

Thanks,
James
Jul 20 '05 #3
Is there any formal documentation from Microsoft ?
What is "Yukon" ?

Thanks

"Gang He [MSFT]" <ga**************@microsoft.com> wrote in message news:<41********@news.microsoft.com>...
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

Jul 20 '05 #4
James Cheung (fu********@yahoo.com) writes:
Is there any formal documentation from Microsoft ?
Hm, I can't seem to find anything in Books Online in a hurry. But it
certainly works. Beside restoring a backup, detach/attach also works.
What is "Yukon" ?


Yukon is the codename for the next version of SQL Server, due to be
released next year. The official name is SQL 2005. It's currently in beta.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by serge | last post: by
reply views Thread by Vincento Harris | last post: by
3 posts views Thread by Bill E. | last post: by
5 posts views Thread by Seguros Catatumbo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.