INF: Restoration of a Database from Transaction Dumps

Article translations Article translations
Article ID: 60054 - View products that this article applies to.
This article was previously published under Q60054
To restore a database that used DUMP TRANSACTION as the primary backup 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 the database dump from Monday, followed by the sequential loading of the transaction dumps from Tuesday, Wednesday, Thursday, and Friday. The database would then be restored to the state it was in as of the last transaction dump taken on Friday.
Expand all | Collapse all


Article ID: 60054 - Last Review: February 14, 2005 - Revision: 4.3
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
kbinfo kbother KB60054

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from