Microsoft SQL Server 2008 error when restoring database

Question

I've just recently upgraded to SQL Server 2008 from 2005 and when I attempt to restore a database I get the following error...

"Could not load file or assembly 'Microsoft.SqlServer.Sqm, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"

Answer 1

Did you upgrade your SSMS to version 2008?

Answer 2

I'm not sure of what the exact problem was but I went with the solution of uninstalling SQL Server completely then re-installing. These are the steps I followed...

1. I uninstalled everything SQL Server related I could find in add/remove programs.
2. Ran "CCLeaner" both for programs/windows components and the registry
3. Removed any left over SQL Server folders from my hard drives which seemed to be from previous SQL Server installations.
4. Re-install SQL Server 2008.

And voila everything works.

Answer 3

Get the answer from below : http://www.sqllion.com/forums/topic/could-not-load-file-or-assembly-microsoftsqlserversqm