Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
prakash70
Starting Member
2 Posts |
 Posted - 2005-11-03 : 11:02:12
|
| by accident the .ldf file has been deleted and no more avalible.Is any way to receate log file and attached to my .mdf file?pls help,regards, Prakash |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-11-03 : 12:02:51
|
| Do you have a backup?Was the database shut down cleanly before the log file was deleted?Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
prakash70
Starting Member
2 Posts |
Posted - 2005-11-03 : 23:01:40
|
quote:
Originally posted by paulrandal
Do you have a backup?Was the database shut down cleanly before the log file was deleted?Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
-the server pc was shut properly and noticed the database with suspect mode after restated.-my log file was nearly 5 GB and therefore it was not sent to recycle bin after deleted. (panic).-Now only have .mdf file-i have backup of one month data old.pls help to get the data from my .mdf file. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-11-03 : 23:50:47
|
| How about sp_attach_single_file_db?And, of course, get yourself a useful backup strategy as you've just proven that yours is useless.Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
|
|
|
missing log file (.ldf)