Safe X3 Console modification of path

SUGGESTED

Hi All,

I am moving the SQL database from C: drive to D: drive for existing client (Installed and configured Console 2 yrs back) because the C: drive was fully occupied.

If I move the SQL database, do I need to change the path on the Safe X3 management console? If yes,

1. how - manually OR system will auto-update after moving SQL to D: drive. Because i tested out before moving and i can't edit it.

2. what all need to be changed in Safe X3 management console. Do i need to change only the highlighted ones?

Appreciate your earliest support.

Thanks

Saber.

  • 0
    SUGGESTED

    Hi Saber

    Below are the tasks and scripts that I used for my last database file move.  My drive allocations and paths were different to yours, as were my database name, etc.   You'll need to adapt them to your environment.

    STEP 1: Take database offline in SSMS
    *********************************************
    USE master; --run this from master --please note
    ALTER DATABASE x3 SET OFFLINE WITH ROLLBACK IMMEDIATE;

    STEP 2: Copy files from elevated command prompt
    **********************************************************
    xcopy D:\Sage\X3\database\data E:\Sage\database\data /K /O /X

    xcopy D:\Sage\X3\database\log F:\Sage\database\log /K /O /X


    STEP 3: Edit database
    **************************
    USE master; --do this all from the master
    ALTER DATABASE x3
    MODIFY FILE (name='x3_log',filename='F:\Sage\database\log\x3_log.ldf'); --Filename is new location


    USE master; --do this all from the master
    ALTER DATABASE x3
    MODIFY FILE (name='x3_data',filename='E:\Sage\database\data\x3_data.mdf'); --Filename is new location


    STEP 4: Bring database online
    *****************************
    ALTER DATABASE x3 SET ONLINE;


    STEP 5: Edit adxinstalls.xml
    *****************************
    E:\Sage\SafeX3\ADXADMIN\inst\adxinstalls.xml

    edit rows:
    <database.adonix.sqldirdat>E:\Sage\Database\data</database.adonix.sqldirdat>
    <database.adonix.sqldirlog>F:\Sage\Database\log</database.adonix.sqldirlog>

    __________________________________________________________________________________________

    If all is looking good (and you're confident all is well) you can delete the old datafiles (in step 2 I just copied the whole path, instead of moving).

    I hope that helps.