Skip to main content

Selective backup of MS SQL databases by mask

  • November 11, 2024
  • 1 reply
  • 17 views

Forum|alt.badge.img+2

I have MSSQL database server. Where databases are periodically added and deleted. How can I set a backup of certain databases by mask. For example, a backup of only those databases that begin with the letter A.
Initially selecting databases for backup is not suitable. It is necessary that databases that match the mask are automatically included in the backup job when they appear on the server.

1 reply

RubeckDK
Byte
Forum|alt.badge.img+10
  • Byte
  • 67 replies
  • November 13, 2024

Hi.. 

I'm not aware on how to do this.. 
But as I see it, you would need to create subclients for DBs that are not added/ deleted and then let the catch all subclient "default" pick them up...

 

My two cents.. 

 

/Rubeck


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings