在装有SQL Server 2005的服务器上进行SQL Express安装 [英] SQL Express Installation on a server with SQL Server 2005 on it

问题描述

我有一台运行SQL Server 2005的服务器，我想用SQL Server 2008 Express Edition代替它.计划是先将sql express安装到服务器上，然后我希望从server 2005创建数据库备份，停止server 2005，将数据库还原到server express 2008，然后继续进行.
我计划在执行任何操作之前先建立一个还原点，但是我想知道两个程序可以同时存在于同一台服务器上吗? (随着SQL Server 2005变得有效冗余，直到我将其完全删除为止).

我不希望备份数据库，然后删除2005的原因是，一旦数据库消失，我将无法重新安装它(出于无法控制的原因).因此，至关重要的是，如果sqlexpress 2008在安装和还原数据库后无法正常运行，我必须将其保留在适当的位置.

安装是否会引发您可能知道的任何问题.

安装之前我应该​​检查什么?

非常感谢您提供任何建议，替代想法或其他任何我需要注意的内容.谢谢.

Hi, i have a server running SQL Server 2005 and i would like to replace this with SQL Server 2008 express edition. The plan is to first install sql express on to the server, then I am hoping to create a back up of the database from server 2005, stop server 2005, restore database to server express 2008, and carry on seemlessly.

I have planned to take a restore point before i do anything at all, but i want to know can the two programs co exist on the same server? (With SQL server 2005 becoming effectively redundant until such time as i remove it entirely)

The reason i do not wish to back up the database, then remove 2005 is that i cannot reinstall it once it has gone, (for reasons beyond my control). Therefore it is critical i keep it in place should sqlexpress 2008 not function correctly once installed and database restored.

Will the installation throw up any problems that you may know of.

What should i check for prior to installation?

Any advice, alternative ideas or anything else i need to be aware of would be greatly appreciated.Thank you.

推荐答案

并行安装2008 Express问题(虽然我不是专家)，但我不确定要还原使用先前版本制作的备份.但是，无论支持什么，我都只想强烈建议在尝试在生产环境中执行该过程之前，先在VM中测试和练习您想做的任何事情.

Installing 2008 Express in parallel shouldn''t be a problem (I''m not an expert though), I''m not sure about restoring a backup made with a previous version. However, regardless of what''s supported I just wanted to strongly recommend testing and practicing whatever you want to do in a VM before attempting to perform the procedure in production.

这篇关于在装有SQL Server 2005的服务器上进行SQL Express安装的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！