jasona.work (4/15/2013)
You want to use "With NoRecovery" not "With Standby."Standby will roll back any uncommited transactions and put the DB in read-only. NoRecovery basically tells SQL Server that there's more to be restored, at which point you begin restoring your TLog backups. On the last TLog backup you intend to restore, you use the "With Recovery," after which you'll have a usable DB.
Jason
Not quite true. WITH STANDBY allows you to bring a database into a read only state. Using an UNDO log you should be able to restore additional t-log backups until such time as you use WITH RECOVERY. This is how you can use a log shipped database for reporting.