| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-07-31 : 04:49:32
|
| Dear All,we have two servers at aone place, one is production server and another is for replication and both are sql server 2000 with 32 bit os. working fine.now i need to upgrade these servers two 2005. with 64 bit os.i've planned like this. please correct me where ever i'm wrongprod server is xns007 and replication server is xns008working with xns008 first.1)Analyzing the two servers and Databases, scheduled jobs2)stopping the replication and backup the databases, Jobs3)Scripting all the Jobs and Users4)Formatting and Upgrading the server (This will become the production server now)5)stop the Production server and detach the databases6)Manually copy the datafiles and logfiles to the New Server in which those are at the previous server.7)attach the databases to the New server8)change the IPaddress of the New server same as before9)Changing the Compatiability levelsNow we can start providing Database SupportWE are now with a New production server which is with 64 bit OS and sql server 2005 edition.now working with xns007Take the backup of Databases, users and jobs of Old server into another diskFormat the server and installation of OS and sqlserver 2005Now restore all the backups of databases as well as users and jobs in theSecond new server now which will be called as replication server.Configure the transactional replication and check for the latencynow replication also configured. so i'm running the user create scripts and job scheduling scripts.please correct me where ever i'm wrong. as this is a very big deal for me.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-31 : 23:35:57
|
| 5)stop the Production server and detach the databases6)Manually copy the datafiles and logfiles to the New Server in which those are at the previous server.7)attach the databases to the New serverI rather do backup/restore, much less risk. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-08-01 : 01:49:08
|
| Thank You very much Rmiao....i've updated the plan of action.may i know why you are not interested in attach and detach? what is the risk behind that?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-08-01 : 01:57:50
|
| Normally , I would try and do a side by side upgrade - i.e a fresh install of the SQL Server rather than an upgrade straight onto that existing instance. Also, run a UPDATE STATISTICS when you have upgradedJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-01 : 09:44:03
|
| I would do Backup/Restore instead of attach/detach. Because by some reasons you can't attach to SQL 2005 then you can't attach back in SQL 2000 .Remember to Rebuild highly fragmented indexes (which updates stats as well). |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-01 : 09:47:06
|
| Also you need to convert DTS packages to SSIS packages and test make sure they work before you go into production. Remember Activexscript with COM objects are not supported in SSIS. You need to rewrite in Script task. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-02 : 14:35:38
|
| Sql2k5 can run dts packages, you can convert them to ssis but not required. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-02 : 14:40:13
|
| but for designing/modifying dts packages in sql 2005 you need sql 2000 dts designer component. If you're opening dts in vs conversion wizard will launch and ask you for upgrading. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-08-04 : 01:15:24
|
| thank you very much. now i've decided that i'm going for backup and restore.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
upgradation help