Unable to create protection group in SQL 2005

Asked By 10 points N/A Posted on -

I am using SQL 2005 and I want to create a group of security. I have followed the required procedure for protection all very properly, and then to I am receiving an error indicating the following:

“This item cannot be protected as a result of some requirement computer code is missing. Make sure that all requirement computer code is put in so defend this item (ID: 31008). Click facilitates looking over the list of requirement computer codes for the chosen item.” The indented SQL Server Volume is operating accurately.

Nevertheless this message was displayed when I attempted to protect a bit of private data.

Can the error be fixed?

Answered By 0 points N/A #124044

Unable to create protection group in SQL 2005


Hi Marvin,

As for your information you already have the required prerequisite. However, the protection agent has not yet been updated. To resolve your queries just follow this steps;

A. Validate that the protected computer if had the appropriate updates installed.

You can verify the requirements to this link;
Software update 940349 must be installed also on the Data Protection Manager server and on each protected computer that is running Windows Server 2003 Service Pack 1 (SP1) or a later version of Windows Server 2003.

For more information about software update 940349, click the following link; Availability of a Volume Shadow Copy Service (VSS) update rollup package for Windows Server 2003 to resolve some VSS snapshot issues.

Things to Remember;

  •     If the data source is placed on a server cluster, each cluster node should be updated.
  •     If the data source is placed on a Microsoft Office SharePoint Portal Server farm, each member server of the farm should be updated.
  •     This condition also includes any instances of SQL Server that may be used as a back end for the farm.

      B. Need to Update the protection agent

When the prerequisite software updates have been installed, then you may update the protection agent. Just follow this procedure;

  •     Establish the Data Protection Manager 2007 Administrator Console, and then click the Management tab.
  •     Now click the Agents tab, and then click Refresh information in the Action pane.
  •     Confirm that OK appears in the Agent Status column for each protected server.
  •     Then click the Protection tab, and then follow the procedure below:

                       a. Generate a new protection group, or modify an existing protection group.

                       b. Select a data source.

  •     Verify that you can add a data source to the protection group successfully.

Hope this help,

Best Regards,

Login/Register to Answer

Related Questions