Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Problem Backup using DPM on SQL server 2005

Posted on 2011-03-15
10
Medium Priority
?
1,490 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

877 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