SQL Server and its Agents.....

[Kevin_Bentley]

Hello,

I am using 11D to backup various SQL Databases and am getting the following error of about 25 lines, each line referencing something different on each backup.

Unable to open the item \\Server\MSSQL\Data\cmdbcpu.mdf - skipped.

Unable to open the item \\Server\MSSQL\Data\lowcpu.ldf - skipped.

Unable to open the item \\Server\MSSQL\Data\lowcpu.mdf - skipped.

Unable to open the item \\Server\MSSQL\Data\master.mdf - skipped.

Can anyone probvide me with some advice or a fix.

Regards,

Kevin.

[Patty_McGowan]

Hi Kevin,

It appears that Backup Exec is attempting to backup the physical files for SQL.

The SQL databases should be selected through SQL, not at the file level.

If you are backing them up through the SQL agent and are still getting this error, it would appear that the active file exclusion is disabled in the registry. 

To enable this please go into regedit and go to HKEY_LOCAL_MACHINE\SOFTWARE\VERITAS\Backup Exec\Engine\Misc and modify the Exclude Active Files from 0 to 1

This registry key will stop the attempt to backup the files associated with SQL and will allow the online backups to be successful. More information on this registry key can be found at:

http://support.veritas.com/docs/259152

[Ken_Putnam]

One thing to bear in mind if you decide to  re-enable AFE

if you ever want to shut down SQL and do a full flatfile bacup of the system (if you want to replace RAID Drives with larger drives for example) you'll need to dis-able it for that special backup

You can also manually exclude all MDF & LDF files in the selection  list, and leave AFE disabled

\\*\*  in the path selection

*.LDF, *.MDF in the files selection

select \exclude and \sub-directories