我們的品牌

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

歡迎造訪施耐德電機全球網站

歡迎訪問我們的網站
		
我们今天能为您提供什么帮助?
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

施耐德電機Taiwan

探索更多
系列:
探索更多
系列:

需要協助?

  • 產品選型工具

    快速輕鬆地為您的應用找到合適的產品和附件。

  • 取得報價

    立即線上提交您的銷售需求,專業團隊將主動聯繫您。

  • 購買地點

    輕鬆在您所在地區找到最近的施耐德電機經銷商。

  • 支援中心

    在同一位置找到滿足您所有需求的支援資源。

  • 產品文檔
  • 軟體下載
  • 產品選型工具
  • 產品替代和替換
  • 幫助和聯絡中心
  • 尋找我們的辦公室
  • 取得報價
  • 人才招募
  • 公司簡介
  • 舉報不當行為
  • 無障礙
  • 新聞中心
  • 投資者
  • 專業洞察
  • 台灣施耐德電機學院
  • 綠色影響力落差調查
  • Schneider Go Green 2025
  • 隱私政策
  • Cookie通告
  • 使用條款
  • Change your cookie settings