Move LDF -Has anyone seen this happen?

Hi

We have a SQL 2000 (sp3) server with a database that I set up to have the
MDF on D: and the LDF on E:. All was going along fine for several months and
one day the server rebooted. The SQL log says something like "Service is
shutting down due to server shutdown."

When it came back up the LDF File was on D: (in the same folder as the MDF).
The original LDF was gone from E:

The SQL Log doesn't ever say anything like "Recreating LDF in default
location." or any anything else that would explain what happened.

I assume the change happened during the reboot (actually I didn't notice it
until a week and a half later). I am relatively sure no human did anything
that caused the log file to move.

So has anyone seen this happen before.?

TIA

-Dick"DickChristoph" <dchristo101@.yahoo.com> wrote in message
news:hRBbb.19675$pU4.6621@.twister.rdc-kc.rr.com...
> Hi
> We have a SQL 2000 (sp3) server with a database that I set up to have the
> MDF on D: and the LDF on E:. All was going along fine for several months
and
> one day the server rebooted. The SQL log says something like "Service is
> shutting down due to server shutdown."
> When it came back up the LDF File was on D: (in the same folder as the
MDF).
> The original LDF was gone from E:
> The SQL Log doesn't ever say anything like "Recreating LDF in default
> location." or any anything else that would explain what happened.
> I assume the change happened during the reboot (actually I didn't notice
it
> until a week and a half later). I am relatively sure no human did anything
> that caused the log file to move.
> So has anyone seen this happen before.?

Nope.

I can't think of a way it would happen w/o human intervention.

You can check the ERRORLOG files for sp_detachdb (I think they show up
there).
You should have the last 4 and the current one.

> TIA
> -Dick
>
>