Solved

Problem Backup using DPM on SQL server 2005

Posted on 2011-03-15
10
1,450 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
[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
  • 5
  • 5
10 Comments
 
LVL 20

Expert Comment

by:Marten Rune
ID: 35147492
0
 
LVL 1

Author Comment

by:aspenbr
ID: 35160461
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
ID: 35160555
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 20

Expert Comment

by:Marten Rune
ID: 35163739
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
ID: 35235534
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
 
LVL 20

Expert Comment

by:Marten Rune
ID: 35235680
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
ID: 35236675
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
ID: 35238392
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
ID: 35364761
thank very all
0
 
LVL 20

Expert Comment

by:Marten Rune
ID: 35367886
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

In the modern office, employees tend to move around the workplace a lot more freely. Conferences, collaborative groups, flexible seating and working from home require a new level of mobility. Technology has not only changed the behavior and the expe…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

632 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