CODEWITHSUNDEEP
sql-server-2005database-backups
Dhiva
Dhiva

Reputation: 221

Is database is in backup mode?

Is there any way to find whether the database is in backup mode or not. Is any sys tables can provided this informtion.

Upvotes: 2

Views: 5342

Answers (1)

Roni Vered
Roni Vered

Reputation: 787

Are you referring to a Recovery model in SQL SERVER ? if so, the query is:

select name, database_id, recovery_model_desc from sys.databases

if you are referring to Oracle database, and you're asking how to check whether the database is in backup mode (after issuing 'alter database BEGIN BACKUP'), then the query is:

select * from v$backup;

if one of the rows return with ACTIVE in the status column, then one of the tablespaces is in backup mode.

Upvotes: 2

Related Questions