topic Re: CSA and moving SQL Server in Network Security

CSA and moving SQL Server

firestartest — Sun, 10 Mar 2019 09:23:56 GMT

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?

Re: CSA and moving SQL Server

owillins — Wed, 20 Apr 2005 18:29:26 GMT

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

Re: CSA and moving SQL Server

jeffasher — Tue, 26 Apr 2005 14:11:00 GMT

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.

Re: CSA and moving SQL Server

firestartest — Wed, 27 Apr 2005 07:27:36 GMT

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,

Re: CSA and moving SQL Server

jeffasher — Wed, 27 Apr 2005 11:02:04 GMT

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.