SQL 2005 ensure you have latest SQL Server writer and VSS fixes installed-DPM 2007 Issues

I am having issues backing up our SQL Server Backups to DPM 2007.
Backups are stored on the D: drive and have been successfully backed up for some time, now however I am getting "Replica is inconsistent and when I try to fix it asks me to "Clear the VSS Vault".  I am assuming this is on the DPM server, but am not positive.
When I click on that it gives me an error:
An unexpected error occurred during a VSS operation.
Retry the operation.
ID: 207
Details: Unknown error (0x80042306) (0x80042306)

It also says to run chkdsk on volume \\?\Volume{d90a334b-6f3d-4daa-86b9-8f8bd6159f5d}\, and I get This type of file is RAW.  CHKDSK is not available for RAW drives.
I have posted on the DPM Technet forum and they are telling me to do SQL stuff I am not familiar with, such as the title of this post.
Can someone explain to Non-SQL person how to find and assure I have the latest SQL Server Writer and VSS fixes for Win2k3 Std and SQL 2005?
LVL 17
Who is Participating?
pjamConnect With a Mentor Author Commented:
No answer was given, so I removed the DPM 2007 database and started over
Select @@version
Or using ssms look at the version you have 9.0.xxxx
Sql team.com has a description using sql versions and what update level it has.
pjamAuthor Commented:
Sorry, talking to a non-SQL person here.  You need to be more descriptive.
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

I am uncertain how or what you are looking for.

Your issue might be a corrupted drive/partition or failing drive.

It is hard to cover.

You can use a windows install to get to the repair console where you can run chkdsk /r c: or whatever other partitions you have.
pjamAuthor Commented:
I was told on the DPM Forum said: "The VSS errors will need to addressed on the SQL Server - may want to ensure you have latest SQL Server writer and VSS fixes installed."

That post is at:
Currently only one of my Protection Groups is giving me that error, the other three seem fine, so that remains a mystery also.  the SQL Protection Group is the one that is failing, so originally i thought he was referring to the SQL Server.  But he is referring to the SQL2005 that is part of DPM 2007.
Use ssms to connect to the appropriate sql server instance within ssms as soon as the connection is made, the server information indicates the version.

pjamAuthor Commented:
I did not know what ssms was referring to in your first respond, Just figured it out.
This is from Help\About:
Microsoft SQL Server Management Studio                                    9.00.3042.00
Microsoft Analysis Services Client Tools                                    2005.090.3042.00
Microsoft Data Access Components (MDAC)                                    2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML                                    2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer                                    7.0.5730.13
Microsoft .NET Framework                                    2.0.50727.3643
Operating System                                    5.2.3790
This is what I see when I open SQL Server Management Studio:
Opening SSMS
So how do I proceed?
Your sql server/ssms is not at the latest level.
Connect to the sql server instance for DPM and where it lists server\instance includes the sql server version.

You may have different versions sql server and sql server express.

You need to get the appropriate updates.  The issues might be related to a component mentioned in the microsoft linked discussion.
pjamAuthor Commented:
no understandable answer ever given.  So, in desperation I basically started over
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.