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" 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" 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 >
