How can we help you today? How can we help you today?
Sławomir &#3
Activity overview Badges (0) Posts (1) Comments (1)

Activity overview

Latest activity by Sławomir &#3

Sure, the related logs below (I removed some sensitive information from them). 1) Last successful: SQL Backup log file 5.3.0.178 -SQL "BACKUP LOG [DATABASE_NAME] TO DISK = 'DRIVE_LETTER:\DIRECTORY_NAME\DATABASE_NAME_DATABASE_NAME_20101027_064001.trn.sqb' WITH CHECKSUM , COMPRESSION = 3 , STOP_ON_ERROR , DESCRIPTION = 'DATABASE_NAME - DATABASE_NAME - log backup - 2010-10-27 06:40' , INIT , KEYSIZE = 256 , NAME = 'DATABASE_NAME - DATABASE_NAME - BACKUP MEDIA' , PASSWORD = 'XXXXXXXXXXXX' , SINGLERESULTSET , THREADPRIORITY = 3 " PROCESSES COMPLETED SUCCESSFULLY 2010-10-27 06:40:01: Backing up DATABASE_NAME (transaction log) to: 2010-10-27 06:40:01: DRIVE_LETTER:\DIRECTORY_NAME\DATABASE_NAME_DATABASE_NAME_20101027_064001.trn.sqb 2010-10-27 06:40:01: BACKUP LOG [DATABASE_NAME] TO VIRTUAL_DEVICE = 'SQLBACKUP_3CD67858-352D-4C77-B362-FBBF40154B23' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'DATABASE_NAME - DATABASE_NAME - BACKUP MEDIA', DESCRIPTION = N'DATABASE_NAME - DATABASE_NAME - log backup - 2010-10-27 06:40', CHECKSUM 2010-10-27 06:40:06: Backup data size : ? MB 2010-10-27 06:40:06: Compressed data size: ? MB 2010-10-27 06:40:06: Compression rate : 75,52% Processed ? pages for database 'DATABASE_NAME', file 'DATABASE_NAME_Log' on file 1. BACKUP LOG successfully processed ? pages in ? seconds (17.943 MB/sec). 2010-10-27 06:40:06: SQL Backup process ended. 2) Next first failed (due to the lack of the free space on the drive) SQL Backup log file 5.3.0.178 -SQL "BACKUP LOG [DATABASE_NAME] TO DISK = 'DRIVE_LETTER:\DIRECTORY_NAME\DATABASE_NAME_DATABASE_NAME_20101027_065000.trn.sqb' WITH CHECKSUM , COMPRESSION = 3 , STOP_ON_ERROR , DESCRIPTION = 'DATABASE_NAME - DATABASE_NAME - log backup - 2010-10-27 06:50' , INIT , KEYSIZE = 256 , NAME = 'DATABASE_NAME - DATABASE_NAME - BACKUP MEDIA' , PASSWORD = 'XXXXXXXXXXXX' , SINGLERESULTSET , THREADPRIORITY = 3 " ERRORS AND WARNINGS 2010-10-27 06:50:00: Backing up DATABASE_NAME (transaction log) to: 2010-10-27 06:50:00: DRIVE_LETTER:\DIRECTORY_NAME\DATABASE_NAME_DATABASE_NAME_20101027_065000.trn.sqb 2010-10-27 06:50:01: BACKUP LOG [DATABASE_NAME] TO VIRTUAL_DEVICE = 'SQLBACKUP_AF2539C6-2BD5-45D8-9C7D-9372B63431E6' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'DATABASE_NAME - DATABASE_NAME - BACKUP MEDIA', DESCRIPTION = N'DATABASE_NAME - DATABASE_NAME - log backup - 2010-10-27 06:50', CHECKSUM 2010-10-27 06:50:02: Thread 0 error: Error 620: Error writing to backup file(s). 2010-10-27 06:50:02: Warning 210: Thread 0 warning: Warning 210: Error writing to backup file: DRIVE_LETTER:\DIRECTORY_NAME\DATABASE_NAME_DATABASE_NAME_20101027_065000.trn.sqb Warning: System error 112 (There is not enough space on the disk) 2010-10-27 06:50:02: Processed ? pages for database 'DATABASE_NAME', file 'DATABASE_NAME_Log' on file 1. BACKUP LOG successfully processed ? pages in ? seconds (13.396 MB/sec). I believe that it is the root cause of the problem, log backup was unable to write the data to the file, but reported (to the SQL Server) that the operation completed successfuly - so that's the reason - my guess - for the broken sequence. 3) The next one (and the rest until I fixed the problem with the free space) also failed, but with different message (this time there is not 'completed successfuly': SQL Backup log file 5.3.0.178 -SQL "BACKUP LOG [DATABASE_NAME] TO DISK = 'DRIVE_LETTER:\DIRECTORY_NAME\DATABASE_NAME_DATABASE_NAME_20101027_070000.trn.sqb' WITH CHECKSUM , COMPRESSION = 3 , STOP_ON_ERROR , DESCRIPTION = 'DATABASE_NAME - DATABASE_NAME - log backup - 2010-10-27 07:00' , INIT , KEYSIZE = 256 , NAME = 'DATABASE_NAME - DATABASE_NAME - BACKUP MEDIA' , PASSWORD = 'XXXXXXXXXXXX' , SINGLERESULTSET , THREADPRIORITY = 3 " ERRORS AND WARNINGS 2010-10-27 07:00:00: Backing up DATABASE_NAME (transaction log) to: 2010-10-27 07:00:00: DRIVE_LETTER:\DIRECTORY_NAME\DATABASE_NAME_DATABASE_NAME_20101027_070000.trn.sqb 2010-10-27 07:00:03: BACKUP LOG [DATABASE_NAME] TO VIRTUAL_DEVICE = 'SQLBACKUP_5C4CF6D9-3466-4E7D-BB7D-12EE64E4AF36' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'DATABASE_NAME - DATABASE_NAME - BACKUP MEDIA', DESCRIPTION = N'DATABASE_NAME - DATABASE_NAME - log backup - 2010-10-27 07:00', CHECKSUM 2010-10-27 07:00:06: Thread 0 error: Error 620: Error writing to backup file(s). Process terminated unexpectedly. Error code: -2139684860 2010-10-27 07:00:06: Warning 210: Thread 0 warning: Warning 210: Error writing to backup file: DRIVE_LETTER:\DIRECTORY_NAME\DATABASE_NAME_DATABASE_NAME_20101027_070000.trn.sqb Warning: System error 112 (There is not enough space on the disk) 2010-10-27 07:00:06: SQL error 3013: SQL error 3013: BACKUP LOG is terminating abnormally. SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_5C4CF6D9-3466-4E7D-BB7D-12EE64E4AF36:" 995(error not found). SQL error 3202: SQL error 3202: Write on "SQLBACKUP_5C4CF6D9-3466-4E7D-BB7D-12EE64E4AF36" failed: 1117(error not found) Thanks for the response / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Problem with log backups
Sure, the related logs below (I removed some sensitive information from them). 1) Last successful: SQL Backup log file 5.3.0.178 -SQL "BACKUP LOG [DATABASE_NAME] TO DISK = 'DRIVE_LETTER:\DIRECTORY_...
0 votes
Problem with log backups
  1. Community
  2. SQL Backup Previous Versions
Hello, I'm using Red Gate SQL Backup to perform many tasks, among them are log backups for some databases. Today I found something rather strange. Log backup failed because there was not enough spa...
2 followers 3 comments 0 votes
Total activity
3
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1