September 27, 2005 at 8:08 pm
As part of my disaster recovery plan, I am looking at how you could create a new LDF file if the drive the LDF file is on fails.
This assumes that I still have the MDF file.
Any assistance would be appreciated.
September 27, 2005 at 9:14 pm
If you still have MDF file you just need to attach the database, the LDF file will created automatically
September 27, 2005 at 9:53 pm
As part of your disaster recovery?
The log file is an integral part of the database.
If you have a live server and the drive the log is on fails, then you are basically in the same situation as if a drive fails with any other file.
Your database will only be as good as your last backup + subsequent log file backups.
in preparation of your disaster recovery, you should be backing up logs on a regular interval.
But if your able to sucessfully detach the database then the log file is disposable. (When you detach all uncommitted entries in the log are written to the db), and a reattach will create a new one.
Even if you have the mdf's you will have a substantial amount work getting the mdf back online. I know you can recover a db from this state, but I do not have the steps. There;s a book sql server 911 that can help you with this.
September 27, 2005 at 10:34 pm
Thank you both for your comments.
The detach and then re-attach works a treat!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply