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
pjamAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
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.
0
pjamAuthor Commented:
Arnold,
Sorry, talking to a non-SQL person here.  You need to be more descriptive.
0
arnoldCommented:
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.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

pjamAuthor Commented:
Arnold,
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:
 http://social.technet.microsoft.com/Forums/en-US/c3eeacaa-4e8d-4c4f-83bc-b7d56e972aba/tape-backup-fails-after-partial-backup-id-30101-details-data-error-cyclic-redundancy-check.
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.
0
arnoldCommented:
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.

http://social.technet.microsoft.com/Forums/en-US/3af41c25-8fa3-4019-ad63-67adac0e6f1d/error-0x80042306-the-shadow-copy-provider-had-an-error?forum=winserverfiles
0
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?
0
arnoldCommented:
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.
0
pjamAuthor Commented:
No answer was given, so I removed the DPM 2007 database and started over
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pjamAuthor Commented:
no understandable answer ever given.  So, in desperation I basically started over
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.