SQL Restore

[Shocker]

Hi everyone

 

really looking anyone's help with this issue, at some point last night i lost my SQL database from one of my Drives before the backup started, this means i can only restore the database back from a previous day.

 

Now i have the SQL transaction logs going to a separate drive which i have a backup from yesterday evening.

 

If i restore my SQL database back from Tuesday nights back is there anyway i can use Wednesdays transaction logs to get the database basically back to Wednesday's data? All the files used are also saved in a separate drive from the database and the transaction logs so i have access to all of those from Wednesday except the database which i will only be able to restore Tuesday nights database backup.

 

Any help with this would be greatly appreciated.

[forkies]

Will this help: https://technet.microsoft.com/en-us/library/ms187607%28v=sql.105%29.aspx