The message below indicates that the BA client is trying to back up
the actual SQL database file, which is not what you want.
You should exclude these within the DSM.OPT file. Something like:
        EXCLUDE *.MDF
        EXCLUDE *.LDF

As for the backup of the dumped SQL database backup, did you trying
running a selective backup? For example:

   DSMC SEL Z:\SQLServerBackups\AdventureWorks.bak


where "Z:\SQLServerBackups\AdventureWorks.bak"
points to your dumped SQL Server database backup.


Thanks,

Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 09/05/2013
09:53:39 AM:

> From: BrentFortune <tsm-forum AT BACKUPCENTRAL DOT COM>
> To: ADSM-L AT vm.marist DOT edu,
> Date: 09/05/2013 09:54 AM
> Subject: Filesystem Backup ERROR ANS1688I
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
> I am getting this error message when backing up the SQL dump files
> using the baclient.
> We specify the location of the dump files in the dsm.opt file yet
> the error message relates to the actual database file in a
differentlocation.
> Why would it try to backup the database .mdf file in a different
location?
> TSM client V6.2.2
>
> ANS1688I Sparse attributes for 'F:\Program Files\Microsoft SQL
> Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\distribution.MDF' cannot be
> backed up correctly because the volume from which the file is backed
> up does not support sparse files.
>
> +----------------------------------------------------------------------
> |This was sent by brentf AT puleng.co DOT za via Backup Central.
> |Forward SPAM to abuse AT backupcentral DOT com.
> +----------------------------------------------------------------------
>