steveb. (2/4/2011)

---

vinodsy123 (2/4/2011)

---

First stop all the SQL Services (Instance) then restart them and then try to shrink the log file but make sure that your recovery model should be...

First stop all the SQL Services (Instance) then restart them and then try to shrink the log file but make sure that your recovery model should be Simple.

Thanks.

Can u elaborate this clearly. I mean plz. explain how it works and what is the output. Can u give step by step?:-)

I think if u can detach the database then copy the .mdf & .ldf file in a disk if it won't work then use xcopy through command prompt.