Sunday 31 March 2013

Error - "Failed to retrieve data for this request (Microsoft.SqlServer.Management.sdk.sfc)"

ErrError    - In Microsoft SQL Management Studio 2008, you receive the following error message when you try to expand the Databases:

                 "Failed to retrieve data for this request (Microsoft.SqlServer.Management.sdk.sfc)"

ReSolution - This problem occurs because of the following reason:

                   1. One or more databases are in an "offline" mode.


                   2. SQL Server Management Studio cannot correctly read one or more databases.Therefore,certain properties of a database cannot be retrieved. To Resolve this error, perform the following steps.

===========================================================


1. Login to the SQL Management Studio and expand the databases.

2. Close the error message "Failed to retrieve data for this request...."


3. Press F7 to open the Object Explorer Details pane.


4. Right-click the column headers, and make sure that only the following columns are selected:


Name
Date Created
Policy Health
Owner


5. Finally, Right-click the Databases node, and then click Refresh.
===========================================================

No comments:

Post a Comment