Unsolved
This post is more than 5 years old
8 Posts
0
1816
July 9th, 2014 14:00
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



elvinperez
87 Posts
0
July 9th, 2014 14:00
Hi,
Please verified status of the database name "database1_Data_May29 " on the management studio.
Regards,
Elvin...
ble1
2 Intern
•
14.3K Posts
0
July 9th, 2014 15:00
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.
Ther_Max
8 Posts
0
July 10th, 2014 09:00
'-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!