Upgrade SQL 7.0 to 2000

[crossman]

We are trying to do an upgrade in place and are getting errors that it can't activate model database files. We believe it's because we move all log files to another drive and think Microsoft failed once again to recognize this in their upgrades. They made this mistake in 7.0 SP2 (the SP failed if you moved log files to alternate location) but they fixed it in SP3.

Has anyeone experieinced this problem? Is there a workaround (other than the obvious.)

Replies are appreciated!

Colleen

[MAK]

SQL 7 to SQL 2000 upgrade is pretty simple. YOu dont have to actually use the wizard to do an upgrade.

take backup of all user databases and restore it in SQL 2000. it automatically upgrades it. you can transfer logins, jobs using DTS.

login transfer:
http://support.microsoft.com/defaul...kb;en-us;246133

DTS packages can be transfered using transfer of file msdb.dbo.sysdtspackages.

http://www.sqldts.com/default.aspx?6,105,204,0,0

[crossman]

Thanks for your response. Unfortunately we only have one server on which to do this and we don't want to install an instance of SQL2k on the box because we need to keep the server name (instance name) the same.

I was hoping someone knew about a fix for this 'undocumented feature'.

[MAK]

I have a suggestion. How about installing service pack 4 on sql server 7.0 and then do an upgrade.

[crossman]

That's a great idea!! I'll try it. Thanks.