[windows2000] Re: sql2k server service not starting
- From: "Ray at home" <listray@xxxxxxxxxx>
- To: <windows2000@xxxxxxxxxxxxx>
- Date: Sun, 3 Aug 2003 02:11:48 -0400
Why'd you change the drive when you had your data files on it? As
indicated by Enterprise Manager, "A database file's physical file name
cannot be changed once the database file has been created." This
applies to the log files as well.
Re-letter your drives back to the way that they were, detach all your
non-system databases, backup your system databases, uninstall SQL
Server, re-letter your drives to the way you want them, install SQL
server, restore master, msdb, and pubs, (model if applicable) and then
re-attach your other databases from the "new" drive. I suppose that
should work.
Ray at home
> -----Original Message-----
> Sen
> hi,
> i have installed sql2k program to c: drive and database to f:
> drive. however, after changing the drive letter from f: to g:
> i am not able to start sql server service anymore. It seems
> like sql2k is looking for f: drive. pls help. thanks
This weeks sponsor - RTOSoft TScale
Complaints about applications response time - DO SOMETHING ABOUT IT!
TScale 2.0 improves applications response time and increases terminal
server capacity. Really get MORE from your existing servers! Free eval:
http://www.rtosoft.com/enter.asp?id=131
==================================
To Unsubscribe, set digest or vacation
mode or view archives use the below link.
http://thethin.net/win2000list.cfm
Other related posts:
