Transaction Log Backup Fails
UrsusHorribilis
Posts: 22
I am getting the below error when backing up transaction logs of any DB on the server. For the example below a full backup was performed & verified 10 mins before the log backup failed.
exec master..sqlbackup '-SQL "BACKUP LOG [BlockMonitor] TO DISK = ''R:\sqlrec\TLogBU\BAT$SQLPROD4\BlockMonitor\BlockMonitor_tlog_200709230833.sqb'' WITH NAME = ''Database (BlockMonitor)'', DESCRIPTION = ''<AUTO>'', ERASEFILES_ATSTART = 3, LOGTO = ''U:\Microsoft SQL Server\MSSQL.3\MSSQL\LOG\BAT$SQLPROD4_BlockMonitor_RedGate_Log.txt'', COMPRESSION = 1" -E'
Backing up BlockMonitor (transaction log) on SQLPROD4 instance to:
R:\sqlrec\TLogBU\BAT$SQLPROD4\BlockMonitor\BlockMonitor_tlog_200709230833.sqb
VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had
elapsed.)
SQL error 3013: BACKUP LOG is terminating abnormally.
SQL error 4214: BACKUP LOG cannot be performed because there is no current database backup.
Memory profile
Type Maximum Minimum Average Blk count Total
Commit 7667802112 4096 2470909 6521 16112799744
Reserve 1895759872 4096 2551242 3330 8495636480
Free 6856078852096 4096 34533403623 254 8771484520448
Private 7667802112 4096 2751157 8882 24435777536
Mapped 1585152 4096 123295 69 8507392
Image 32071680 4096 182390 900 164151296
Warning 300: Backup failed. Retry attempt: 1
VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had
elapsed.)
SQL error 3013: BACKUP LOG is terminating abnormally.
SQL error 4214: BACKUP LOG cannot be performed because there is no current database backup.
Memory profile
Type Maximum Minimum Average Blk count Total
Commit 7667802112 4096 2470909 6521 16112799744
Reserve 1895759872 4096 2551242 3330 8495636480
Free 6856078852096 4096 34533403623 254 8771484520448
Private 7667802112 4096 2751157 8882 24435777536
Mapped 1585152 4096 123295 69 8507392
Image 32071680 4096 182390 900 164151296
Warning 300: Backup failed. Retry attempt: 2
VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had
elapsed.)
SQL error 3013: BACKUP LOG is terminating abnormally.
SQL error 4214: BACKUP LOG cannot be performed because there is no current database backup.
Memory profile
Type Maximum Minimum Average Blk count Total
Commit 7667802112 4096 2470909 6521 16112799744
Reserve 1895759872 4096 2551242 3330 8495636480
Free 6856078852096 4096 34533403623 254 8771484520448
Private 7667802112 4096 2751157 8882 24435777536
Mapped 1585152 4096 123295 69 8507392
Image 32071680 4096 182390 900 164151296
Warning 300: Backup failed. Retry attempt: 3
VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had
elapsed.)
SQL error 3013: BACKUP LOG is terminating abnormally.
SQL error 4214: BACKUP LOG cannot be performed because there is no current database backup.
Memory profile
Type Maximum Minimum Average Blk count Total
Commit 7667802112 4096 2474058 6511 16108597248
Reserve 1895759872 4096 2552772 3328 8495628288
Free 6856078852096 4096 34669915933 253 8771488731136
Private 7667802112 4096 2754404 8870 24431566848
Mapped 1585152 4096 123295 69 8507392
Image 32071680 4096 182390 900 164151296
Warning 300: Backup failed. Retry attempt: 4
VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had
elapsed.)
SQL error 3013: BACKUP LOG is terminating abnormally.
SQL error 4214: BACKUP LOG cannot be performed because there is no current database backup.
Memory profile
Type Maximum Minimum Average Blk count Total
Commit 7667802112 4096 2474058 6511 16108597248
Reserve 1895759872 4096 2552772 3328 8495628288
Free 6856078852096 4096 34669915933 253 8771488731136
Private 7667802112 4096 2754404 8870 24431566848
Mapped 1585152 4096 123295 69 8507392
Image 32071680 4096 182390 900 164151296
SQL Backup exit code: 1010
SQL error code: 4214
exec master..sqlbackup '-SQL "BACKUP LOG [BlockMonitor] TO DISK = ''R:\sqlrec\TLogBU\BAT$SQLPROD4\BlockMonitor\BlockMonitor_tlog_200709230833.sqb'' WITH NAME = ''Database (BlockMonitor)'', DESCRIPTION = ''<AUTO>'', ERASEFILES_ATSTART = 3, LOGTO = ''U:\Microsoft SQL Server\MSSQL.3\MSSQL\LOG\BAT$SQLPROD4_BlockMonitor_RedGate_Log.txt'', COMPRESSION = 1" -E'
Backing up BlockMonitor (transaction log) on SQLPROD4 instance to:
R:\sqlrec\TLogBU\BAT$SQLPROD4\BlockMonitor\BlockMonitor_tlog_200709230833.sqb
VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had
elapsed.)
SQL error 3013: BACKUP LOG is terminating abnormally.
SQL error 4214: BACKUP LOG cannot be performed because there is no current database backup.
Memory profile
Type Maximum Minimum Average Blk count Total
Commit 7667802112 4096 2470909 6521 16112799744
Reserve 1895759872 4096 2551242 3330 8495636480
Free 6856078852096 4096 34533403623 254 8771484520448
Private 7667802112 4096 2751157 8882 24435777536
Mapped 1585152 4096 123295 69 8507392
Image 32071680 4096 182390 900 164151296
Warning 300: Backup failed. Retry attempt: 1
VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had
elapsed.)
SQL error 3013: BACKUP LOG is terminating abnormally.
SQL error 4214: BACKUP LOG cannot be performed because there is no current database backup.
Memory profile
Type Maximum Minimum Average Blk count Total
Commit 7667802112 4096 2470909 6521 16112799744
Reserve 1895759872 4096 2551242 3330 8495636480
Free 6856078852096 4096 34533403623 254 8771484520448
Private 7667802112 4096 2751157 8882 24435777536
Mapped 1585152 4096 123295 69 8507392
Image 32071680 4096 182390 900 164151296
Warning 300: Backup failed. Retry attempt: 2
VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had
elapsed.)
SQL error 3013: BACKUP LOG is terminating abnormally.
SQL error 4214: BACKUP LOG cannot be performed because there is no current database backup.
Memory profile
Type Maximum Minimum Average Blk count Total
Commit 7667802112 4096 2470909 6521 16112799744
Reserve 1895759872 4096 2551242 3330 8495636480
Free 6856078852096 4096 34533403623 254 8771484520448
Private 7667802112 4096 2751157 8882 24435777536
Mapped 1585152 4096 123295 69 8507392
Image 32071680 4096 182390 900 164151296
Warning 300: Backup failed. Retry attempt: 3
VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had
elapsed.)
SQL error 3013: BACKUP LOG is terminating abnormally.
SQL error 4214: BACKUP LOG cannot be performed because there is no current database backup.
Memory profile
Type Maximum Minimum Average Blk count Total
Commit 7667802112 4096 2474058 6511 16108597248
Reserve 1895759872 4096 2552772 3328 8495628288
Free 6856078852096 4096 34669915933 253 8771488731136
Private 7667802112 4096 2754404 8870 24431566848
Mapped 1585152 4096 123295 69 8507392
Image 32071680 4096 182390 900 164151296
Warning 300: Backup failed. Retry attempt: 4
VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had
elapsed.)
SQL error 3013: BACKUP LOG is terminating abnormally.
SQL error 4214: BACKUP LOG cannot be performed because there is no current database backup.
Memory profile
Type Maximum Minimum Average Blk count Total
Commit 7667802112 4096 2474058 6511 16108597248
Reserve 1895759872 4096 2552772 3328 8495628288
Free 6856078852096 4096 34669915933 253 8771488731136
Private 7667802112 4096 2754404 8870 24431566848
Mapped 1585152 4096 123295 69 8507392
Image 32071680 4096 182390 900 164151296
SQL Backup exit code: 1010
SQL error code: 4214
Comments
The following thread should help in explaining why SQL Server is raising this error: http://www.red-gate.com/MessageBoard/vi ... php?t=5615
Hope that helps,
Jason