Recovering a database: step-by-step instructions  Examining the space usage

Chapter 12: Backing Up and Restoring User Databases

Getting a current dump of the transaction log

Use dump transaction with no_truncate to get a current transaction log dump for each database on the failed device. For example, to get a current transaction log dump of mydb:

dump transaction mydb
to "/dev/nrmt0" at REMOTE_BKP_SERVER
with init, no_truncate,
notify = "operator_console"



Copyright © 2005. Sybase Inc. All rights reserved. Examining the space usage

View this book as PDF