The other alternative (although risky, as it will only backup what you
explicitly state) is:

MSSQL:databasename
MSSQL:databasename2

Name each database, but don't forget to include any REQUIRED SQL
standard databases, such as Master. 

MSSQL:master
MSSQL:model
....
MSSQL:xxxxxxx

David M. Browning Jr.
IT Project Coordinator Enterprise Backups and Help Desk

 
-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of MIchael Leone
Sent: Tuesday, January 29, 2008 8:33 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: Re: [Networker] 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

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