In System Administrator - Automatic backup fails

Question

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 &ldquo;SQL Server (MSSQLSERVER)&rdquo; 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

mmccleary · Accepted 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

Jeff Rudacille · Answer

I agree that this backup solution is a step backwards. The backups can be automated through the Sage Admin interface however you are correct in that if anyone is in the system they fail. Running this is especially important if using the SQL Replicator. We actually host our Sage system on a virtual machine and that backup, with the SGL Database on the same machine, is how we feel assured of being safe as it takes a time in place snap shot. But I do check on these backups every few weeks and make sure they run occasionally.

Jeff Rudacille · Answer

Hello, I was more trying to point out alternate ways to backup as even in the best of cases the Sage Backup is not a great solution. But check out this article which describes something similar: 
 https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=96050&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=1492&cmd=displayKC&dialogID=64671&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl&openedFromSearchResults=true

Sage Construction & Real Estate

In System Administrator - Automatic backup fails

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING