Subject | How to determine if database is in backup mode |
---|---|
Author | Tom Munro Glass |
Post date | 2009-01-16T02:09:02Z |
If you backup a database using nbackup, and the nbackup process dies for some
reason, the database gets stuck in backup mode because the 'alter database
end backup' statement is never run.
How can I determine if a database is in backup mode? If it is, I can
execute 'alter database end backup' or use 'nbackup -N' before I start doing
the next nbackup.
Regards
Tom Munro Glass
reason, the database gets stuck in backup mode because the 'alter database
end backup' statement is never run.
How can I determine if a database is in backup mode? If it is, I can
execute 'alter database end backup' or use 'nbackup -N' before I start doing
the next nbackup.
Regards
Tom Munro Glass