Backup Exec skipping SQL files

Posted on 2007-08-10
Last Modified: 2013-12-01
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,

Question by:pabby061203
    LVL 63

    Expert Comment

    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 !
    LVL 23

    Accepted Solution

    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
    LVL 9

    Expert Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    By default, Carbonite Server Backup manages your encryption key for you using Advanced Encryption Standard (AES) 128-bit encryption. If you choose to manage your private encryption key, your backups will be encrypted using AES 256-bit encryption.
    VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now