[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1695
  • Last Modified:

Backup Exec skipping SQL files

SQL Files being skipped - 'unable to open item'
I need to ensure that my dbases are being backed up but my backup is skipping a lot of ldf and mdf files.

I have the SQL Agent installed and have read about an identical situation here in EE.  My Selections navigated through the network to the sql Server where it splits into F$ and E$. It seems  that it is the files in these two drives cannot be accessed. I am not sure if this is the correct way to backup my sql dbases - can someone please clarify,

1 Solution
I would also check that you have the latest SQL agent ad patches to BE.

Did you check the Symantec/ Veritas site for more info ?

I hope this helps !
Iamthecreator OMAdministrateur Systeme et ReseauxCommented:
Backup Exec is coded to skip the .mdf,.ldf,edb,stm files as they are database files.That is the reason that we have agents and options to backup specific resources.If you have selected the databases from under the SQL resources icons then and yr backups are successfull (apart from the skipped files exceptions),then rest assured that yr SQL databases are being backed up. If you want to backup the .mdf and .ldf file then it will have to be a flat file backup i.e you will need to detach/dismount the databases or stop  the SQL services and then back the files up
MDF files and LDF files of a running database are always in use by SQL server and can't be opened exclusevely by the backup program.
You should use SQL server to backup the database to a .BAK file (by using a maintenance schedule for instance) and then backup that file with our backupsystem.

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now