Windows Server 2003，将sql 2000升级到2008 [英] Windows server 2003 ,Upgrade sql 2000 to 2008

问题描述

我们在服务器上安装了sql 2000(带有win server 2003)，在sql中，我们有正在运行的数据库(与用户和...)
我知道我们可以将sql版本升级到2008，但是是否需要再次附加数据库?

是否需要为用户设置配置并再次访问?

解决方案

我强烈建议您在沙盒服务器上创建数据库环境的副本，然后尝试进行升级.您的生产服务器.

通过识别任何问题，这不仅可以使您免于痛苦，而且还可以确定生产服务器离线的时间，从而可以正确地计划它.

Hi,
we have sql 2000 installed on our server(with win server 2003) ,and in sql we have databases which is working (with users and,...)
I know we can upgrade the sql version to 2008 ,but is this work needed to attach the db again ?

Is it necessary to set configuration for users and access again ?

what kind of risks this work can have?

解决方案

I would very strongly suggest that create a copy of your database environment on a sandboxed server and try upgrading that before you touch your production server.

Not only can this can save you a world of pain by identifying any issues, but you will be able to determine how long your production server will be offline for, allowing you to schedule it properly.

这篇关于Windows Server 2003，将sql 2000升级到2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！