Solved

Problem Backup using DPM on SQL server 2005

Posted on 2011-03-15
10
1,431 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
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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

749 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