See this Video for tips on migrating with Management Studio: http://screencast.com/t/K5KiX6heT8QX
- Use Object Explorer details in the old SQL Server
- Shift click to select multiple jobs then select the jobs ending in “(BBInfinity)” as these are job schedules generated in the front-end of CRM
- Right click and select Script jobs as CREATE
- Run the generated script on the new SQL Server
Two actions are required before running the script:
1. After the jobs were scripted, they have to be adjusted for different login before running on a new server, @owner_login_name.
2. In the script, adjust URL to avoid pointing to the old environment.