Networker

Re: [Networker] backup mssql and directive

2008-01-29 12:01:06
Subject: Re: [Networker] backup mssql and directive
From: Vince Howard <V.Howard AT WANSBECK.GOV DOT UK>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Tue, 29 Jan 2008 16:57:31 -0000
Michael,

I thought Dirk was getting a database backed up as flat files (because
it was offline) and he wanted to avoid this - we do hot SQL backups
*and* system file backups of the same server here, so I use such a
directive.  I do know the difference between SQL client and normal
backups.

 
Best regards,
 
Vince
 
-----------------------------------------
Vince Howard
Programmer/System Administrator
IT Section
Wansbeck District Council
Front Street West
Bedlington
Northumberland
NE22 5TU
UK
 
Tel (DDI): +44 (0)1670 843472
Fax:       +44 (0)1670 843484
e-mail:    v.howard AT wansbeck.gov DOT uk
Web:       www.wansbeck.gov.uk

Please consider the environment before printing this email. Thank you.

 
> -----Original Message-----
> From: EMC NetWorker discussion 
> [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On Behalf Of MIchael Leone
> Sent: Tuesday, January 29, 2008 2:33 PM
> To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
> Subject: Re: backup mssql and directive
> 
> EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU> wrote on 
> 01/29/2008 04:16:25 AM:
> 
> > Dirk,
> > 
> > > Backup mssql databases with saveset definition mssql: works.
> > > But one database is down.
> > > How can i exclude this database with a directive ?
> > 
> > Try setting up a directive, something like the following:
> > 
> > << C:\ >>
> >     +skip: *.ldf
> >     +skip: *.mdf
> 
> That skips ALL databases, but on a file system backup (which 
> is not what 
> MSSQL: is used for; MSSQL: means to use the MS SQL module)
> 
> There's a command line option for nsrsqlsv where you can skip 
> a specific 
> database, altho I don't recall the specifics right now.
> 
> 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
> 
> 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed.  If you have received this e-mail in error please
notify the originator of the message.

Any views expressed in this message are those of the individual
sender, except where the sender specifies and with authority,
states them to be the views of Wansbeck District Council.

This footer also confirms that this e-mail message has been scanned
for the presence of computer viruses.

Wansbeck District Council Web Site is: www.wansbeck.gov.uk

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>