What are the challenges you face when working across database platforms? Take the survey
Options

Transaction Log Backup Fails

UrsusHorribilisUrsusHorribilis Posts: 22
edited September 24, 2007 1:52PM in SQL Backup Previous Versions
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

Comments

Sign In or Register to comment.