473,325 Members | 2,712 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

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 1469
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Rajesh Garg | last post by:
I will make it simpler to look... I have DB1 - as backup for day 1 LOg1 as backup of logs T1 T2 T3 T4 T5 ...some transaction on day 2 Now i backup again DB2 Log2
2
by: trotter | last post by:
I want to know if there is a "best-practice" for setting up Database Maintenance Plans in SQL Server 7 or 2000. To be more specific, I want to know the order in which I complete the tasks. Do I...
4
by: serge | last post by:
Running SQL Server 2000 Enterprise Edition SP3. The database is also used by Microsoft Project Server 2002 and also has OLAP views, so the database is being used to view/run cubes in the Analysis...
0
by: Vincento Harris | last post by:
I implement manual log shipping per http://www.sql-server-performance.com/sql_server_log_shipping.asp Full Backups are configured to overwrite current backups(backup with init) The process...
0
by: flobroed | last post by:
Hi, I've a question regarding the transaction-log backup on SQL-Server 2000. We have implemented a low cost replication. Every evening we make a full backup and beginning at 7 to 18 we make...
5
by: Steve | last post by:
Hi; I thought I would rephrase a question I asked in another post to more quickly get to the heart of the matter. My apologies for anyone who is offended by what appears to be a repetition. ...
4
by: Brian D | last post by:
In MS SQL 2005 when you do a Full Backup does it also backup and truncate the transaction logs or do I need to back the transaction logs up separately? Thanks. Brian
3
by: Bill E. | last post by:
I'm trying to restore a database backed up a production machine onto my development machine. I don't want to restore the transaction logs (there are two) because they are far too large and are...
5
by: Seguros Catatumbo | last post by:
Hi, i am using sql server 2000, and i make daily backups. I want to restore my backup to a test msde database i have. I don't know how i did it last time. -The database name is the same: "web"...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.