> 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?

Physical backup state flag is stored on header page. And of course gstat -h show it to you.

Regards,
Vlad