CSA and moving SQL Server

[firestartest]

Has anybody had issues moving SQL Server after VMS CSA management center has been installed?

The SQL server partition needs to be moved to a larger hard disk partition.

Anything specific I need to do?

[owillins]

If you want to move the database, then you would have to reinstall the application onto the different drive.

[jeffasher]

You can stop the CRMDMGTD service, do a SP_Detach_DB in SQL Manager to detach the CSAMC database, move the database to a new drive and then run SP_Attach_DB in SQL Manager and restart CRMDMGTD. Any SQL Server DBA should be ale to help you out with the stored procedures. I've done this several times without incident.

[firestartest]

Hi

Is there anything you need to do in VMS or CSA as well as the SQL manager procedure? Or if I do what you say, that's all there is to it?

Thanks,

[jeffasher]

I failed to mention that it is a good idea to put the CSA MC server itself into test mode before you do this, but that is all there is to it. CSA MC talks to the SQL Server and SQL Server doesn't care where you put the data files as long as you use the right procedure.

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071#XSLTH3125121122120121120120

Remember to take the MC out of test mode when you are done. That is all there is to it. There are no other changes that need to be made to CSA or VMS. Like I said CSA talks to SQL Server and as long as SQL Server can do its job everything is good and CSA MC doesn't care about anything else.