This post is more than 5 years old
1 Rookie
•
20 Posts
0
2157
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.
How can I do that?
Networker server and client: v7.6.2
SQL Module : 522
ble1
2 Intern
2 Intern
•
14.3K Posts
0
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.
TbeckDK
1 Rookie
1 Rookie
•
20 Posts
0
August 24th, 2011 03:00
Hi Johannes
Nice help, thank you.
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?
/Tommy
joka2
144 Posts
1
August 24th, 2011 03:00
You dont use directive to do this. You should mention the database to skip in the nsrsqlsv command.
put in backup command for the client resource this:
nsrsqlsv -s -h
and won't get backed up.
Regards,
Johannes
ble1
2 Intern
2 Intern
•
14.3K Posts
1
August 24th, 2011 03:00
The only way is to manually define databases or skip them at backup command level as noted above.