{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Schneider Electric USA Website

Welcome to our website.
How can we help you today?
Archive job fails because there is no more log space

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"
Example of error

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

Schneider Electric USA

Explore more
Range:
Articles that might be helpful Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Range: