Solved

Backup exec job failure

Posted on 2012-03-26
6
613 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

820 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