fosco (1/29/2008)
would I have to restore all the previous log backup ( there are many of them and from what date).
Yes. You have to restore the log backups, in order, starting with the first one after the full backup that you used.
If you're setting up database mirroring, all or your transaction log backups, including the last must be restored with no_recovery
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