Ammad,

Have you double checked that the tuf file exists in the location specified in the error and the time on it is around the same of the last restored log? ...

Thanks Sugesh, i had to restore to the secondary server in the end and reconfigure log shipping.

I was trying to have an OLAP server and DR server with one copy...

Thanks Carl, that's the kind of advice i was after.

Don't forget your jobs and DTS packages etc. if you have them aswell

I did this recently and had problems when returning @@servername as the old server name kept srvid 0 in master..sysservers and the new servername was srvid 1.   I'm opting for...

Sugesh,

Thanks for the suggestion but it is still looking for the tuf file that no longer exists.

I get an error: Server: Msg 3441, Level 17, State 1, Line 2

thanks,

Dave