Comments
Sort by recent activity
I ended up talking to support a couple of times on this issue. They seemed to be genuinely stumped and I kept getting emails from different techs asking me to do the same thing and hoping for different results. I ended up going with another backup compression vendor. Good luck. / comments
I ended up talking to support a couple of times on this issue. They seemed to be genuinely stumped and I kept getting emails from different techs asking me to do the same thing and hoping for diffe...
Nobody spent any time trying to diagnose any networking issue. The software itself was unable to even attempt to send out the logs due to the queue being "jammed" by itself. Packet captures showed that your software quit attempting to send out data. Nice try though. / comments
Nobody spent any time trying to diagnose any networking issue. The software itself was unable to even attempt to send out the logs due to the queue being "jammed" by itself. Packet captures showed ...
Hi Pete,
Are we out of ideas on this one? / comments
Hi Pete,
Are we out of ideas on this one?
Here are the results.
id name copyto overwrite count diskretryinterval diskretrycount mailto mailto_onerror created lastattempt
420 C:\Backups\LOG_(local)_TestDatabase_20090722_112057.sqb \\myserver\myshare\LOG_(local)_TestDatabase_20090722_112057.sqb 0 0 30 10 2009-07-22 11:20:58.790 NULL / comments
Here are the results.
id name copyto overwrite count diskretryinterval diskretrycount mailto mailto_onerror created lastattempt
420 C:\Backups\LOG_(local)_TestDatabase_20090722_112057.sqb \\myserve...
I have executed the commands as requested and pasted the results below.
EXEC master..sqlbackup '-sql "BACKUP LOG [TestDatabase] TO DISK = [C:\Backups\<AUTO>] WITH COPYTO = [\\myserver\myshare]"'
Backing up TestDatabase (transaction log) to:
C:\Backups\LOG_(local)_TestDatabase_20090722_112057.sqb
Backup data size : 512.000 KB
Compressed data size: 3.500 KB
Compression rate : 99.32%
Processed 0 pages for database 'TestDatabase', file 'TestDatabase_log' on file 1.
BACKUP LOG successfully processed 0 pages in 0.002 seconds (0.000 MB/sec).
SQL Backup process ended.
name value
exitcode 0
sqlerrorcode 0
filename001 C:\Backups\LOG_(local)_TestDatabase_20090722_112057.sqb
EXEC MASTER..sqbdata 'select * from backupfiles_copylist'
id backup_id name copyto overwrite status count retrycount diskretrycount diskretryinterval mailto mailto_onerror created lastattempt lastupdated
420 3082 C:\Backups\LOG_(local)_TestDatabase_20090722_112057.sqb \\myserver\myshare\LOG_(local)_TestDatabase_20090722_112057.sqb 0 P 0 0 10 30 2009-07-22 11:20:58.790 NULL 2009-07-22 15:20:58.000
EXEC master..sqbdata 'SELECT id, name, copyto, overwrite, count, diskretryinterval, diskretrycount, mailto, mailto_onerror, created, lastattempt FROM backupfiles_copylist WHERE status = ''P'' ORDER BY count DESC, created'
id name copyto overwrite count diskretryinterval diskretrycount mailto mailto_onerror created lastattempt
420 C:\Backups\LOG_(local)_TestDatabase_20090722_112057.sqb \\myserver\myshare\LOG_(local)_TestDatabase_20090722_112057.sqb 0 0 30 10 2009-07-22 11:20:58.790 NULL / comments
I have executed the commands as requested and pasted the results below.
EXEC master..sqlbackup '-sql "BACKUP LOG [TestDatabase] TO DISK = [C:\Backups\<AUTO>] WITH COPYTO = [\\myserver\myshare]"'
Ba...
I currently have no results for that query. I turned off the "with copy" feature and dumped the records from the backupfiles_copylist table yesterday.
I tried several times to create a new transaction log w/copy (and both with and without 'verify') and always resulted in the log files being queued but with no attempts to deliver as indicated by the 'Last Attempt to Copy' column. / comments
I currently have no results for that query. I turned off the "with copy" feature and dumped the records from the backupfiles_copylist table yesterday.
I tried several times to create a new transact...
Yes, the name and copyto were correct.
This returned nothing:
EXEC MASTER..sqbdata 'select * from backupfiles_copylist_log'
Any ideas? / comments
Yes, the name and copyto were correct.
This returned nothing:
EXEC MASTER..sqbdata 'select * from backupfiles_copylist_log'
Any ideas?
I seem to be able to reproduce the issue only for 'backup log' commands. I have verified that the SQL command in the agent job has the copyto command in it, however, that value does not seem to show up in the Red Gate logs. The "backup database" commands work fine. / comments
I seem to be able to reproduce the issue only for 'backup log' commands. I have verified that the SQL command in the agent job has the copyto command in it, however, that value does not seem to sho...
Here is a sample log...
7/21/2009 1:30:24 PM: Backing up TestDatabase (transaction log) to:
7/21/2009 1:30:24 PM: X:\Backups\LOG_(local)_TestDatabase_20090721_133024.sqb
7/21/2009 1:30:24 PM: BACKUP LOG [TestDatabase] TO VIRTUAL_DEVICE = 'SQLBACKUP_A905F3BC-11EA-4ED5-A3BC-8910C5F68D3B', VIRTUAL_DEVICE = 'SQLBACKUP_A905F3BC-11EA-4ED5-A3BC-8910C5F68D3B01', VIRTUAL_DEVICE = 'SQLBACKUP_A905F3BC-11EA-4ED5-A3BC-8910C5F68D3B02', VIRTUAL_DEVICE = 'SQLBACKUP_A905F3BC-11EA-4ED5-A3BC-8910C5F68D3B03', VIRTUAL_DEVICE = 'SQLBACKUP_A905F3BC-11EA-4ED5-A3BC-8910C5F68D3B04', VIRTUAL_DEVICE = 'SQLBACKUP_A905F3BC-11EA-4ED5-A3BC-8910C5F68D3B05', VIRTUAL_DEVICE = 'SQLBACKUP_A905F3BC-11EA-4ED5-A3BC-8910C5F68D3B06' WITH BUFFERCOUNT = 28, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (TestDatabase), 7/21/2009 1:30:24 PM', DESCRIPTION = N'Backup on 7/21/2009 1:30:24 PM Server: sqlcluster Database: TestDatabase', FORMAT
7/21/2009 1:30:24 PM: Backup data size : 4.625 MB
7/21/2009 1:30:24 PM: Compressed data size: 38.500 KB
7/21/2009 1:30:24 PM: Compression rate : 99.19%
7/21/2009 1:30:24 PM: Processed 12 pages for database 'TestDatabase', file 'TestDatabase_log' on file 1.
7/21/2009 1:30:24 PM: BACKUP LOG successfully processed 12 pages in 0.152 seconds (0.606 MB/sec).
7/21/2009 1:30:24 PM:
7/21/2009 1:30:24 PM: Verifying files:
7/21/2009 1:30:24 PM: C:\Backups\LOG_(local)_TestDatabase_20090721_133024.sqb
7/21/2009 1:30:24 PM:
7/21/2009 1:30:25 PM: The backup set on file 1 is valid. / comments
Here is a sample log...
7/21/2009 1:30:24 PM: Backing up TestDatabase (transaction log) to:
7/21/2009 1:30:24 PM: X:\Backups\LOG_(local)_TestDatabase_20090721_133024.sqb
7/21/2009 1:30:24 PM: BAC...
I ran that command and all of the records have 'P' for the status column. / comments
I ran that command and all of the records have 'P' for the status column.