How can we help you today? How can we help you today?
bsantosh6

Activity overview

Latest activity by bsantosh6

Some Progress! I ran the the script you provided and it retuned the result : backup_start_date ,backup_finish_date ,logical_device_name ,physical_device_name 2012-04-24 02:18:09.000 ,2012-04-24 02:18:11.000 ,NULL, R:\ShippedLog\3184\PB_0605_3184_tlog_201011301900.TRN This is pointing to a wrong physical_device_name! Some more research and querying and I see that when the job runs as 'sa' it has no issues.But when it runs as the "service account that SQLBACKUP service runs under" ..it fails...! I went back almost 3 months in backup history and saw this pattern. I used this query to confirm the pattern: SELECT user_name,database_name,server_name,logical_device_name,physical_device_name,device_type FROM msdb..backupset a INNER JOIN msdb..backupmediafamily b ON a.media_set_id = b.media_set_id WHERE user_name like '%SVC%' AND a.type = 'D' AND a.backup_start_date >= '01-Jan-2012 01:00' AND a.backup_finish_date <= '25-Apr-2012 04:00' ORDER BY a.backup_start_date --results show all my failures and in all these rows the physical_device_name is wrong....redgate log confirm these exact failures where the 760 error was thrown... On Running this: SELECT user_name,database_name,server_name,logical_device_name,physical_device_name,device_type FROM msdb..backupset a INNER JOIN msdb..backupmediafamily b ON a.media_set_id = b.media_set_id WHERE user_name like 'sa' AND a.type = 'D' AND a.backup_start_date >= '01-Jan-2012 01:00' AND a.backup_finish_date <= '25-Apr-2012 04:00' ORDER BY a.backup_start_date --all good backups and correct physical_Device_name! / comments
Some Progress! I ran the the script you provided and it retuned the result : backup_start_date ,backup_finish_date ,logical_device_name ,physical_device_name 2012-04-24 02:18:09.000 ,2012-04-2...
0 votes
Per your suggetion,I did the TraceOn. I ve pasted below the data i see in the sql logs and red gate logs during the event of a failure: Redgate logs: ERRORS AND WARNINGS 4/24/2012 2:18:09 AM: Backing up PB_0605_3438 (full database) to: 4/24/2012 2:18:09 AM: R:\MSSQL\Backups\FULL_BKUP\PB_0605_3438\FULL_(local)_PB_0605_3438_20120424_021809.sqb 4/24/2012 2:18:09 AM: Deleting old backup file: R:\MSSQL\Backups\FULL_BKUP\PB_0605_3438\FULL_(local)_PB_0605_3438_20120423_021437.sqb 4/24/2012 2:18:09 AM: BACKUP DATABASE [PB_0605_3438] TO VIRTUAL_DEVICE = 'SQLBACKUP_CDDEB33A-EFC3-48B1-AE33-17F97F044EEC' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (PB_0605_3438), 4/24/2012 2:18:09 AM', DESCRIPTION = N'Backup on 4/24/2012 2:18:09 AM Server: CLTEBIZBPSQLCL Database: PB_0605_3438' 4/24/2012 2:18:12 AM: Database size : 375.313 MB 4/24/2012 2:18:12 AM: Compressed data size: 45.069 MB 4/24/2012 2:18:12 AM: Compression rate : 87.99% Processed 22240 pages for database 'PB_0605_3438', file 'PB_0605_0001' on file 1. Processed 1 pages for database 'PB_0605_3438', file 'PB_0605_0001_log' on file 1. BACKUP DATABASE successfully processed 22241 pages in 2.359 seconds (77.232 MB/sec). 4/24/2012 2:18:21 AM: Error 742: Failed to get LSN data from server (0 rows returned). () 4/24/2012 2:18:21 AM: Error 760: LSN data from server is blank. SQL Logs ( with traceON) : 2012-04-24 02:18:09.22 spid4240 BackupDatabase: Database PB_0605_3438 2012-04-24 02:18:09.22 spid4240 BackupDatabase: Streams open 2012-04-24 02:18:09.47 spid4240 BackupDatabase: Checkpoint done 2012-04-24 02:18:09.47 spid4240 BackupDatabase: Work estimates done 2012-04-24 02:18:09.47 spid4240 BackupDatabase: Configuration section done 2012-04-24 02:18:11.83 spid4240 BackupDatabase: Database files done 2012-04-24 02:18:11.83 spid4240 BackupDatabase: Log files done 2012-04-24 02:18:11.83 spid4240 BackupDatabase: Final configuration done 2012-04-24 02:18:11.83 spid4240 BackupDatabase: MBC done 2012-04-24 02:18:11.86 spid4240 BackupDatabase: Writing history records 2012-04-24 02:18:11.86 backup Database backed up: Database: PB_0605_3438, creation date(time): 2008/08/07(01:48:33), pages dumped: 22336, first LSN: 52900:52:1, last LSN: 52900:54:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_CDDEB33A-EFC3-48B1-AE33-17F97F044EEC'}). 2012-04-24 02:18:11.89 spid4240 BackupDatabase: Finished / comments
Per your suggetion,I did the TraceOn. I ve pasted below the data i see in the sql logs and red gate logs during the event of a failure:Redgate logs: ERRORS AND WARNINGS 4/24/2012 2:18:09 AM: Back...
0 votes
1) Nope.No errors in the SQL log around that time.If fact I see this msg.... Database backed up: Database: xxxxxx, creation date(time): 2008/08/19(18:20:21), pages dumped: 1904, first LSN: 36692:212:1, last LSN: 36692:214:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_E14F32C7-1F7E-4618-8F80-63F9A8EBCB05'}). ....which negates the 760 error(which indicated log info could not be retrieved). 2) This is what i see in the redgate logs: ERRORS AND WARNINGS 4/18/2012 2:44:10 AM: Backing up xxxxxxxx (full database) to: 4/18/2012 2:44:10 AM: R:\yyyyyyyyy\xxxxxxxxx_20120418_024410.sqb 4/18/2012 2:44:10 AM: Deleting old backup file: R:\yyyyyyyy\xxxxxxxxx_20120417_023755.sqb 4/18/2012 2:44:10 AM: BACKUP DATABASE [xxxxxxx] TO VIRTUAL_DEVICE = 'SQLBACKUP_E14F32C7-1F7E-4618-8F80-63F9A8EBCB05' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (xxxxxxxxx), 4/18/2012 2:44:10 AM', DESCRIPTION = N'Backup on 4/18/2012 2:44:10 AM Server: xxxxxxxx Database: xxxxxxxxx' 4/18/2012 2:44:11 AM: Database size : 267.563 MB 4/18/2012 2:44:11 AM: Compressed data size: 2.816 MB 4/18/2012 2:44:11 AM: Compression rate : 98.95% Processed 1816 pages for database 'xxxxxxx', file 'PB_0605_0001' on file 1. Processed 1 pages for database 'xxxxxxxx', file 'PB_0605_0001_log' on file 1. BACKUP DATABASE successfully processed 1817 pages in 0.134 seconds (111.027 MB/sec). 4/18/2012 2:44:20 AM: Error 742: Failed to get LSN data from server (0 rows returned). () 4/18/2012 2:44:20 AM: Error 760: LSN data from server is blank. 3) I dunno if this help but: -EXECUTE master..sqlbackup N' -SQL " RESTORE HeaderONLY....... Works perfectly.Returns all LSN info for the db on which the failure occurred. - EXECUTE master..sqlbackup N' -SQL " RESTORE SQBHeaderONLY....... Returns all LSN as empty for the db on which the failure occurred. / comments
1) Nope.No errors in the SQL log around that time.If fact I see this msg.... Database backed up: Database: xxxxxx, creation date(time): 2008/08/19(18:20:21), pages dumped: 1904, first LSN: 36692:21...
0 votes
SQL Backup failed with exit code: 760
Hello, --my backup files look ok (based on date modified and based on the jobs step output file ) --SQL BAckup however thows error 760 causing the job to reflect failed state.IN the step output fi...
2 followers 17 comments 0 votes