Express to Standard

If I have sql 2005 express installed with a data in it, how can i upgrade
that to SQL standard 2005 without bringing the database down?
Thanks
You can't. The upgrade will replace the executable files so they have to be
closed before they can be overwritten. You can do the upgrade while SQL
Express is running but then it won't take effect until you reboot the
machine because the files will be in use.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Chanaka" <Chanaka@.discussions.microsoft.com> wrote in message
news:EF8EDB2B-A5BF-4F05-B454-C62970AFE7B6@.microsoft.com...
> If I have sql 2005 express installed with a data in it, how can i upgrade
> that to SQL standard 2005 without bringing the database down?
> Thanks
|||Thanks Roger!
"Roger Wolter[MSFT]" wrote:

> You can't. The upgrade will replace the executable files so they have to be
> closed before they can be overwritten. You can do the upgrade while SQL
> Express is running but then it won't take effect until you reboot the
> machine because the files will be in use.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Chanaka" <Chanaka@.discussions.microsoft.com> wrote in message
> news:EF8EDB2B-A5BF-4F05-B454-C62970AFE7B6@.microsoft.com...
>