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

Comments

Sort by recent activity
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
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, 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, 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, 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
Total activity
11
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2