INF: Restoration of a Database from Transaction Dumps

This article has been archived. It is offered "as is" and will no longer be updated.
To restore a database that used DUMP TRANSACTION as the primarybackup procedure, the last dump of the entire database (DUMP DATABASE)must be loaded (LOAD DATABASE), followed by the sequential loading(LOAD TRANSACTION) of the transaction dump(s) (DUMP TRANSACTION).

For example, if all of the following are true
  • The database was last dumped on Monday
  • The transactions were dumped Tuesday, Wednesday, Thursday, and Friday
  • The database crashed on Saturday, causing data corruption
the proper way to restore the database would be to first load thedatabase dump from Monday, followed by the sequential loading of thetransaction dumps from Tuesday, Wednesday, Thursday, and Friday. Thedatabase would then be restored to the state it was in as of thelast transaction dump taken on Friday.
Dumping and Loading

Article ID: 60054 - Last Review: 01/16/2015 17:32:24 - Revision: 5.0

Microsoft SQL Server 6.5 Standard Edition, Microsoft SQL Server 7.0 Standard Edition, Microsoft SQL Server 2000 Standard Edition

  • kbnosurvey kbarchive kbinfo kbother KB60054