>From the NMSQL 5.2 Admin Guide "Table 21 Command options for nsrsqlsv (page 2
>of 3)", on page 124.
-h Is used to exclude a database from the backup. For example:
nsrsqlsv -s bv-aditya.belred.legato.com -h master -h model MSSQL:
This will backup a default instance excluding the master and model databases.
-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of James Pratt
Sent: Wednesday, February 25, 2009 4:44 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: Re: [Networker] Exclude DB
Hi - I am assuming Denis was asking about the mssql module - you can certainly
backup individual db's and exclude what you wish, but you would have to
manually add new ones to the save set attribute, which is probably not
desirable, but still possible...
>From the 5.1 sql module admin guide , using NW 7.4.2 :
--
Save Set
Specify any valid save set names, for example:
MSSQL:
or
MSSQL:dbName1 [MSSQL:dbName2 MSSQL:dbName3 ...]
For example, entering only MSSQL: always yields a backup of all
databases on the SQL Server host.
--
Regards,
Jamie
> -----Original Message-----
> From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU]
> On
> Behalf Of Jóhannes Karl Karlsson
> Sent: Wednesday, February 25, 2009 5:42 AM
> To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
> Subject: Re: [Networker] Exclude DB
>
> As far as I know it's not possible to let application module backup use
> directives, and
> thus you can't skip specific database instances on an SQL server when running
> nsrsqlsv backup e.g.
>
> Directives only work for filesystem backups and it's good practice to skip
> the data
> folder containing the hot files (*.mdf *.ldf) for the database in each case.
>
>
>
> -----Original Message-----
> From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU]
> On
> Behalf Of Denis
> Sent: 24. febrúar 2009 21:33
> To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
> Subject: Re: [Networker] Exclude DB
>
> Hello,
>
> just create .nsr (or nsr.dir for windows) files in the client directories
> where you want
> to perform operations.
>
> Then fill these files with directives (as you make for the server) in order
> to exclude
> some files.
>
> +skip :
> pubs*.*
>
> Hope this helps.
>
>
> ----- "Ólafur Þ. Sveinbjörnsson" <olafur.sveinbjornsson AT SKYRR DOT IS> a
> écrit :
>
> > Hi, I was wondering how to exclude database's like Northwind, Pubs
> > etc... in the client part in Networker server ?
> >
> >
> >
> > Best Regards
> >
> > _________________________________________
> >
> >
> > Olafur Sveinbjornsson
>
> To sign off this list, send email to listserv AT listserv.temple DOT edu and
> type "signoff
> networker" in the body of the email. Please write to networker-
> request AT listserv.temple DOT edu if you have any problems with this list.
> You can access
> the archives at http://listserv.temple.edu/archives/networker.html or
> via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
>
> To sign off this list, send email to listserv AT listserv.temple DOT edu and
> type "signoff
> networker" in the body of the email. Please write to networker-
> request AT listserv.temple DOT edu if you have any problems with this list.
> You can access
> the archives at http://listserv.temple.edu/archives/networker.html or
> via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
To sign off this list, send email to listserv AT listserv.temple DOT edu and
type "signoff networker" in the body of the email. Please write to
networker-request AT listserv.temple DOT edu if you have any problems with this
list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
To sign off this list, send email to listserv AT listserv.temple DOT edu and
type "signoff networker" in the body of the email. Please write to
networker-request AT listserv.temple DOT edu if you have any problems with this
list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
|