Networker

Re: [Networker] Exclude DB

2009-02-25 08:59:36
Subject: Re: [Networker] Exclude DB
From: Craig Duncan <duncan_craigg AT EMC DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Wed, 25 Feb 2009 08:55:51 -0500
>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

<Prev in Thread] Current Thread [Next in Thread>