Express to Standard

#1

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

#2

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 (AT) discussions (DOT) microsoft.com> wrote

Quote:

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

#3

Thanks Roger!

"Roger Wolter[MSFT]" wrote:

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:EF8EDB2B-A5BF-4F05-B454-C62970AFE7B6 (AT) microsoft (DOT) 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Express to Standard

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Express to Standard - 03-08-2007 , 01:38 PM

Re: Express to Standard - 03-09-2007 , 08:58 AM

Re: Express to Standard - 03-09-2007 , 09:16 AM