I've used dbbackup and dblog for quite awhile. Mostly to make copies of our main database for testing. Lately, I've run into an error when dblogging, "The database quit abnormally the last time it was used. Database recovery must be performed before proceeding." I've run into this error before but it just seemed to go away, say when I tried to run dblog the next day. Never worried about it.
I've googled this error and reviewed some other questions related to dblog in this forum and I'm coming to understand that there is more to running a dbbackup/dblog sequence then just running that sequence. Such as using dbvalid at some point.
Wondering if anyone could provide detail on properly running this sequence: dbbackup then dblog. Again, I'm using dbbackup and dblog to:
Appreciate the help.
asked 13 May '12, 07:31
I think your backup command line is wrong, I would use dbbackup -c "dsn=xx" -r C:BackupDirectory
-t is transaction log only
for incremental backups in ASA9 I use -y -r -n -t -o "LogFileName" -c "Connection Parms" "Backup Directory"
I wouldn't dblog -n the database, instead I would use -t without a path.
Finally if you ever need to use this database to recover you won't be able to if you start it without it being set to read only.
answered 21 May '12, 18:21