브랜드

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

슈나이더 일렉트릭 Korea

자세히 알아보기
제품군
자세히 알아보기
제품군
  • 제품 문서
  • 소프트웨어 다운로드
  • 제품 선택기
  • 제품 대체 및 교체
  • 지원 및 연락처 센터
  • 영업소 검색
  • 견적 받기
  • 슈나이더 일렉트릭 커뮤니티
  • 채용
  • 회사 소개
  • 부정 행위 보고
  • 접근성
  • 뉴스룸
  • 투자자
  • Ecostruxure
  • 작업 검색
  • 블로그
  • 개인정보 취급방침
  • 쿠키 공지
  • 사용 약관
  • Change your cookie settings