Moving sql server to another machine
-
We are about to move our sql server 2005 from one machine (32 bit) to new one- 64 bit edition (twice as powerful from a CPU, memory standpoints). To do this we are going to remove IBM RAID controller and move it to the new server. Then- to attach databases back.
Frankly not sure how good is this approach. Really appreciate any comments or shared experience. Thanks
-
Hi,
its not clear what you try to do?
- If its just moving database that resides on those disks with IBM RAID controller that you've mentioned, than it looks like it will be fine. Although I would suggest to have backup on another location, since I'm not 100% sure that new machine will accept new RAID controller with its configuration, with no problems - if this controller has been on 32bit platform then it have 32bit firmware etc (I suppose), which needs to be upgraded on 64bit release. This is not rule so you should check this on IBM. Anyway I would not do that - I would use dettach/attach, backup/restore.....based on database size and online requirements...
- If its about moving disks that have SQL installation on it (32bit) - it will not work
rgds
Sinisa
-
Dont forget to script user logins, jobs, custom error messages etc.
Or, as simplest way: backup|restore system databases (master, msdb).
Kindest Regards,Alexandr Volok
volok.blogspot.comMCITP: Database Administrator
SQL Server Russian Group www.sql.ru -
Thanks for your responses. My main concern was about system DBs. I played a bit yesterday and found that it's possible to restore system DBs from 32 to 64 bit server (I'll do this before moving RAID). Then after RAID moving will be completed I'll attach user DBs to 64 server (should not be a problem also). And I'll definately will made backup and script everything. Thanks again
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply