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 Randal
Lead 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 Randal
Lead 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 Randal
Lead 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)