May 28, 2012 at 8:34 am
Hi,
some one deleted my database Log file ... what are all the steps to recover the log file ?
Thanks
Venkat
May 28, 2012 at 8:36 am
May 28, 2012 at 8:39 am
Hi,
Thanks for your reply!!!
The database is in simple recovery model. and i have no backups available for the database.
Regards,
Venkat
May 28, 2012 at 8:46 am
No backups? Seriously? Well can't have been a very important database then.
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2012 at 8:47 am
venkatb.dba (5/28/2012)
Hi,Thanks for your reply!!!
The database is in simple recovery model. and i have no backups available for the database.
Regards,
Venkat
Do you know how the log was deleted? It shouldnt have been possible if the server was running.
Just to confirm, it is the.ldf file that is missing and the database is NOT online in SQL?
Adam Zacks-------------------------------------------Be Nice, Or Leave
May 28, 2012 at 9:19 am
venkatb.dba (5/28/2012)
Hi,some one deleted my database Log file ... what are all the steps to recover the log file ?
Thanks
Venkat
Without backups there really isn't much you are going to be able to do. You can try attaching the database as a single file and see if SQL Server will rebuild the log file, but if the database was not detached appropriately it may not work.
I have to ask, why no backups?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply