We are running SQL Server 2000 Standard Edition sp3a on a WIN2003 Server with CRM and Reporting Services installed all on the same box.
I now need to move the CRM and Report Server SQL Server Backends to another Database Server (We want a Two Server deployment Model)
What I have done so far is backup the two CRM Databases and the two Reporting Services Databases (and all associated User IDs) on the the Server containing the CRM and Reporting Services APPS AND the SQL Server Backend and Restored them to a new SQL Server Backend Server. After doing this we successfully pointed the CRM app to the New Databases on the 2nd Server.
Now I'm not sure what to do with the Reporting Services peice of it !!!!
I found an article on how to move a Reporting Services Database
but it seems like some things are missing????
It say move a SQL Server 2000 Reporting Services Database to another computer and make Reporting Services point to that Database to do the following:
Backup the ReportServer and ReportServerTempDB databases on the Source Server
Restore the Databases to a SQL Server Instance running on another Computer
(I did both of these steps and I also recreated all logins associated with CRM and Reporting Services on the new SQL Server
Next the Article says to make Reporting Services repoint to the database on the new sql server, run the RSCONFIG command line Utility. Did this.
Now, I'm not sure what else I need to do. There are a bunch of scheduled jobs on the original SQL Server that did not move ie: MSCRM Identity Reseeding, MSCRM Index Reseeding, MSCRM Stored Procedure Priming
Do I need to move these Jobs? I'd like to uninstall the SQL Server on the CRM/Reporting Services Box at some point ....
Should I backup MSDB on the Original Instance and restore it to the new SQL Server Backend...............
Also, how can I verify that moving the Reporting Services Backend peice of it worked?
Can anyone offer any suggestions?????
I now need to move the CRM and Report Server SQL Server Backends to another Database Server (We want a Two Server deployment Model)
What I have done so far is backup the two CRM Databases and the two Reporting Services Databases (and all associated User IDs) on the the Server containing the CRM and Reporting Services APPS AND the SQL Server Backend and Restored them to a new SQL Server Backend Server. After doing this we successfully pointed the CRM app to the New Databases on the 2nd Server.
Now I'm not sure what to do with the Reporting Services peice of it !!!!
I found an article on how to move a Reporting Services Database
but it seems like some things are missing????
It say move a SQL Server 2000 Reporting Services Database to another computer and make Reporting Services point to that Database to do the following:
Backup the ReportServer and ReportServerTempDB databases on the Source Server
Restore the Databases to a SQL Server Instance running on another Computer
(I did both of these steps and I also recreated all logins associated with CRM and Reporting Services on the new SQL Server
Next the Article says to make Reporting Services repoint to the database on the new sql server, run the RSCONFIG command line Utility. Did this.
Now, I'm not sure what else I need to do. There are a bunch of scheduled jobs on the original SQL Server that did not move ie: MSCRM Identity Reseeding, MSCRM Index Reseeding, MSCRM Stored Procedure Priming
Do I need to move these Jobs? I'd like to uninstall the SQL Server on the CRM/Reporting Services Box at some point ....
Should I backup MSDB on the Original Instance and restore it to the new SQL Server Backend...............
Also, how can I verify that moving the Reporting Services Backend peice of it worked?
Can anyone offer any suggestions?????