Data Backup and Recovery

Database exclusion on a full instance backup

heiko_gerstenlauer
5,535 Views

SnapCenter 4.3.0.3689

MS SQL (several versions)

 

Hello everybody,

we backup many SQL Server via SnapCenter. Sometimes a database on a SQL Server is planned offline.

Is it possible to exclude a single database on a full instance backup job in SnapCenter?

Kind regards,

Heiko

1 ACCEPTED SOLUTION

mrahul
5,393 Views

Thanks for your comments. I have included your concerns to the RFE https://mysupport.netapp.com/NOW/cgi-bin/bol?Type=Detail&Display=1106048 .

 

 

 

View solution in original post

6 REPLIES 6

Ontapforrum
5,509 Views

Hi,

 

There is a thread (couple of years old) which raised a similar question around exclusion list.
https://community.netapp.com/t5/Data-Backup-and-Recovery-Discussions/SnapCenter-SQL-option-to-ignore-offline-databases/td-p/136120

 

However, the actual RFE (Request for Enhancement?) has no updates at all.
https://mysupport.netapp.com/NOW/cgi-bin/bol?Type=Detail&Display=1106048

 

May be worth asking Support?

 

Thanks!

mrahul
5,420 Views

As of today, there is no way the user can exclude a database if the protection is configured at the instance level.

You must create a 'Resource Group' at the database level, including all individual Dbs of that instance. Then you can modify the resource group whenever required to exclude or include any newly created DBs

 

 

heiko_gerstenlauer
5,413 Views

Thank you for the answer. A Resource Group at the database level isn´t a solution for us. We have many SQL Servers and the database team creates databases very often. The risk that we forget one of this databases would be to high. Perhaps there will be a solution in the next version. A solution shouldn´t be that difficult... 🙄

 

Thanks, Heiko

mrahul
5,407 Views

Once protected, backups at instance level should work seamlessly even if a new DB is created. This does not require any manual operation/update (other than resource discovery) on the SnapCenter side. The consecutive backup operation should automatically include the new DB. Isn't that working?

 

Yes, since the protection is at instance level - exclusion of individual DB is not possible. Even if a DB is not in the proper state, the backup job should be giving a warning against that particular DB. 

heiko_gerstenlauer
5,404 Views

We need the exclusion to avoid this warnings. Sometimes the database team set a database to status offline (sometimes for several days). If we don´t exclude this (offline) database from the backup a warning occurs every day.

We want to avoid these warnings for two reasons:

1. Every warning causes a task for the backup operators.

2. Every year we has to create backup reports for the auditors and we has to explain the many warnings.

 

SnapManager exclude offline databases automatically 😉

mrahul
5,394 Views

Thanks for your comments. I have included your concerns to the RFE https://mysupport.netapp.com/NOW/cgi-bin/bol?Type=Detail&Display=1106048 .

 

 

 

Public