cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Need a script option for log backups to skip databases using the Simple Recovery model

Need a script option during log backups to skip databases using the Simple Recovery model.  While there is no harm done when NetBackup attempts to perform the log backup on such a database, NetBackup simply errors out on that line.  This can create a large number of 'false positive' errors for backup admins to sift through, obscuring true errors that might have occurred.

EXCLUDE_SIMPLE_RECOVERY TRUE

It appears NetBackup does include an 'EXCLUDE' parameter that takes a list of databases by name.  This allows one gets fairly close.  Best bet, though, would to make it dynamic based on the recovery model so if a database was changed later, but neglected to be removed from the EXCLUDE list, the log file wouldn't grow out of control.

1 Solution

Accepted Solutions
Highlighted
Accepted Solution!

Re: Need a script option for log backups to skip databases using the Simple Recovery model

Hi everyone,

Enhancements request are best done via the local Veritas SE, which have a focus on NBU. Almost every major country in EMEA has a NBU SE specialist who can make a record of a request in our enhancement requests system where we do follow up with PM.
This enhancement request process is refered to as "Close Loop" inside Veritas.

That said, there are conditions:

  • The requests must be formulated such a way that they describe the major issue they need to solve, related to what the customer wants to achieve (the what and the why). They should not describe a technical implementation (the how), as this is something PM & Engineering decide.
  • There needs to be an associated business case ($ value) and customer list. We always need to make conscious  decisions on where to invest development resources - they are not infinite. This will help us to in the priority setting criteria.
  • A request cannot be a bug fix - this is driven via our support organisation and needs to be handled with them.
  • A request should not be a support proliferation of an existing platform or application. We normally support proliferations within a given delay after their GA depending the vendor/type. These are not considered being enhancements, as they are already on the planning list of items to deliver. Questions about proliferation can also be handled with the Veritas NBU SE's.

It may be the request has already been formulated by others - Veritas internally. In that case the SE can link/add the business case or the customer name to existing requests.

Not all requests are suitable ones. If they are attached to a single customer or if they are trying to fix an exceptional and singular demand they are not likely to get the PM organisation's attention. If no business case is attached they are not likely to make it either. The local specilist SE may already be able to tell you if a request has a chance to make it or not.

Response delays: if a request is done, and it is not already in the system the Veritas SE - who remains your contact to work with related to your request - may need some time to provide an answer to the request.
This can take up to 3 months as PM's are not revisiting enhancements requests every day. If the request is already in the system we can respond quite quicky.
The response may be simply "not considered", or "we have it in system but no plan to develop at present". It is not because a request if registered that it will be executed - obviously.

The above is a repsonse for the EMEA region which I work for.

Regards,

Alain Pelegrin
NBU Solutions Lead EMEA.

Alain Pelegrin - EMEA NBU Solutions Lead
Technology Pratice

View solution in original post

6 Replies
Highlighted

Re: Need a script option for log backups to skip databases using the Simple Recovery model

Is this a request for product / feature enhancement?

If so - please reach out to NetBackup Product Management via your local Veritas SE or reseller.

 

Highlighted

Re: Need a script option for log backups to skip databases using the Simple Recovery model

Thanks, yes - a feature suggestion, Brice Avila of Veritas referred me to this site.  Is this the proper forum for bug/features?  i was expecting a uservoice type upvote/downvote thing, but this seems like a support forum.

Highlighted

Re: Need a script option for log backups to skip databases using the Simple Recovery model

The IDEAS section was removed when the Veritas moved from Symantec Connect community to the new VOX community. This section had 'vote up' and 'vote down' buttons.

In all honesty, although Support have been referring users to the Community for product feature requests, my personal experience has been that Product Managers have not checked IDEAS sections in the various product communities for many years.

A regional product manager told me a couple of years ago that the only enhancement requests that they considered were those that were channeled to them via the various SE's in each country.

Please ask your Veritas reseller to put you in contact with the local Veritas SE.

 

Highlighted
Accepted Solution!

Re: Need a script option for log backups to skip databases using the Simple Recovery model

Hi everyone,

Enhancements request are best done via the local Veritas SE, which have a focus on NBU. Almost every major country in EMEA has a NBU SE specialist who can make a record of a request in our enhancement requests system where we do follow up with PM.
This enhancement request process is refered to as "Close Loop" inside Veritas.

That said, there are conditions:

  • The requests must be formulated such a way that they describe the major issue they need to solve, related to what the customer wants to achieve (the what and the why). They should not describe a technical implementation (the how), as this is something PM & Engineering decide.
  • There needs to be an associated business case ($ value) and customer list. We always need to make conscious  decisions on where to invest development resources - they are not infinite. This will help us to in the priority setting criteria.
  • A request cannot be a bug fix - this is driven via our support organisation and needs to be handled with them.
  • A request should not be a support proliferation of an existing platform or application. We normally support proliferations within a given delay after their GA depending the vendor/type. These are not considered being enhancements, as they are already on the planning list of items to deliver. Questions about proliferation can also be handled with the Veritas NBU SE's.

It may be the request has already been formulated by others - Veritas internally. In that case the SE can link/add the business case or the customer name to existing requests.

Not all requests are suitable ones. If they are attached to a single customer or if they are trying to fix an exceptional and singular demand they are not likely to get the PM organisation's attention. If no business case is attached they are not likely to make it either. The local specilist SE may already be able to tell you if a request has a chance to make it or not.

Response delays: if a request is done, and it is not already in the system the Veritas SE - who remains your contact to work with related to your request - may need some time to provide an answer to the request.
This can take up to 3 months as PM's are not revisiting enhancements requests every day. If the request is already in the system we can respond quite quicky.
The response may be simply "not considered", or "we have it in system but no plan to develop at present". It is not because a request if registered that it will be executed - obviously.

The above is a repsonse for the EMEA region which I work for.

Regards,

Alain Pelegrin
NBU Solutions Lead EMEA.

Alain Pelegrin - EMEA NBU Solutions Lead
Technology Pratice

View solution in original post

Highlighted

Re: Need a script option for log backups to skip databases using the Simple Recovery model

The only way to archive this is to script it and trigger it through bpstart_notify (like I did).

Even the new "sql intelligent policy" are not that intelligent and they don't offer this option and due to the bad design/implementation of this in NetBackup (need to modify local security policies) I won't even recommend using it.

As for your "enhancement request" - keep calm and wait - it might get implemented in couple of years Smiley Happy

Highlighted

Re: Need a script option for log backups to skip databases using the Simple Recovery model

Alain, or to whom it may concern,

  1. please step up your feature request. it's hard to find where it is and once found, will take months to get read??
  2. step up your customer follow-up or presence. having multiple layers of regional or local Veritas SE only show Veritas doesn't want to talk directly to customers.
  3. step up your customer relations. as item 1 mentions, customers will not waste time giving you structured information on their feature request. we will give it as a copy and paste from the notepad we keep around.

in short, unless i searched for it, it is very difficult to find you.

better hurry up, i can see Veeam coming up fast in the rear view mirror.