Loading the database  Loading a transaction log to a point in time

Chapter 12: Backing Up and Restoring User Databases

Loading the transaction logs

Use load transaction to apply transaction log backups in the same sequence in which they were made.

Adaptive Server checks the timestamps on each dumped database and transaction log. If the dumps are loaded in the wrong order, or if user transactions have modified the transaction log between loads, the load fails.

If you dumped the transaction log using with standby_access, you must also load the database using standby_access.

After you have brought a database up to date, use dbcc commands to check its consistency.





Copyright © 2005. Sybase Inc. All rights reserved. Loading a transaction log to a point in time

View this book as PDF