• James, I think your advice is a little bit off.  Once the FULL backup is restored, Subu only has to restore the most recent Differential backup and then all the transaction logs up to the point of time he/she wants. 

    Per BOL "A differential backup is based on the most recent, previous full backup. This is known as the base of the differential. A differential backup includes only the data that has changed since the differential base. ", which means restoring multiple differential backups after the last full backup is kind of pointless.

    Also, Subu, you cannot restore any further to your database if you use the WITH RECOVERY command.  SQL Server simply won't allow it. 

    Lastly, I would change the times of your FULL backup if I were you.  Unless you don't have anyone using your database at noon.  Schedule your bigger backups for times when you have the least number of users on the database so your database doesn't get bogged down by all the processing going on.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.