Hello,
A developer deleted an .ldf file to a test database. As it turns out the
database wasn't so test after all.
The guy didn't backup his DB and there are no current copies of the
.ldf. I can see the MDF in windows
Explorer and its current file size is around 1.5gb. Enterprise manager
shows the DB as suspect and I can't do
any sort of properties display on it. I cant detach nor back up the DB,
Is there any way of creating a new ldf file?

Thanks.


DISCLAIMER:
The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are Not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.


MS Sql Server LazyDBA home page