NSR_SKIP_NON_BACKUPABLE_STATE_DB=TRUE or FALSE

Hi kishore1

To include or exclude databases that are not in a state to be backed up for the instance level save set backup, use the Application Information variable NSR_SKIP_NON_BACKUPABLE_STATE_DB when configuring the client resource for
scheduled backup.

The list of databases states that cannot be backed up and can be skipped during backup are:

◆ Mirror copy
◆ Standby
◆ Recovery Pending
◆ Offline
◆ Loading
◆ Prerecovery

The flag NSR_SKIP_NON_BACKUPABLE_STATE_DB is applicable only to SQL instance level backups and does not affect database level backups.
The simple database is skipped when the NSR_SKIP_SIMPLE_DB environmental variable is set to TRUE on the client to skip the backup for simple databases.
Otherwise, the incremental backup request is promoted to full.
When the NSR_SKIP_NON_BACKUPABLE_STATE_DB variable is set to TRUE, the databases that are not in a state to be backed up are skipped and the savegroup reports success for the SQL instance level backups.

When the NSR_SKIP_NON_BACKUPABLE_STATE_DB variable is set to FALSE or is not mentioned, the back up of the databases fails and the savegroup reports failure of the SQL instance level backups.

What SQL version do you have in place?

Thank you,

Carlos

“SQL Server 2008 R2”.

Sorry for late reply, I was on a vacation.

Hi Carlos Rojas,

Do you have any idea on which SQL server version the above attribute will work.

Hi Carlos,

Yes.. I meet the requirements version and other prequisites.

But still the offline databases are not excluded , and the backups are failing.

Regards,

Kishore

Hello kishore1

This should work in SQL 2008 R", so please check the logs to find out why this is not working.

I suppose you meet the requirements documented, right?

Thank you,

Carlos