| Nightly backups and maintenance aren't running |
Cause | - The server's hard drive has little free disk space available
- The NT AUTHORITY\SYSTEM account doesn't have the correct permissions assigned
- The nightly backup schedule conflicts with another backup application
- The nightly maintenance task isn't running under the System account
- The \\Sage100Con\Temp folder contains extra files
- The Sage 100 Contractor folder permissions have been changed
- The server is in sleep or hibernate mode during the nightly backup schedule
|
Resolution | The following solutions match the issues in the Cause section above. The server's hard drive has little free disk space available Review and follow the recommended system requirements. 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.
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 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 \\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 Sage 100 Contractor folder permissions have been changed - Ensure your file folder permissions match those noted in File shares and permissions.
- Revert to the specified required permissions by following these steps:
- 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 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.
[BCB:154:Chat 100 Contractor US:ECB] |
|