Very Computer

Hi all,

Can anyone help? We're trying to upgrade a SQL 7.0 server to SQL 2000 and
the upgrade software doesn't recognise the fact that our databases
(specifically the master) have their log files on a different drive array to
the data files (the error in the event log states that SQL 2000 can't find
the log file - it's looking in the data drive).

Anyone got any ideas (without first moving all the log files into the data
drive :-) )

Thanks, Simon.

Simon - it does sound like a bug!  Moving them is the only thing that springs
to mind.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
 (faqxxx.zip in lib 7)
 or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq

 Simon,

 Nothing else springs to mind.  I would call it in to MS PSS.

 > Can anyone help? We're trying to upgrade a SQL 7.0 server to SQL 2000 and

Quote:> the upgrade software doesn't recognise the fact that our databases
> (specifically the master) have their log files on a different drive array to
> the data files (the error in the event log states that SQL 2000 can't find
> the log file - it's looking in the data drive).

> Anyone got any ideas (without first moving all the log files into the data
> drive :-) )

> Thanks, Simon.