data file lost, have translog and week-old backup

[iBe]

Hello,

I have a database with a filegroup spread across 2 disks; data file on disk1, and log file on disk2. The current situation is that disk1 has failed, and the primary data file is gone and there is no possibility of recovering it. What I have now is:

1.) the log file on Disc2, 50gigs, containing all logged transactions since the last restore operation a week and a half ago.

2.) a backup of the primary data file taken a week and a half ago, and a transaction log taken shortly after that.

the database/translog backups were used immediately after creation to restore the DB to a different server. It is this restored DB that has now been lost, and for which I have a week and a half of transactions stored in the translog.

Can the transaction log be used in any way to get the initial backup set up to date, covering the week and a half worth of transactiosn occuring after the last restore operation?

This series of events list may help make the issue more clear:

1.) Backup of DB1 occurs on Server1
2.) Backup of DB1 is restored on Server2
3.) 1 and 1/2 weeks passes with DB1 in production on Server2
4.) Data file for DB1 on Server2 is killed beyond revival.

So I still have the backup created in step1, and the log file created through steps 2 to 4. What are my options?

Thanks!!!

 

[ptheriault]

Get lumigent log explorer. you can use it to re-create all the transactions on the tlog. then apply them to the restored database.

- Paul

- If at first you don't succeed, find out if the loser gets anything.