Lost T-Log (Help Plz.)

[DrSql]

One of my server crashed today.
We lost one of the T-log, is there any way that I can atleast recover rest of the t-logs.

I have weekly full backup from Sunday,
Tlogs from Mon & wed
Is there any possible way we can recover tha data from wed t-log without tue t-log.

Any help would be greatly appreciated.
Thanks
Varghese

Dr.Sql
Good Luck.

 

[mrdenny]

If you don't have the tuesday log backup you can not restore beyond that.

If you still have the MDF file you can try to attach that file using the sp_attach_single_file_db.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog