-2

I have a windows vps with sql2008 express r2 (with tools) installed, one of my clients require full-text search feature. Sql 2008 with advance services has that feature. So my question is, is it possible to upgrade my normal sql2008 express with sql2008 with advanced tools without loosing any databases ?

Regards Bradley

Bradley
  • 3
  • 4

1 Answers1

1

It's possible to upgrade to SQL Server 2008 Workgroup up to Enterprise. See the upgrade matrix here. However, you should always make sure you have backups and a recovery strategy when dealing with critical data.

colealtdelete
  • 6,017
  • 2
  • 30
  • 34
  • Thanks, so according to the upgrade matrix it should be safe to upgrade sql express with tools to sql 2008 express advanced services. I just dont want any downtime – Bradley Sep 01 '13 at 20:13
  • 2
    There will be downtime while you are doing the upgrades. No easy way around that. – Grant Sep 01 '13 at 21:33
  • @Grant is correct. I'd rather do it right the first time than feel the pain of rebuilding the environment from the ground up after a failed upgrade. – colealtdelete Sep 01 '13 at 22:24
  • Ok i gave it a try and it failed, it said that this instance cannot be upgraded. I dont understand i have sql express 2008 and i want to upgrade to sql 2008 advenaced features. What am i missing ? – Bradley Sep 02 '13 at 07:44
  • Might be a dumb question do i have to stop the service first before i upgrade ? – Bradley Sep 02 '13 at 08:06