TbeckDK
1 Nickel

Is it possible to skip specific databases with directives?

Jump to solution

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

0 Kudos
1 Solution

Accepted Solutions
ble1
5 Iridium

Re: Is it possible to skip specific databases with directives?

Jump to solution

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.

0 Kudos
4 Replies
Highlighted
joka2
2 Iron

Re: Is it possible to skip specific databases with directives?

Jump to solution

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 <networker server> -h <databasename>

and <databasename> won't get backed up.

Regards,

Johannes

ble1
5 Iridium

Re: Is it possible to skip specific databases with directives?

Jump to solution

The only way is to manually define databases or skip them at backup command level as noted above.

TbeckDK
1 Nickel

Re: Is it possible to skip specific databases with directives?

Jump to solution

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

0 Kudos
ble1
5 Iridium

Re: Is it possible to skip specific databases with directives?

Jump to solution

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.

0 Kudos