Issue
When trying to archive ION_Data this error shows up:
"The database archive failed. Description: The log file for database 'ION_Data' is full. Back up the transaction log to free up some log space. Error code: -2147217900"
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
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
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
- Open up SQL Server Management Studio and navigate to the ION_Data database from the database dropdown
- 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
- Right-click on the ION_Data database and navigate to Tasks and select Back Up
- In the Backup type list box select Transaction Log
- In the Destination section in the Back up to section select Disk or URL
- In the file destination box confirm or select Remove and select Add to add a new destination for the backup file
- Navigate to the Media Options page and select an Overwrite Media option. (Optional) In the Reliability section select one of the options below
- 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)
- Navigate to the Backup Options
- Accept the default backup set name in the Name text box, or enter in a new name for the backup set
- 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
- In the Compression dropdown keep Use the default server setting
- 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