log and .ldf file
Posted on 2001-06-15
I was trying to reduce the size of my .ldf file by stopping SQL Server, deleting the file, then restarting SQL Server.
I did the above. When I open Enterprise Mngr, the database has (suspect) next to the name, and (no items) is written below the database name.
By mistake, I did not make a copy of the .ldf file.
The .mdf file is still on the pc.
Can I get my database back?
If yes, how?
My main concern is to recover all of the tables, views, and stored procedures. I'm not overly concerned with the data within the tables.