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.
P.S. This is for SQL Server 2000.
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.
answered Oct 21, 2009 at 12:26 PM
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/
answered Oct 21, 2009 at 12:48 PM
Steve Jones - Editor ♦♦