Does anyone know how to recreate a database from a log file? Here is the situation:
I had a server go bad. The drive configuration was as follows
Server OS on separate RAID controller - RAID Level 1
SQL Data on separate RAID controller - RAID Level 5
Transaction Logs on Separate Raid Controller - RAID Level 1
I lost the RAID 5 array and can't get it back and don't have a backup. I need to know if/how I can recreate the database from the log file. The log file has been set to grow and has never been purged so I am hoping that I can recreate the database from scratch. Is this possible?
The answer to your question is that we would need to find a way to
restore the database (mdf) or connect to a backup file so that Log
Explorer could connect to that and the Transaction Log. If there is no
mdf then there is no way for Log Explorer to attach to the database and
recover the data from the transaction log.