CAUTION: Use this procedure only when the user accidentally deletes the company folder from the \\Sage100Con\Company directory from Windows File Explorer. Before proceeding confirm a current backup of the company exists in the \\Sage100Con\Nightly or On-Demand folder.  

Step 1: Delete the database in MS SQL Server Management Studio

1. Open Microsoft SQL Server Management Studio on the server.
2. Connect to the SQL Server instance where the company database is located.
3. Expand Databases in the Object Explorer panel on the left.
4. Locate the database you want to delete.
5.  Right-click on the database name. Select Delete.
6. Select the box "Close existing connections" at the bottom.
7. Click OK.
8. Close Microsoft SQL Server Management Studio.

Step 2: Delete orphaned shares and tasks in Database Administration for Sage 100 Contractor

1. Connect to Database Administration for Sage 100 Contractor.
2. Click Toolbox, Server Tools.
3. Select Remove orphaned file shares. Click Remove Orphans.
4. Select Remove orphaned nightly maintenance tasks. Click Remove Orphans.
5. Close Database Administration for Sage 100 Contractor.

Step 3: Stop Sharing the database in Windows Computer Management

1. Open Windows Computer Management.
2.  Expand Shared Folders on the left.
3.  Click Shares.
4. Locate the company in the Share Name column on the right.
5. Right-click the company name. Click Stop Sharing.
6. Close Windows Computer Management.

Step 4:  Restore a current backup of the company

1. Connect to Database Administration for Sage 100 Contractor.
2. Click Tune Up/Back Up/Restore.
3. Click Restore Company from Backup.
4. Click Browse.
5. Go to the backup file:
   1. The default location is C:\Sage100Con\Backup\.
   2. Manual backups are stored in the On Demand folder.
   3. Scheduled backups are stored in the Nightly folder.
6. Select the backup file.
7. Click Open.
8. From the field labeled "Restore as", verify the name of the company.
9. Click Restore Company.