Alter database message set offline with rollback immediate;
restore database message from disk='d:\message_db_200708280214.BAK' with replace,norecovery
RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270215.TRN'

WITH NORECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270230.TRN'

WITH NORECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270245.TRN'

WITH NORECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270300.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270315.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270330.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270345.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270400.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270415.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270430.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270445.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270500.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270515.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270530.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270545.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270600.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270615.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270630.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270645.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270700.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270715.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270830.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270845.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270900.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270915.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270930.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708270945.TRN'

WITH RECOVERY

RESTORE LOG message

FROM DISK = 'd:\mess\message_tlog_200708271000.TRN'

WITH RECOVERY

alter database message set online;