I have a domain controller on which I have SQL Server installed. All databases are setup to automatically backup everyday. Recently the error found in the footer started popping up whenever I login to an instance of the SQL Server Management Studio, and hence it disabled the automated backups. I searched the internet for a solution and the majority of the solutions were to "format" the pc! which I can't due to many complications.
I read somewhere on microsoft support blog that the solution was to "Uninstall SP1"
What SP1? can anyone help?
The error
TITLE: Microsoft SQL Server Management Studio
The type initializer for 'Microsoft.SqlServer.Management.Dmf.PolicyStore' threw an exception. (Microsoft.SqlServer.Dmf)
ADDITIONAL INFORMATION:
Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.Dmf)
Best Answer
Instead of formatting your PC, just fire up the installer package for your version of SQL Server (in my case, I accidentally uninstalled VS 2010 Shell, which it SQL Server Management Studio needs).
From the SQL Server Installation Center:
That should fix any problems you're having.