Thanks to all who have replied. It has given me confidence to attempt this after suitable backups of course.

What did you have to do to sort out the tools?

Great that now works fine. I should have read more thoroughly to realise this for myself. Thankyou for helping a newbie.

I have tried restoring the transaction log today with this command from the master database

restore log cca from disk = 'H:\SQLBackups\CCA_tlog_200907070900.TRN'

with norecovery

but got this message

Server: Msg 4306, Level...

Thanks for the help. I will do as you suggest.

Thanks for your help. I will d oas you suggest.

I was afraid of doing this in case the transaction log was restored to the original production server database and overwrote data on it. I wasn't sure if information in...