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

I had the same error after a clean install of Sql Server 2008 Express Edition after trying to create a new database.

These are the steps I followed and it worked for me using Windows 7 64 Bit:

1. Copy the file Microsoft.SqlServer.Sqm.dll located on C:\Program Files\Microsoft SQL Server\100\Shared
2. to folder C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE
3. and C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE.

Then next time I tried to add a database everything came up fine.