Is it possible to skip specific databases with directives?
Hi
we are doing backups of databases with the SQL module. And now I just need to know if it is possible to create a directive with skip of specific databases or perhaps even skip names with wildcard?
lets say we have 6 databases (db1, db2, db3, db1test, db2test and db3test)
Now I want to skip backup of the 3 test databases.
I do not think regexp is supported there. But, if you have fixed amount of databases, you could simply define those manually and then those new (*_restore) would be skiped for sure.
Now I just need to know if it's possible to use a wildcard with this method?
The scenario is that we have to use an active production SQL server, for restores of sharepoint SQL databases, from which they can copy contents to the original.
So we restore a copy of a database and names it _restore at the end of the original databasename.
But we don't want to backup the restored databases again, so I have to find a way to skip those.
Is it possible in any way, without knowing the exact name of the database?
ble1
6 Operator
•
14354 Posts
•
56186 Points
1097
0
Posted August 24th, 2011 04:00
I do not think regexp is supported there. But, if you have fixed amount of databases, you could simply define those manually and then those new (*_restore) would be skiped for sure.