arkiboys (11/19/2012)
2- restoring each transaction log sinice the previous midnight seems to be a long process. How about introducing a differential backup?
Then you would need to restore the full backup, the latest differential and all log backups from the differential to the point you're restoring to.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability