x Want to participate? Join the group to interact
  • State Verified Answer
  • +2 person also asked this people also asked this
  • Replies 10 replies
  • Answers 2 answers
  • Subscribers 243 subscribers
  • Views 2692 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
17
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
mmccleary2019

In System Administrator - Automatic backup fails

SOLVED
Posted By

I am curious if anyone else is having issues with the Automatic Backup Feature failing in the System Administrator.

I can backup manually just fine, but the auto backup gives me this error:

2018-12-25 20:00:00 Starting backup
2018-12-25 20:00:15 Folder does not exist: C:\ProgramData\SageReplicator
2018-12-25 20:01:05 There is no SQL Server service named “SQL Server (MSSQLSERVER)” running on this machine.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

The system cannot find the file specified
2018-12-25 20:01:05 Canceled

This is what I get from a manual backup:

2019-01-09 06:42:13 Starting backup
2019-01-09 06:42:30 Folder does not exist: C:\ProgramData\SageReplicator
2019-01-09 06:43:09 Successfully created C:\Users\administrator.AD\Desktop\Backup\backup190109_064213.zip

Any input would be appreciated.

Mary

Parents
  • +1
    verified answer

    I thought I would add to this thread.  We upgraded to 18.4.1 and now the automated backups are working.  It seems to be fixed.  I have it set to backup at 10:00 each night.  Then at Midnight I have a third party program back the backup files to the cloud.  Each night a new individual zip file is created so I keep about 4 months worth before I delete them out.

    I still get the Replicator can not be found message, but then it backs up.  Here is a small sample of my log.

    2020-05-16 00:00:00 Starting backup
    2020-05-16 00:00:17 Folder does not exist: C:\ProgramData\SageReplicator
    2020-05-16 00:01:02 Successfully created C:\Users\administrator.AD\Desktop\Backup\backup200516_000000.zip
    2020-05-17 00:00:00 Starting backup
    2020-05-17 00:00:17 Folder does not exist: C:\ProgramData\SageReplicator
    2020-05-17 00:01:02 Successfully created C:\Users\administrator.AD\Desktop\Backup\backup200517_000000.zip
    2020-05-18 00:00:00 Starting backup
    2020-05-18 00:00:17 Folder does not exist: C:\ProgramData\SageReplicator
    2020-05-18 00:01:02 Successfully created C:\Users\administrator.AD\Desktop\Backup\backup200518_000000.zip
    2020-05-19 00:00:00 Starting backup

    I have broken out the files from the zip and they are all correct and everything is included.  So I think it is fixed in 18.4.1

Reply
  • +1
    verified answer

    I thought I would add to this thread.  We upgraded to 18.4.1 and now the automated backups are working.  It seems to be fixed.  I have it set to backup at 10:00 each night.  Then at Midnight I have a third party program back the backup files to the cloud.  Each night a new individual zip file is created so I keep about 4 months worth before I delete them out.

    I still get the Replicator can not be found message, but then it backs up.  Here is a small sample of my log.

    2020-05-16 00:00:00 Starting backup
    2020-05-16 00:00:17 Folder does not exist: C:\ProgramData\SageReplicator
    2020-05-16 00:01:02 Successfully created C:\Users\administrator.AD\Desktop\Backup\backup200516_000000.zip
    2020-05-17 00:00:00 Starting backup
    2020-05-17 00:00:17 Folder does not exist: C:\ProgramData\SageReplicator
    2020-05-17 00:01:02 Successfully created C:\Users\administrator.AD\Desktop\Backup\backup200517_000000.zip
    2020-05-18 00:00:00 Starting backup
    2020-05-18 00:00:17 Folder does not exist: C:\ProgramData\SageReplicator
    2020-05-18 00:01:02 Successfully created C:\Users\administrator.AD\Desktop\Backup\backup200518_000000.zip
    2020-05-19 00:00:00 Starting backup

    I have broken out the files from the zip and they are all correct and everything is included.  So I think it is fixed in 18.4.1

Children
  • 0 in reply to mmccleary

    Thank you.  Yes that was the backup process that I used prior to the upgrade also (SageBackup to .zip file on disk and then backup to cloud - keeping the zips for 6 months) .  It is good to know that this has been resolved in 18.4.1 - however I have been told that we are unable to upgrade further than 18.2.2 in Australia at this stage.  I am working on a script  (still testing)  which can be run with Task Scheduler to do backup to a .zip file etc.  to try to get around the issue until we can upgrade. 

*Community Hub is the new name for Sage City