Tuesday, October 6, 2009

error during SQL 2005 to SQL 2008 in-place upgrade

I came across a very wierd error when i was going for a in-place upgrade from SQL 2005 to SQL 2008. I had run the SQL Server upgrade Advisor to fix issues that needs to be taken care before the upgrade could take place.
I fixed the issues and then decided to do an upgrade. During the upgrade I came across an error - "Attributes do not match. Present attributes (Directory, Compressed, NotContentIndexed) , included attributes (0), excluded attributes (Archive, Compressed, Encrypted) "

To fix this kind of issue, it is important to note that the Microsoft SQL Server folder that is present in C:\program files of the server should neither be in compressed mode nor in archive mode.

If you come across this issue, please follow the below steps -
1> Check the folder "Microsoft SQL Server" in the path "C:\Program Files".
2> Right click on the Folder and select "Properties"
3> In the General Tab , there is an "Advanced" button.
4> Click on that button and see that the options "Folder is ready for archiving", "compress contents to save disk space" and "encrypt contents to secure data"are unchecked. If not, please uncheck it.

This shall resolve the issue with the SQL 2008 in-place upgrade.

7 comments:

  1. Thanks! I just copy and pasted my error message up to google and your blog was the first thing to come up. Fixed my problem asap

    ReplyDelete
  2. Thanks for the compliments.. I am trying to write the blog with real time scenario issues which I had faced. If you face any issue, let me know so that i can help troubleshoot.

    ReplyDelete
  3. I, of course, a newcomer to this blog, but the author does not agree

    ReplyDelete
  4. Werlcom to my blog. I hope you liike it.

    ReplyDelete
  5. thank you troubleshooterms :)

    ReplyDelete
  6. Thank you very much..this also applies in new sql server stand-alone installation...ΓΌ

    ReplyDelete
  7. thank u so much, i saved a lot time

    ReplyDelete