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@vm.marist.edu> wrote on 09/05/2013
09:53:39 AM:
> From: BrentFortune <tsm-fo...@backupcentral.com>
> To: ADSM-L@vm.marist.edu,
> Date: 09/05/2013 09:54 AM
> Subject: Filesystem Backup ERROR ANS1688I
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L@vm.marist.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 bre...@puleng.co.za via Backup Central.
> |Forward SPAM to ab...@backupcentral.com.
> +----------------------------------------------------------------------
>
