|
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.
(comments are locked)
|
|
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.
(comments are locked)
|
|
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/ That script is awesome. Exactly what I was looking for. Many thanks for the link.
Oct 21 '09 at 04:14 PM
Mike
(comments are locked)
|
