TbeckDK

updated

15 years ago

T

TbeckDK

1 Rookie

20 Posts

0

2240

August 24th, 2011 00:00

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

    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.

  • TbeckDK

    1 Rookie

    20 Posts

    1097

    0

    Posted 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

    1097

    1

    Posted 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

    6 Operator

    14354 Posts

    56186 Points

    1097

    1

    Posted August 24th, 2011 03:00

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