Nancy,

 You will need to make special arrangements to backup these SQL databases.
In our shop we use SQL manager to schedule backups to files on the same
server.  The advantages of this method is that the recovery of a DB from
these local files is very fast and that ADSM can backup these local SQL
backup files.  The disadvantage s are  that you require more local hard
drive space and must validate the success of the SQL backup.

The other option is to use ADSM's ConnectAgent for Microsoft SQL server.
This will allow ADSM to do online backups of these databases.  You can find
info on the connect agents at ADSM's home page
"http://www.storage.ibm.com/storage/software/adsm/adsmhome.htm";

Good luck,
  Dan T.
----------
> From: Smith, Richard <smithrr AT MARITZ DOT COM>
> From: Smith, Richard <smithrr AT MARITZ DOT COM>
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: MS SQL Server files on NT not backed up
> Date: Friday, January 16, 1998 1:44 PM
>
> Nancy,
>
>         Most likely this is caused because the databases are up and
> running.  ADSM can not backup files that are open!!
>
> Rick Smith
> Maritz, Inc.
> Storage & Security Administration
> smithrr AT maritz DOT com
> (314) 827-1584
>
> > ----------
> > From:         Nancy Stevens[SMTP:Nancy_C_Stevens AT CSC DOT COM]
> > Sent:         Friday, January 16, 1998 11:20 AM
> > To:   ADSM-L AT VM.MARIST DOT EDU
> > Subject:      MS SQL Server files on NT not backed up
> >
> > Hello, everyone.  This is my first post to this list, and I am
> > relatively
> > new to ADSM and NT.   We have an NT 4.0 client that runs MS SQL Server
> > databases.  We have ADSM 2.1 installed on it and are doing an archive
> > of
> > certain directories.  But for the databases with .DB extensions, we
> > get the
> > message ANS4090E:  Access to the specified file or directory is
> > denied.
> > Could this be because the database is up and running, or is there some
> > sort
> > of permission problem?
> >
> > Nancy Stevens
> > CSC
> >