Solved

Backup exec job failure

Posted on 2012-03-26
6
611 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
PowerShell one liner to pull server names 3 61
Backup / Restore an iphone 8 79
NAS - HP DataVault X510 and Windows Home Server 14 47
IBM TS3100 tape Library 3 21
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
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 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…

832 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