Hi! Guys i found the another solution
I have face the error and every one tell the things different reasons but actually there are two major reasons for this error
1) You restore the version from Lower version to higher version (mean you get the back from SQL 2010 or SQL 2008 and restore in SQL 2005)
2) Your SQL server is 2008 or 2010 instance name on SQL 2005
Which is very rear but its happening with me and i found the solution here
http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/797cbb2a-f339-435c-a46f-79c4fe33d40d
And this solution is providing by IanlovesFrame
I have face the error and every one tell the things different reasons but actually there are two major reasons for this error
1) You restore the version from Lower version to higher version (mean you get the back from SQL 2010 or SQL 2008 and restore in SQL 2005)
2) Your SQL server is 2008 or 2010 instance name on SQL 2005
Which is very rear but its happening with me and i found the solution here
http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/797cbb2a-f339-435c-a46f-79c4fe33d40d
And this solution is providing by IanlovesFrame
How you identify it
Open your sql server and check the instance name
Check out selected area in the screenshot there is a 9.xxxx value that mean this instance name is for SQL 2005
Why this error arrived
If you have SQL 2005 before and you are installing SQL 2008 then it automatically select the 2005 instance name. Just select the new instance name for 2008 and the problem will be resolved
Regards
Rashid Bilgrami
http://www.bestvisualization.com
Comments
Post a Comment
Thanks for the Comments , Your review will display soon