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 |
|
montblanc
Starting Member
3 Posts |
 Posted - 2008-01-24 : 02:52:13
|
HiOur costumer is going to install new hardware.Actually he is using 2 servers which both have windows 2000 server (+ AD) and sql server 2000 installed. On the new servers he will use windows 2003 and sql server 2005 The hard part will be migrating sql server 2000 to sql server 2005. I have read (not 100%, though) the SQL2005UpgradeTechRef document and downloaded SQLUASetup.exe to be ready (microsoft sql server upgrade analyzer software) But actually i want to know what is best upgrade path and what are your experience. Is there already a got (or better or perfect) document availabe for the sql server 2000 to sql server 2005 sql server side by side upgrade. Please help! thanks  |
|
|
montblanc
Starting Member
3 Posts |
Posted - 2008-01-24 : 05:02:17
|
| Hi againI thought that maybe the best solution would be: do an in place upgrade, make full back of entire database, security etc.. of upgraded sql server then take server offline. Then restore entire sql server backup on new server with sql server 2005please help !!!!! |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-24 : 05:55:01
|
| script logins, backup db's and msdbrestore on the new server, set compatiblitiy level to 9 and reindex all_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-05-26 : 21:39:20
|
| If it is Inplace upgrde then make sure all DB backup you already have it handy. To be in safe side you can take that in Tape as well.script all jobs, logins and DTS/SSIS package.Uninstall SQL from the server, beofre installing SQL 2005 create new AD group on the server then install SQL 2005 on the new build server.Rstore all DB on the new server any jobs, logins and DTS package.Make sure to change the Compatibilty of all DB's from 80 to 90. Otherwise you may get lots of error messages.ManojMCP, MCTS |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-05-26 : 21:46:56
|
| I would hope in 4 months the OP isn't very interested in this anymore.Are we going to drag up every old post on the site?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-26 : 21:56:41
|
| Thats right nr. We shouldn't drag post 4months or sometimes 4 years older. |
|
|
|
|
|
|
Migration from sql server 2000 to sql server 2005?