Symantec Job completed with exeptionsc

Hi Experts,

I have one question for Symantec Backup Exec 2014.
My SQL backup jobs are successful but with exceptions.

The output is always like the screenshot.

backup exceptions
I have checked the files, they are all on disk and selected for this backup job.
Eprs_AdminSystem ArchitectAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rhandelsCommented:
You are trying to backup the actual MDF file? For as far as i know this isn;t possible because the file is in use.
What you need to do is backup the database using the SQL manager (are these SQL databases??) and backup the .bak file in your file backup.
0
Eprs_AdminSystem ArchitectAuthor Commented:
the database is already backed up by Backup Exec.
Do I have to backup these files when the database is already backed up ?
0
rhandelsCommented:
Nope. These are the actual database files. But even more so, never backup (or try to backup) MDF or LDF files of a running database because it could possibly corrupt the files.

What you could do (just for exta safety that is) is backup the databases using SQL maintenance plan, this will create a .bak file (full database backup) and a .trn file (transaction log file) if you need those. Then use Backup Exec to backup those files.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.