I also faced this problem while opening the configuration manger it showed "MMC could not create the snap-in". The issue was with missing DLL "ATL80.dll". It was there at location...

I tell u one thing shut ur mouth and control hands (writing).if u cant no need to anything to anybody...some people are so disgusting...

Well, that was question and one should answer that.:-P

Tempdb backup cannot be taken.After SQL Server starts,tempdb is automatically created so if we take its backup the database will be in inconsistent state :-).Even no need of taking its...