Archive job fails because there is no more log space

Product Line
ION Enterprise
Power Monitoring Expert

Environment
SQL Server Management Studio

Cause
This error occurs when the system is running out of disk space due to databases continuously backing up files.

Resolution

1. Open up SQL Server Management Studio and navigate to the ION_Data database from the database dropdown
2. Right-click on the ION_Data database and select Properties and go to Options and confirm that Recovery Model is set to Full then click OK
3. Right-click on the ION_Data database and navigate to Tasks and select Back Up
4. In the Backup type list box select Transaction Log
5. In the Destination section in the Back up to section select Disk or URL
6. In the file destination box confirm or select Remove and select Add to add a new destination for the backup file
7. Navigate to the Media Options page and select an Overwrite Media option. (Optional) In the Reliability section select one of the options below
8. Then in the Transaction Log section select either the Truncate the transaction log (this is for routine backup logs and removing inactive log entries) or Back up the tail of the log and leave database in a restoring state (used to back up the active log and prevent work loss)
9. Navigate to the Backup Options
10. Accept the default backup set name in the Name text box, or enter in a new name for the backup set
11. On the Backup set will expire section select either the After option and select a number of days or the On option and select a date
12. In the Compression dropdown keep Use the default server setting
13. Click OK

Note: Encryption section will be greyed out and can be used when back up to a new media set option is selected in Media Options section