Currently we are trying to move SQL SERVER databases across different servers. When planning this activity, I am wondering how would the daily jobs related to the database on the current server behave.. i am sure they will be broken.. but how would we handle this situation? Would we have to script the complete jobs again (Create from scratch)?.. or is there a way that these jobs can be moved to the future server?
Another following question is how will SSIS and Analysis services cubes be affected? is there a way, that the transition from the current server to the future on.. goes smoothly, with out much disturbance in the development?
Is there any checklist that needs to be followed accross while implementing this activity?