July 7, 2002 at 9:35 pm
Setting: Test lab, Sql 7 with Sp 4. Want to upgrade all Sql 7 DB's to run under Sql 2k.
I installed a clean copy of sql 2k, stopped it, and copied all MDF/LDFs from the working Sql 7 install into the sql2k DATA directory. (The copy included master, msdb, etc because I wanted the existing sql 7 users and DTS scripts to come along for the ride). When I rebooted, sql2k refused to start.
Event log:"Error: 50000, Severity: 22, State: 127
sp_msupg_upgradecatalog detected inconsistent versioning! "
"Master" was shown in the data srea of the event.
Event log: "17052 :
Cannot open database 'master' version 536. Upgrade the database to the latest version.
"
While I'm hardly surprised it didn't work, I’m disappointed it didn’t. How am I supposed to transfer my users, system stored procs, and DTS scripts (in msdb)
from sql 7 to sql 2k? I don't know of any "sql7 to 2k upgrade wizard!
TIA,
Bill
July 10, 2002 at 8:16 pm
Check out http://sqlindex.com/item.asp?ItemID=9066
It is helpfull and has several links that go into detail.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 10, 2002 at 8:25 pm
Bill, you should just be able to install SQL2K as the default instance and it will upgrade the files automatically. I don't remember trying to move master using the technique you mentioned, but it would work fine for all the other db's. MSDB should be fine too as long as the computer name doesnt change. You can DTS logins over pretty easily using DTS in SQL2K.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply