Highlighted
Ther_Max
1 Nickel

How to skip SQL database level backups instead of SQL instance level backups?

Hi,

I'm currently using client 8.1.1 with NMM 3.0SP1.  We just configured several clients for SQL backups on clustered hosts.  Unfortunately on some of the development hosts, some of the SQL databases are kept periodically offline.  The SQL instance itself is online.  When the backups run, they find an offline SQL database and then reports the backup as failed.  Is there a way to avoid this and skip the offline SQL databases.  I tried using the NSR_SKIP_NON_BACKUPABLE_STATE_DB=Yes and NSR_SKIP_NON_BACKUPABLE_STATE_DB=TRUE options in the Application information but it made no difference as I understand this parameter works only at the SQL instance level.

43621:(pid 10584):Computer Name: SERVER1     User Name: sql_backup

29231:(pid 10584):Only full backup is supported on master database.

29232:(pid 10584):Database 'master' backup level forced to full.

4690:(pid 10584):Database database1_May29 is offline, it can not be backed up.

4690:(pid 10584):Database database1_Data_May29 is offline, it can not be backed up.

29085:(pid 10584):Microsoft SQL Server Provider error:

38006:(pid 10584):Database 'database1_May29' cannot be opened because it is offline..

37938:(pid 10584):Failed to obtain filegroups for database1.

29085:(pid 10584):Microsoft SQL Server Provider error:

38006:(pid 10584):Database 'database1_Data_May29' cannot be opened because it is offline..

37938:(pid 10584):Failed to obtain filegroups for database1_Data.

            NSR_BACKUP_LEVEL: 1;

                  NSR_CLIENT: SQLINST1;

                   NSR_GROUP: SERVER1_NMM;

            NSR_SAVESET_NAME: "MSSQL:";

                  NSR_SERVER: masterserver.com;

Successfully established client DDCL session

53085:(pid 10584):Backing up of ABC1 succeeded.

Successfully established client DDCL session

53085:(pid 10584):Backing up of ABC2 succeeded.

Successfully established client DDCL session

53085:(pid 10584):Backing up of ABC3 succeeded.

Successfully established client DDCL session

53085:(pid 10584):Backing up of ABC4 succeeded.

Thanks for any info,

Max

Tags (3)
0 Kudos
3 Replies
elvinperez
2 Bronze

Re: How to skip SQL database level backups instead of SQL instance level backups?

Hi,

Please verified status of the database name "database1_Data_May29 " on the management studio.

Regards,

Elvin...

0 Kudos
ble1
5 Iridium

Re: How to skip SQL database level backups instead of SQL instance level backups?

If DB is offline, you can skip it with -H I believe, but not sure if this is applicable to instance level backup - give it a try.

0 Kudos
Ther_Max
1 Nickel

Re: How to skip SQL database level backups instead of SQL instance level backups?

'-h' kind of worked.  It excludes a database from the backup

nsrsqlsv -s bv-customer.belred.emc.com -h master -h model MSSQL:

BUT I have to explicitly identify each database that is offline.  I was looking for a variable similar to NSR_SKIP_NON_BACKUPABLE_STATE_DB, where it would skip at the SQL db level without having to hardcode the db name.

If there is no other option, then I will use this parameter.

Thanks!

0 Kudos