question

Mike avatar image
Mike asked

Restoring a set of transaction logs

Hi,

I was wondering whether there is not a way to restore a set of transaction logs in one big swoop as opposed to restoring one transaction log at a time.

Many thanks

mike

P.S. This is for SQL Server 2000.

sql-serverrestoretransaction-log
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

NYSystemsAnalyst avatar image
NYSystemsAnalyst answered

You can restore a set of transaction logs, but you must restore them in order. See this link for restoring transaction logs: http://msdn.microsoft.com/en-us/library/ms177446.aspx

The system will restore them one at a time, in order, but that is the nature of the transaction logs.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Steve Jones - Editor avatar image
Steve Jones - Editor answered

You can write a script that reads the MSDB, or uses the filestamps (or filenames) and executes the restores in order. Here's a sample: http://www.sqlservercentral.com/scripts/Restore/61810/

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.