Error 760: LSN data from server is blank.

joshmurrahjoshmurrah Posts: 24
edited December 6, 2005 10:30AM in SQL Backup Previous Versions
Can anyone shed some light on this error? I get these on log backups, sporadically.
-Josh Murrah

Comments

  • peteypetey Posts: 2,358 New member
    Do you happen to run multiple backup jobs at the same time?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • I have gotten the same error a couple of times as well. There is only 1 backup job running at a given time.
  • I also have the same error. There are no other backup jobs running against the database which gives the error, however there are other backup jobs running against other databases.....funny thing is I also get two ERROR emails?????? Again only happens ~once a day for a job which runs every 10 minutes.....was thinking it could be because of an empty log, it nothings changed, but have verified this is NOT the case.....

    Help needed Guys....

    Barn :-)

    FYI,
    First ERROR EMAIL:
    *********************
    11/30/2005 11:50:09 AM: SQL Backup 3.2.0.5, (c) Red Gate Software Ltd 2004 - 2005
    11/30/2005 11:50:09 AM:
    11/30/2005 11:50:09 AM: Backing up MYOB LIVE V370 (transaction log) on NAVISION instance to \\sqlbkpmel01\d$\MSSQL_Backups\SQLMEL01-navision\MYOB LIVE V370\Wednesday\[MYOB LIVE V370][TLOG][2005-11-30 115009].BAK.sqb ...
    11/30/2005 11:50:09 AM:
    11/30/2005 11:50:09 AM: BACKUP LOG [MYOB LIVE V370] TO DISK = '\\sqlbkpmel01\d$\MSSQL_Backups\SQLMEL01-navision\MYOB LIVE V370\Wednesday\[MYOB LIVE V370][TLOG][2005-11-30 115009].BAK.sqb' WITH NAME = '10 Minute Transaction Log Backup - 2005-11-30 11:50:09', DESCRIPTION = '10 Minute Transaction Log Backup - 2005-11-30 11:50:09', PASSWORD = 'XXXXXXXXXX', MAILTO = 'xxxxx@myob.com', COMPRESSION = 1
    11/30/2005 11:50:09 AM:
    11/30/2005 11:50:09 AM:
    11/30/2005 11:50:11 AM: Backup data size : 2.375 MB
    11/30/2005 11:50:11 AM: Compressed data size: 476.000 KB
    11/30/2005 11:50:11 AM: Compression rate : 80.43%
    11/30/2005 11:50:14 AM: Error 750: No LSN data returned from server.
    11/30/2005 11:50:14 AM: Error 760: LSN data from server is blank.
    *********************
    2nd Error Email:
    *********************
    11/30/2005 11:50:09 AM: SQL Backup 3.2.0.5, (c) Red Gate Software Ltd 2004 - 2005
    11/30/2005 11:50:09 AM:
    11/30/2005 11:50:09 AM: Backing up MYOB LIVE V370 (transaction log) on NAVISION instance to \\sqlbkpmel01\d$\MSSQL_Backups\SQLMEL01-navision\MYOB LIVE V370\Wednesday\[MYOB LIVE V370][TLOG][2005-11-30 115009].BAK.sqb ...
    11/30/2005 11:50:09 AM:
    11/30/2005 11:50:09 AM: BACKUP LOG [MYOB LIVE V370] TO DISK = '\\sqlbkpmel01\d$\MSSQL_Backups\SQLMEL01-navision\MYOB LIVE V370\Wednesday\[MYOB LIVE V370][TLOG][2005-11-30 115009].BAK.sqb' WITH NAME = '10 Minute Transaction Log Backup - 2005-11-30 11:50:09', DESCRIPTION = '10 Minute Transaction Log Backup - 2005-11-30 11:50:09', PASSWORD = 'XXXXXXXXXX', MAILTO = 'xxxx@myob.com', COMPRESSION = 1
    11/30/2005 11:50:09 AM:
    11/30/2005 11:50:09 AM:
    11/30/2005 11:50:11 AM: Backup data size : 2.375 MB
    11/30/2005 11:50:11 AM: Compressed data size: 476.000 KB
    11/30/2005 11:50:11 AM: Compression rate : 80.43%
    11/30/2005 11:50:14 AM: Error 750: No LSN data returned from server.
    11/30/2005 11:50:14 AM: Error 760: LSN data from server is blank.
    11/30/2005 11:50:15 AM: Mail sent successfully to: xxxxx@myob.com
    ******************
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello Barnaby,

    We'll send you 3.2.10 and see if that helps.
  • Brian/all,

    I wanted to report that this patch cleared all errors that I had been receiving during the day for highly-loaded servers; I rolled this patch out to the busy servers yesterday, and haven't gotten a single failure since.

    Thanks for the great support!
    -Josh Murrah
Sign In or Register to comment.