Dear all

pl help to resolve my problem

i've change the database log file from E drive to Drive due to insufficient space.

without attaching the log file i've shutdown the sytem. becz it's gone in hand mode.

post resuming its showing recovery pending.i'm unable to get online db.

without attaching the log file i've shutdown the sytem. becz it's gone in hand mode.

I am pretty mush sure you did some mistake and from your question I am not able to judge what.

Can you tell what do you mean by above lines

actually when separating the Drive of log file from E to D. i'v not define the path.

system gone in hang mode,so i've restarted the system.

Hi there,

sounds like you have not followed the required safety precautions.

here is the link for your reference: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/bb0da90a-bb97-4795-9181-2897a300b747/how-do-i-move-a-transaction-log-to-another-drive?forum=sqldisasterrecovery

Now do the following steps.

1) locate the mdf, ldf files

2) shut down the sql server (if you can not take the database offline or no other issues)

3) copy these two files to some other location as a precaution.

4) restart the server then delete the database. (make sure mdf & ldf files are deleted.)

5) now copy back the mdf file and ldf file to the drives where you wanted to place.

6) now attache the mdf & ldf.

follow the link: http://www.serverintellect.com/support/sqlserver/sql-database-attach/