| Nightly backups and maintenance aren't running |
Cause | - The NT AUTHORITY\SYSTEM account doesn't have the correct permissions assigned
- The Sage 100 Contractor folder permissions have been changed
- The nightly maintenance task isn't running under the System account
- The nightly backup schedule conflicts with another backup application
- The \\Sage100Con\Temp folder contains extra files
- The server is in sleep or hibernate mode during the nightly backup schedule
- The server's hard drive has little free disk space available
|
Resolution | Multiple reasons can contribute to this issue; review them in the order listed below. NT AUTHORITY\SYSTEM lacks the correct permissions - Open Microsoft SQL Server Tools on the server.
- Open Microsoft SQL Server Management Studio on the server.
- Choose the instance for Sage 100 Contractor in the Server name picklist.
- Click Connect.
- Expand Security in the Object Explorer panel.
- Expand Logins.
- Right-click NT AUTHORITY\SYSTEM. Select Properties.
- Click Server Roles, on the left.
- Select the boxes for public and sysadmin.
- Click OK.
- Close Microsoft SQL Server Management Studio.
Restore changed folder permissions - Ensure your file folder permissions match those noted in File shares and permissions.
- Connect to Sage 100 Contractor Database Administration
- Click Toolbox and Server Tools
- Click Restore permissions for the Sage 100 Contractor file system
- Click Restore Permissions
The nightly maintenance task isn't running under the System account - Press the Windows key + R to open the Run dialog.
- Type "taskschd.msc". Press enter.
- Expand the Task Scheduler Library, on the left.
- Click Sage 100 Contractor.
- Right-click the name of the nightly scheduled task, on the right. Select Properties.
- Verify the nightly maintenance task is running on the System user account.
The nightly backup schedule conflicts with another backup application - Press the Windows key + R to open the Run dialog.
- Type "taskschd.msc". Press enter.
- Expand the Task Scheduler Library, on the left.
- Review the Task Scheduler Library's other third-party backup tasks.
- Review and adjust the timing of other scheduled backup tasks to avoid conflicts.
The \\Sage100Con\Temp folder contains extra files - Open Windows File Explorer on the server.
- Click View on the menu.
- Click Show and Hidden items.
- Browse to [Installation Drive]: \Sage100Con\Temp.
- Ensure the only file in this location is Description.txt.
- Delete all files from this location except for Description.txt.
The server is in sleep or hibernate mode during the nightly backup schedule - Press the Windows key + R to open the Run dialog.
- type "control" and press enter.
- Select Power Options.
- Click Change plan settings next to your selected power plan.
- Click Change advanced power settings.
- Expand the Sleep section.
- Under Sleep, choose Never.
- Expand the Hibernate section.
- Set Hibernate after to Never.
The server's hard drive has little free disk space available Ensure the server has enough free disk space. Review the recommended system requirements. [BCB:154:Chat 100 Contractor US:ECB] |
|