Solved

Problem Backup using DPM on SQL server 2005

Posted on 2011-03-15
10
1,393 Views
Last Modified: 2012-05-11
Hi,

I have tried do backup data base SQL server 2005 using DPM 2007. Show this message when start the job.

DPM could not start a recovery, consistency check, or initial replica creation job for SQL Server 2008 database FPCSQLDES-01\TesteDPM on fpcsqldes-01.FPC.CORP for following reason:
 (ID 3170)

An unexpected error occurred during job execution. (ID 104 Details: The system cannot find the path specified (0x80070003))

Retry the operation.

The destination of backup is TAPE .


Somebody have idea about this problem ?

0
Comment
Question by:aspenbr
  • 5
  • 5
10 Comments
 
LVL 20

Expert Comment

by:Marten Rune
Comment Utility
0
 
LVL 1

Author Comment

by:aspenbr
Comment Utility
I think this problem don´t have concern with tape drive because other all jobs work normally. I think this problem beteween  SQL Server service vss writer and DPM .

Thank very much
0
 
LVL 1

Author Comment

by:aspenbr
Comment Utility
I put user network service (local) for start sql vss write. The first problem is when I have tried open the computer SQL server doesn´t show me more, data base SQL only Share and Volumes. The log about erro for do jobs have changed too.

DPM could not start a recovery, consistency check, or initial replica creation job for SQL Server 2008 database SQLSERVER\TestDPM on name_serer_DPM for following reason:
 (ID 3170)


The VSS application writer or the VSS provider is in a bad state. Either it was already in a bad state or it entered a bad state during the current operation. (ID 30111 Details: Unknown error (0x80042318) (0x80042318))
0
 
LVL 20

Expert Comment

by:Marten Rune
Comment Utility
is it a virtual machine?
See: http://www.ms-news.net/f770/hyperv-backup-error-unable-to-configure-protection-8246501.html

If not can you give me the OS, SP etc.

//Marten
0
 
LVL 1

Author Comment

by:aspenbr
Comment Utility
Yes , the is virtual machine running Windows server 2008 64 bits Enterprise  service 2 . This enviroment running on Vmware ESX 3.5 .

Sorry for my late awnser
0
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

 
LVL 20

Expert Comment

by:Marten Rune
Comment Utility
did you follow the thread?

*********************Quotes*********************
Although the download link specifies only for Vista, it applies for Server
2008 as well. Please go ahead and install the KB followed by the integration
services on the guest VM and let us know if it works well.

http://support.microsoft.com/hotfix/...962&kbln=en-us

In the meantime, can i update the integrated services on each VM, or do i
have to wait till i restart the server?

You do need to wait for the restart, and after updating the integration
services, the VMs need to be restarted too.
*********************Quotes End*********************

Try, read up to see if this is similare to your problem, and report back in this thread

//Marten
0
 
LVL 1

Accepted Solution

by:
aspenbr earned 0 total points
Comment Utility
I have doubt , my server DPM is Windows server 2008 and client with SQL server 2005 running Windows 2003 64 bits then this patch (http://support.microsoft.com/kb/959962/) is for Windows 2008 ,  is right ?
0
 
LVL 20

Expert Comment

by:Marten Rune
Comment Utility
Well since it's a Virtual machine, I would try it (do a backup first ofcourse).

The patch was originally for Vista, but works on W2008. It wouldn't suprise me it it works on W2008 R2 aswell.

Do a backup and try it out.

Regards Marten
0
 
LVL 1

Author Closing Comment

by:aspenbr
Comment Utility
thank very all
0
 
LVL 20

Expert Comment

by:Marten Rune
Comment Utility
You're welcome.

Curious though, did you try the patch, or did you choose some alternative way to handle the problem. I would like to know if you tried the patch, and it failed. This feedback would be good for me.

Regards Marten
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
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…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

762 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

10 Experts available now in Live!

Get 1:1 Help Now