Solved

Backup exec job failure

Posted on 2012-03-26
6
603 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
  • 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
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

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
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 …
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

760 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

19 Experts available now in Live!

Get 1:1 Help Now