将数据库升级到SQL Server 2008
如果我需要从 SQL Server 2005 升级 24x7 运行的网站的数据库 升级到 SQL Server 2008。
为了尽可能减少停机时间，我需要制定什么计划来完成升级过程？
升级数据库需要哪些步骤？
升级前需要检查什么？表现 ？登录？
有人告诉我，如果我得到另一台服务器，最好安装 SQL Server 2008 实例，然后备份数据库并恢复到新服务器，然后将新服务器的名称更改为真实服务器的名称，应用程序将无需任何操作即可运行。变化。
是这样吗？
如果更改服务器名称，默认实例名称也会更改吗？
if I need to upgrade the database of website that operates 24x7 from SQL Server 2005
to SQL Server 2008.
What the plan I need to task for the upgrade process with the minimum downtime possible ?
What are the steps required to upgrade the database ?
What do I need to check before the upgrade? Performance ? Logins ?
Someone told me that if I get another server it will the best to install SQL Server 2008 instance on and then backup the db and restore to the new server after that change the name of new server to the real one and the application will work with no changes.
Is that true ??
The default instance name will also change if I change the name of the server?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我倾向于同意你的“some 1”...最好的方法是拥有第二台服务器来启动并运行数据库，确保旧的连接字符串连接到它，然后切换到它。
这回避了使用新版本测试应用程序的整个问题...2008 查询引擎与 2005 查询引擎的行为存在差异，这可能会导致问题，特别是如果您有非常复杂的存储过程。你需要测试它......没有办法解决它。
话虽如此，虽然我知道学术上存在这些差异，但从 2005 年转到 2008 年我从来没有遇到过任何问题。微软有一个工具，Sql Upgrade Advisor，这可能会帮助您识别前进中的任何问题。
I tend to agree with your "some 1"...the best way to do this would be to have a second server that you get the database up and running on, make sure your old connection string connects to it, and then switch over to it.
This sidesteps the whole issue of testing your application with the new version...there are differences in behavior in the 2008 query engine versus 2005 that can cause problems, particularly if you have really complicated stored procedures. You need to test it...there's no way around it.
Having said that, while I know that these differences exist academically, I've never had any problems moving to 2008 from 2005. Microsoft has a tool, Sql Upgrade Advisor, which might help you identify any problems moving forward.