Solved

Backup exec job failure

Posted on 2012-03-26
6
616 Views
Last Modified: 2012-04-02
The Symantec backup exec job is failing to backup sql 2005 database with the following error
Its a windows 2003 server with sql 2005 sp4. Any ideas on how to fix this
Operating system error 0x80070002(The system cannot find the file specified.).
0
Comment
Question by:Malli Boppe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 2

Assisted Solution

by:ven16
ven16 earned 500 total points
ID: 37769968
is the Back up service account has full rights on SQL server DATABASE?
when you backing up SQL server back up service account need full permissions on Database.
if evrything is ok
Download and install the hotfixes from Microsoft KB Article 934396.
0
 
LVL 23

Author Comment

by:Malli Boppe
ID: 37770221
yeah backupexec account has got full access to the database.Also i can't install that patch as it requires SP2 and I am on SP4.
0
 
LVL 2

Expert Comment

by:ven16
ID: 37770282
what version Backup exec you using and is the SQL server virtual or physical?
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
LVL 2

Expert Comment

by:ven16
ID: 37770485
if it is virtual try this link
http://support.microsoft.com/kb/969273
0
 
LVL 23

Accepted Solution

by:
Malli Boppe earned 0 total points
ID: 37779435
Seems SQL SP4 has fixed the issue.It just needed a reboot.
0
 
LVL 23

Author Closing Comment

by:Malli Boppe
ID: 37795196
Solved my self
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

742 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