Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I installed sql server 2008 R2 Express successfully, then realised I need to get Full Text Search. So I downloaded the "Advanced Services Installation Package", but when I run it there is no option in the "Feature Selection" part for Full Text Search. Please don't tell me I hav to uninstall and reinstall?

share|improve this question

2 Answers 2

up vote 4 down vote accepted

No, unfortunately you'll have to install a new instance with the Advanced Services installation. In R2 you can only add features such as Full Text Search if you initially installed with the advanced services installation.

You could backup your database though and restore it to the new installation w/ Full Text Search. Or I think also detach/attach.

share|improve this answer
Yup that seems to have worked. Thanks –  hofnarwillie Jul 12 '13 at 20:34

Its a two step process.

  1. In the installer select Maintenance/Edition Upgrade to upgrade your existing instance.
  2. Run the installer again and select Installation/...or add features to an existing installation/Add features to an existing instance.
share|improve this answer
Sorry, tried this, no luck –  hofnarwillie Jul 12 '13 at 20:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.