How can we help you today? How can we help you today?
rbvdberg
Activity overview Badges (0) Posts (4) Comments (5)

Activity overview

Latest activity by rbvdberg

Hello Peter, I mean the SQLBackup log files, not the transaction log files / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup log files are not deleted
Hello Peter, I mean the SQLBackup log files, not the transaction log files
0 votes
SQL Backup log files are not deleted
  1. Community
  2. SQL Backup Previous Versions
We use Redgate SQLBackup 6.4.0.56 on Windows 2003 clusters with SQL 2005 SP 3, both 64 bit. After the upgrade from version 4.6, the SQLBackup log files are no longer deleted following the backup. W...
2 followers 3 comments 0 votes
Hello Peter, I have no idea why we have two backups. I only see one job in the job history, and our custom code does sometimes decide to run another backup (after specific error codes), but always after a 10 second delay (WAITFOR DELAY '000:00:10'). / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Double backup
Hello Peter, I have no idea why we have two backups. I only see one job in the job history, and our custom code does sometimes decide to run another backup (after specific error codes), but always ...
0 votes
Hello Peter, Yes. We use some custom code to call SQLBackup, but yes, we do this from a SQL Server agent job. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Double backup
Hello Peter, Yes. We use some custom code to call SQLBackup, but yes, we do this from a SQL Server agent job.
0 votes
Hello Peter, This is the contents of log 1: SQL Backup log file 6.4.0.56 -SQL "BACKUP LOGS [dbsExodus] TO DISK = '\\hwnafvab1\sqllog03\DBS-VR1274\ROME_ACC\dbsExodus\<AUTO>' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', PASSWORD = 'XXXXXXXXXX', KEYSIZE = 256, ERASEFILES = 2, COMPRESSION = 1, THREADS = 1 " ERRORS AND WARNINGS 8/22/2010 5:12:38 AM: Backing up dbsExodus (transaction log) on ROME_ACC instance to: 8/22/2010 5:12:38 AM: \\hwnafvab1\sqllog03\DBS-VR1274\ROME_ACC\dbsExodus\LOG_ROME_ACC_dbsExodus_20100822_051238.sqb 8/22/2010 5:12:38 AM: Warning 462: Short passwords may not be secure. 8/22/2010 5:12:38 AM: BACKUP LOG [dbsExodus] TO VIRTUAL_DEVICE = 'SQLBACKUP_8D78215C-B741-4123-BF5E-3B54B25DC0F7' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (dbsExodus), 8/22/2010 5:12:38 AM', DESCRIPTION = N'Backup on 8/22/2010 5:12:38 AM Server: DBS-VR1274\ROME_ACC Database: dbsExodus', FORMAT 8/22/2010 5:12:38 AM: Backup data size : 640.000 KB 8/22/2010 5:12:38 AM: Compressed data size: 4.000 KB 8/22/2010 5:12:38 AM: Compression rate : 99.38% 8/22/2010 5:12:38 AM: Processed 1 pages for database 'dbsExodus', file 'dbsExodus_Log_1' on file 1. 8/22/2010 5:12:38 AM: BACKUP LOG successfully processed 1 pages in 0.022 seconds (0.162 MB/sec). And this is the contents of the second log file: SQL Backup log file 6.4.0.56 -SQL "BACKUP LOGS [dbsExodus] TO DISK = '\\hwnafvab1\sqllog03\DBS-VR1274\ROME_ACC\dbsExodus\<AUTO>' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', PASSWORD = 'XXXXXXXXXX', KEYSIZE = 256, ERASEFILES = 2, COMPRESSION = 1, THREADS = 1 " ERRORS AND WARNINGS 8/22/2010 5:12:38 AM: Backing up dbsExodus (transaction log) on ROME_ACC instance to: 8/22/2010 5:12:38 AM: \\hwnafvab1\sqllog03\DBS-VR1274\ROME_ACC\dbsExodus\LOG_ROME_ACC_dbsExodus_20100822_051238.sqb 8/22/2010 5:12:38 AM: Warning 462: Short passwords may not be secure. 8/22/2010 5:12:38 AM: BACKUP LOG [dbsExodus] TO VIRTUAL_DEVICE = 'SQLBACKUP_B850A1C3-10D1-4749-9AD7-D5B822754F07' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (dbsExodus), 8/22/2010 5:12:38 AM', DESCRIPTION = N'Backup on 8/22/2010 5:12:38 AM Server: DBS-VR1274\ROME_ACC Database: dbsExodus', FORMAT 8/22/2010 5:12:38 AM: Backup data size : 512.000 KB 8/22/2010 5:12:38 AM: Compressed data size: 4.000 KB 8/22/2010 5:12:38 AM: Compression rate : 99.22% 8/22/2010 5:12:38 AM: Processed 0 pages for database 'dbsExodus', file 'dbsExodus_Log_1' on file 1. 8/22/2010 5:12:38 AM: BACKUP LOG successfully processed 0 pages in 0.002 seconds (0.000 MB/sec). And yes, we'll be fixing the password strength sometime in the future... / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Double backup
Hello Peter, This is the contents of log 1: SQL Backup log file 6.4.0.56 -SQL "BACKUP LOGS [dbsExodus] TO DISK = '\\hwnafvab1\sqllog03\DBS-VR1274\ROME_ACC\dbsExodus\<AUTO>' WITH NAME = '<AUTO>', DE...
0 votes
Hello Peter, Here are the relevant rows: 2010-08-22 03:12:39.000 \\hwnafvab1\sqllog03\DBS-VR1274\ROME_ACC\dbsExodus\LOG_ROME_ACC_dbsExodus_20100822_031238.sqb 7 305000009615400001 305000009615400001 2010-08-22 05:12:38.000 \\hwnafvab1\sqllog03\DBS-VR1274\ROME_ACC\dbsExodus\LOG_ROME_ACC_dbsExodus_20100822_051238.sqb 7 305000009615400001 305000009616100001 2010-08-22 05:12:38.000 \\hwnafvab1\sqllog03\DBS-VR1274\ROME_ACC\dbsExodus\LOG_ROME_ACC_dbsExodus_20100822_051238.sqb 7 305000009616100001 305000009616100001 2010-08-22 07:12:38.000 \\hwnafvab1\sqllog03\DBS-VR1274\ROME_ACC\dbsExodus\LOG_ROME_ACC_dbsExodus_20100822_071238.sqb 7 305000009616100001 305000009616100001 / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Double backup
Hello Peter, Here are the relevant rows: 2010-08-22 03:12:39.000 \\hwnafvab1\sqllog03\DBS-VR1274\ROME_ACC\dbsExodus\LOG_ROME_ACC_dbsExodus_20100822_031238.sqb 7 305000009615400001 30500000961540000...
0 votes
Double backup
  1. Community
  2. SQL Backup Previous Versions
This morning I found that SQLBackup made 2 consecutive transaction log backups, though SQL Server only ran 1 backup job. Since both backups were started in the same second and we use the auto name ...
2 followers 8 comments 0 votes
differentials
  1. Community
  2. SQL Backup Previous Versions
Is it possible to merge a differential backup into a full backup using SQLBackup? The reason I ask is that we have to keep 7 days of backups on disk. Using differentials, this means 1 full and 6 di...
1 follower 1 comment 0 votes
Restore problem
  1. Community
  2. SQL Backup Previous Versions
Hi, Yesterday I tried to restore a large database (8 files of 8 GB). The backup took 1,5 hours, but the restore wasn't finished after 20 hours, so I stopped the restore. When I try to do a restore ...
1 follower 1 comment 0 votes
Total activity
11
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2