Sage 100

 View Only

  • 1.  Disk space issues with SQL migration

    Posted 04-20-2024 19:55

    I have a 130GB company database that's trying to backup to its local ..\MSSQL\Data folder on the source server during migration before restoring to destination server, but there's not enough disk space. IT can't expand the C: drive, migration is ignoring my SQL Database Properties of using the F:/ or G:/ drives for Data, and IT also says they cannot give me a temporary SQL instance on the destination server to use for migration. Is there really no way to use anything other than the C:\Program Files\… for the source backup folder



    ------------------------------
    Amber Prayfrock, Blytheco
    ------------------------------


  • 2.  RE: Disk space issues with SQL migration

    Posted 04-20-2024 20:54

    Have you tried modifying the server's (right-click it and click properties to open the window on the right) backup setting?



    ------------------------------
    David Speck II
    Blytheco LLC
    ------------------------------



  • 3.  RE: Disk space issues with SQL migration

    Posted 04-20-2024 20:56

    I did. I tried a few different settings, restarting SQL services in between each attempt, but the Sage 100 migration keeps using the default SQL "Data" location.



    ------------------------------
    Amber Prayfrock, Blytheco
    ------------------------------

    Original Message


  • 4.  RE: Disk space issues with SQL migration

    Posted 04-21-2024 08:57

    Yes Sage's code ignores the SQL settings.  I think your only option will be Carmen's manual method.



    ------------------------------
    Phil McIntosh
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 5.  RE: Disk space issues with SQL migration

    Posted 04-21-2024 15:04

    Thanks, Phil. Once I can have some extra space on a server to use for the "source" system and a temporary SQL instance, I should be able to choose between a parallel or manual migration.



    ------------------------------
    Amber Prayfrock, Blytheco
    ------------------------------

    Original Message


  • 6.  RE: Disk space issues with SQL migration

    Posted 04-22-2024 10:54

    Bug.  I posted about it on Sage City here: link. 

    (There is a KB link higher up in the conversation).

    It seems to only happen when the data paths are changed after the initial SQL install.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 7.  RE: Disk space issues with SQL migration

    Posted 04-22-2024 11:08
    Edited by Amber Prayfrock 04-22-2024 11:10

    Thanks, Kevin. I wonder why the program fix was not carried forward to all versions then. I will need to report it to Sage so they can get it going for future v2023 and v2024 upgrades.

    This can be moved out of Urgent. I have asked IT again to provide a temporary server for a v2021 instance that I will use for migration since they are concerned about expanding the live server.


    ------------------------------
    Amber Prayfrock, Blytheco
    ------------------------------

    Original Message


  • 8.  RE: Disk space issues with SQL migration

    Posted 04-22-2024 11:20

    The Sage bug fix is for where the SQL data files land in the new instance.  I used that thread to also report the issue about the source server paths being wrong... with no response.

    Reporting to Sage would be helpful... I'm not sure if they fixed the source server path problem at the same time as the destination server path issues.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


Related Content