[windows2000] Re: sql2k server service not starting

  • From: "Rod Falanga" <rjfalanga@xxxxxxxxxxxxxx>
  • To: <windows2000@xxxxxxxxxxxxx>
  • Date: Sun, 3 Aug 2003 07:05:00 -0600

Normally, if it were an issue of moving the databases from one drive to
another, then all you would have to do is detach the database in SQL Server
Enterprise Manager, move the files to wherever and then reattach them.  But
since you renamed the drives, SQL Server can't find them.  I believe you
will have to rename the drives back the way they were, then go into
Enterprise Manager and detach the database, then rename the drives to what
you want them to be, and finally get back into Enterprise Manager and
reattach the database.

Rod
 

> -----Original Message-----
> From: "Sen" <discussion.groups@xxxxxxx>
> Subject: [windows2000] sql2k server service not starting
> Date: Sat, 2 Aug 2003 18:56:41 +0800
> 
> 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: