We currently have a SQL 2005 database (32 bit) sit on 2003 (64 bit)
server. We're planning to move all user dbs, jobs, logshipping,
maintenance plans, databasemail profile/account, operators, ssis
packages, etc... I mean everything... over to new cluster server 2003
(64 bit) with 64 bit sql. What's the best approach to complete this huge
task? What order should I take, eg. Model first, then msdb, then master,
etc...?

1. Backup / restore (model/msdb/master)

2. Dettach / re-attach (model/msdb/master). Do I need to use option
-c -m T3608 to restart sql server?

3. Use SSIS to automate some tasks

4. Manually script some of them out

5. Or combination of all above



What effect do I expect when moving dbs from 32 bit sql to 64 bit sql?
Both old and new servers are mixed mode.



Thanks for any advice.



Thanh




This electronic mail message and attachments contain
information which may be (a) LEGALLY PRIVILEGED,
CONFIDENTIAL AND PROPRIETARY IN NATURE, OR
OTHERWISE PROTECTED BY LAW FROM DISCLOSURE,
and is (b) intended only for the use of the Addressee(s)
named herein. If you are not the Addressee(s), or the person
responsible for delivering this message to the Addressee(s),
you are hereby notified that reading, copying, or distributing
this message is prohibited. If you have received this
electronic mail message in error, please contact us
immediately (by reply e-mail) to inform us of the error and
take the steps necessary to delete the message completely
from your computer system and any related data. Thank you.


MS Sql Server LazyDBA home page