asked on
SQL Jobs are not automatically created after moving CRM 3.0 database to a new SQL server
Hi Experts,
I have just moved my CRM 3.0 database to a new SQL 2005 server, and the jobs are not created on the new server. How can I manually move the jobs scripts over from the old SQL 2005 server to the new SQL 2005 server. (ie: SQL Server Agent \ Jobs - in SQL server management studio). There is a microsoft document on this (kb - 910044), but it basically says call microsoft customer service.
Any help is greatly appreciated..
Thanks
smbcs
I have just moved my CRM 3.0 database to a new SQL 2005 server, and the jobs are not created on the new server. How can I manually move the jobs scripts over from the old SQL 2005 server to the new SQL 2005 server. (ie: SQL Server Agent \ Jobs - in SQL server management studio). There is a microsoft document on this (kb - 910044), but it basically says call microsoft customer service.
Any help is greatly appreciated..
Thanks
smbcs
Enterprise SoftwareMicrosoft DynamicsMicrosoft SQL Server 2005
Last Comment
chapmandew
You should be able to script jobs from the old server and roll these out in the new server..
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
If the jobs were setup through a maintenance plan, you can use the SSIS connection to copy the maintenance plans.
ASKER
I just did a backup and restore of the msdb database. And the jobs were brought across. Is there any problem with doing this method?
It is not a recommended option, there could be problems with job ownership as the SId's are held in the master..syslogins table and the ones in the restored msdb database may be incorrect..
ASKER
Ok, I did a backup of the original before restoring the one from the old server. I will resore back and try the method specified.
ASKER
How do I now add these sql scripts to the new jobs folder once they are created via the method above?
ASKER
If I do an import of the msdb database from the old server will that be any different to restoring?
ASKER
I need some further help with this. Any more detailed information would be greatly appreciated. This really is not my area of expertise.
Thanks.
Thanks.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Does this mean I copy it into a query editor window and the "execute" from the menu? I have tried this with a test maintenance plan, but it does not add the job or maintenance plan to the relevant menus. I am using SQL 2005
yes, it does. did you refresh the jobs after you ran it?
ASKER
Tried it with what I with the CRM scripts I was meant to be running and it was all ok. Thanks.
Just need to run all of them now.
Just need to run all of them now.
ASKER
Hi Chapmandew,
I have one last issue that I have not really had any help with and thought you may be able to guide me in the right direction...
https://www.experts-exchange.com/questions/24193340/Email-In-CRM-not-working-after-moving-SQL-2005-database-to-new-server.html?cid=239&anchorAnswerId=23783787#a23783787
I have one last issue that I have not really had any help with and thought you may be able to guide me in the right direction...
https://www.experts-exchange.com/questions/24193340/Email-In-CRM-not-working-after-moving-SQL-2005-database-to-new-server.html?cid=239&anchorAnswerId=23783787#a23783787
I'll check it out...please close out this question.