01-06-2011 07:24 AM
I upgraded from BE12.5 to BE 2010R2 and now I get errors on every backup for 3 different servers. Do I need to manually exclude all these files? Unable to open the item C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Data\master.mdf - skipped. Unable to open the item C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Data\mastlog.ldf - skipped. Unable to open the item C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Data\model.mdf - skipped. Unable to open the item C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Data\modellog.ldf - skipped. Unable to open the item C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Data\msdbdata.mdf - skipped. Unable to open the item C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Data\msdblog.ldf - skipped. Unable to open the item C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Data\tempdb.mdf - skipped. Unable to open the item C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Data\templog.ldf - skipped. Unable to open the item C:\Program Files\Symantec\Backup Exec\Data\bedb_dat.mdf - skipped. Unable to open the item C:\Program Files\Symantec\Backup Exec\Data\bedb_log.ldf - skipped.
01-06-2011 07:50 AM
Has anyone edited the registry to stop the effects of Active File Exclusion as these should be auto skipped in the background and not reported in the job logs.
01-06-2011 09:10 AM
Noone has changed any registry settings. Three servers (windows 2003 std) all had BE 12.5 running fine without these error messages. All three were upgraded to BE 2010r2 and all three are reporting those files as being skipped.
01-06-2011 10:31 AM
By default Backup exec skips .MDF and .LDF files . If you have SQL agent select the database through the SQL agent and Unchecked the SQL path from the Backup exec selection list.
Path which needs to Unchecked - C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Data\master.mdf.
01-06-2011 10:38 AM
The 12.5 version didn't skip these, or maybe it skipped them without warning? I can't see buying the SQL agent just to backup of the SQL database installed by Backup Exec itself to keep track of tapes and files backed up on the tapes.
01-06-2011 11:38 AM
There is no need to backup the Backup exec database as backup exec takes backup of its own database every day . It would be better to uncheck the path or ignore the exceptions.
01-06-2011 11:51 AM
The 12.5 version didn't skip these, or maybe it skipped them without warning?
I think that somehow AFE got tuned off during the upgrade, as database file extentions will be skipped without notification in the job log if AFE is turned on
01-06-2011 12:17 PM
I checked the registry and that key (to disable the exclude active files option) does not exist. I created a new test backup with a new file selection list, but it shows those database files as checked. I don't know if that feature (skipping those files) works by not including them in the selection list or something else.
I will manually uncheck those files for now.
01-06-2011 12:52 PM
I don't know if that feature (skipping those files) works by not including them in the selection list or something else.
even if the files are specifically selected, AFE wil bypass them (with no notice in the job log) at backup time, if it is enabled for that file type
and as mentioned already, BackupExec does a database backup every day at 0400 (by default, this is changeable) to the file BEDB.BAK