One very important thing to remember:

RESTORE the database using WITH NORECOVERY, the RESTORE the first log WITH NORECOVERY, then the last log using WITH RECOVERY.

Oh, second thing to remember....if your database 'goes down', try to backup the current Transaction Log. If you can back it up, you can RESTORE it last using WITH STOPAT and that will allow you to restore all the data right up to the time that the bad command, crash, whatever happened.

Refer to the Books OnLIne for more information.

-SQLBill