Comments
Sort by recent activity
Hi
Sorry for any confusion caused.
Re point 1:
We do not have an entry in the backupmediafamily where physical_device_name = 'SQLBACKUP_DF533258-0618-4D56-AE18-76C69D807A42'. The error message I was refering to was displayed in the SQL Server logs.
Re point 2:
I have provided an extract of the data from the query you provided (amended) where the column values were different between the backups that passed or failed
SELECT a.name, substring(a.user_name,1,8), substring(b.logical_device_name,1,33), b.physical_device_name, b.device_type, b.physical_block_size
FROM msdb..backupset a
INNER JOIN msdb..backupmediafamily b ON a.media_set_id = b.media_set_id
WHERE a.database_name = 'SIT'
AND a.type = 'L'
AND a.backup_start_date >= '26-Nov-2007 14:16'
AND a.backup_finish_date <= '26-Nov-2007 15:40'
Database (SIT), 26/11/2007 14:30:58 DBDIRECT Red Gate SQL Backup (5.2.0.2825): d:\sqlbackup\redgate\LOG_(local)_SIT_20071126_143058.sqb 7 65536
Database (SIT), 26/11/2007 14:46:02 DBDIRECT Red Gate SQL Backup (5.2.0.2825): d:\sqlbackup\redgate\LOG_(local)_SIT_20071126_144602.sqb 7 65536
Database (SIT), 26/11/2007 15:01:16 DBDIRECT Red Gate SQL Backup (5.2.0.2825): d:\sqlbackup\redgate\LOG_(local)_SIT_20071126_150116.sqb 7 65536
Database (SIT), 26/11/2007 15:16:04 sa NULL [image] \SQLBACKUP\GlobalTest\GlobalTest_tlog_200612201110.TRN 2 512
Database (SIT), 26/11/2007 15:31:29 DBDIRECT Red Gate SQL Backup (5.2.0.2825): d:\sqlbackup\redgate\LOG_(local)_SIT_20071126_153129.sqb 7 65536
I have checked the tables below and both queries return a single row.
select * from msdb..backupmediafamily where media_set_id = 255147
select * from msdb..backupset where media_set_id = 255147 / comments
Hi
Sorry for any confusion caused.
Re point 1:
We do not have an entry in the backupmediafamily where physical_device_name = 'SQLBACKUP_DF533258-0618-4D56-AE18-76C69D807A42'. The error message I w...
Hi
My apologies: We did have an error message for the warning log that I included. I didn't realise as the messages were sorted by message so this did not appear in the list where I was looking for it.
BACKUP failed to complete the command BACKUP LOG [eluciddb] TO VIRTUAL_DEVICE = 'SQLBACKUP_DF533258-0618-4D56-AE18-76C69D807A42' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (eluciddb), 03/11/2007 11:30:23', DESCRIPTION = N'Backup on 03/11/2007 11:30:
I have ran the first script that you supplied and can confirm that we have an entry in the backupset table for this and confirmed it matched the pyhsical_device_name in the SQL Server log.
I ran the second script which also returned one record but the entry in the pyhsical_device_name field actually referred to the location of the old backup files (before we started using red-gate). The values in the name and description fields refer to the current backup.
We have only had two backups failed due to 760 errors and on both occassions the pages processed was 0 / comments
Hi
My apologies: We did have an error message for the warning log that I included. I didn't realise as the messages were sorted by message so this did not appear in the list where I was looking f...
Hi,
thanks for your prompt response.
I ran the query you supplied. It returned 8 rows for two different databases with dates ranging from 03 Nov 2007 to 24 Nov 2007. These rows related to warning messages that we had received when the the transaction log backup seemed to fail first time but ran OK on a re-try.
All of the rows returned with this query have a value in the first_lsn column.
None of the databases where we have received an error report (Error 760: LSN data from server is blank) appear in the results from running this query. / comments
Hi,
thanks for your prompt response.
I ran the query you supplied. It returned 8 rows for two different databases with dates ranging from 03 Nov 2007 to 24 Nov 2007. These rows related to warning...