Sage 100 does not have a backup feature so you must be using a third party product which you have not mentioned.  No one can assist until we know what you are using.

Database Administration for Sage 100 Contractor SQL 

is where the set up for the back up is located

Part of your problem is that you have posted in the wrong section. Sage 100 and Sage 100 Contractor are totally different programs. Sage 100 is the old MAS90 and Sage 100 Contractor is I believe the old Timberline. You need to repost in the section for Real Estate and Construction form I believe it is. 

Well I would but this Sage City is not that easy to understand.

I started with Sage 100 Construction and Real Esate and when you click "New" is gives you options to Open a Discussion under....there is a Sage 300 Construction & Real Estate and a Sage 100 General Discussion...no option for Sage 100 Construction and Real Estate ???

Well I would but this Sage City is not that easy to understand.

I started with Sage 100 Construction and Real Esate and when you click "New" is gives you options to Open a Discussion under....there is a Sage 300 Construction & Real Estate and a Sage 100 General Discussion...no option for Sage 100 Construction and Real Estate ???

The Sage City mayor should be able to move the post to the correct location...

(Does someone at Sage responsible for branding pay attention to this kind of post?  The bad practice of naming different products the same thing is a completely unnecessary waste of time, and time is money).

Hi Conny.

The Sage Construction and Real Estate Support Group is located here:

https://sagecity.na.sage.com/support_communities/sage_construction_and_real_estate/

If you click on Forums when you get to this CRE group you will see an option for Sage 100 Contractor General Discussion in the list of forums (it is the 4th one from the top).

You can also click on the following link to go to the Sage 100 Contractor forum directly:
https://sagecity.na.sage.com/support_communities/sage_construction_and_real_estate/f/sage-100-contractor 

I will move your post to that forum so that other users of Sage 100 Contractor will see it and can offer you their thoughts and insight.

Thanks,

Derek

Thank you Derek for you help - I truly appreciate it.

Conny

Conny,

On the server, in the Nightly backup folder, there is a text file called SADMB_LastResultsLog.txt. If you open that file, there should be an error message for the database backup that is failing. What is that error?

Thank you,

Greig Hollister

Sage

2019-02-20  02:00:15   An unknown erroroccurred running the nightly maintenance and backup

2019-02-20 02:00:15  ERROR:  Exception of type 'Sage.S100C.SQL.Exceptions.LoginFailureException' was thrown.

Problem Fixed - never heard back from Sage City however we discovered how to fix it by Googling the error.  https://support.na.sage.com/selfservice/viewContent.do?externalId=76338&sliceId=1