We have had problems doing our upgrade. After the software is installed SQL runs some scripts that upgrade the various tables. Ours would fail with the message "Error executing script upgrade.sql (1)". After talking to MicroSoft support the only solution is to uninstall SQL7 and then install SQL2000 as a clean install.
What we did that finally worked was: 1. Stop SQL7 2. Copy all database and log files into another directory. 3. Uninstalled SQL7 4. Installed SQL2000 5. Copied all of the database and log files into the new data and log directories (ours were on different drives). 6. Recreated all users from the old system keeping passwords etc. 7. Attached each database into the server. The only issue we had was we had 2 purchased programs that had special security settings and stored procedures in the master database. We had to manually recreate this information. One thing that helped was each of the programs had a utility that once we gave the "admin" user rights to master would recreate all of the security settings needed for each user. But all of our internal programs worked like a dream without any special work. Bill Grover Supervisor, IS EU Services, Inc. 649 N Horners Ln Rockville MD 20850 Phone: 301-424-3300 x396 FAX: 301-424-3300 x1396# E-Mail: [EMAIL PROTECTED] > -----Original Message----- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 27, 2001 6:39 PM > To: CF-Talk > Subject: OT: SQL Server upgrade (7-2000) > > > Hey All, > > Sorry for the OT, but has anybody had any glitches upgrading from SQL > Server 7 to SQL Server 2000 (database side not CF)? > Specifically loss > of data or anything nasty when just installing over top SQL Server 7? > > TIA > > Bryan Stevenson > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > p. 250.920.8830 > e. [EMAIL PROTECTED] > --------------------------------------------------------- > Allaire Alliance Partner > www.allaire.com > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
