Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-06-09 : 02:03:23
|
| Dear Experts, we are planned to upgrade from sql server 2000 ent to sql server 2005 stand edition. will it accept or problem? can someone provide a brief information please.....ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-10 : 01:29:16
|
| Dear Expert Tara,Thank you very much for the reply, and i'm planning to upgrade my production server as well as replication server to 2005 from 2000.then1)what will happen to the present running jobs & schedules?2)what about all the objects...shall i do anything to them to upgrade or sql server automatically take care?3) as the server is production server, they dont want the downtime should be more. what steps can i do to upgrade....like go to services, there stopping the sql server, agent first.then take the sql server cd into tray and start upgradation, after finishing the upgradation, restart the services. is that enough?4)if so, which server first i need to do? replication server or production server?(transactional replication is there)5)after upgradation done on both the servers, shall i reconfigure the replication? or automatically sql server 2005 will take care?sorry for the home wrok like question, but as i'm very new to production environment, please understand my pressure and help me....thank you very muchArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-10 : 01:53:09
|
| Thank you very much Visakh i'm reading the articles.....if possible please think of my doubtsthank you very muchArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
|
|
can we upgrade from any edtion to any edition