What are the challenges you face when working across database platforms? Take the survey
Options

SQL error 3201: Cannot open backup device 'SQLBACKUP_D71F944

paulnxwebpaulnxweb Posts: 21
edited October 9, 2007 2:07PM in SQL Backup Previous Versions
We got the error below for the first time in two years during transaction log backup. We use the command line version of SQL Backup. The only difference is that we have upgraded to SQL Server 2005 in past two weeks.

We also we also ship the transaction logs to a remote server. We restarted operation by first doing a full backup via redgate sqlbackup and then continued shipping just the log to the remote server for restoration.
The remote standby server is out of sync (see #1)

Can you shed some light as to what may have gone "wrong"
thanks

1)***remote server (standy server receiving transactions logs *
SQL Backup log file
10/4/2007 11:46:00 AM: Red Gate SQL Backup 4.5.0.704, (c) Red Gate Software Ltd 2004 - 2006
10/4/2007 11:46:00 AM:
10/4/2007 11:46:00 AM: Processing log group 0 ...
10/4/2007 11:46:00 AM: D:\RedGateData\Incoming\LOG__Assesspoint_200710041540.sqb
10/4/2007 11:46:00 AM: Restoring Assesspoint (transaction logs) on MSSQL2K5STD instance from:
D:\RedGateData\Incoming\LOG__Assesspoint_200710041540.sqb

10/4/2007 11:46:00 AM: RESTORE LOG [Assesspoint] FROM DISK = 'D:\RedGateData\Incoming\LOG__Assesspoint_200710041540.sqb' WITH STANDBY = 'D:\Microsoft SQL Server Data\MSSQL2005\Data\mycompany\UNDO_assesspoint.dat', MAILTO_ONERROR = 'mycompanyerrors@gmail.com', PASSWORD = 'XXXXXXXXXX', MOVETO = 'D:\RedGateData\Processed'


10/4/2007 11:46:01 AM: Server: Msg 3013
RESTORE LOG is terminating abnormally.
10/4/2007 11:46:01 AM: Server: Msg 4305
The log in this backup set begins at LSN 65987000002150400001, which is too recent to apply to the database. An earlier log backup that includes LSN 65987000001959800001 can be restored.




1)***remote server restore error * Local server (production)
10/3/2007 9:15:01 PM: Red Gate SQL Backup 4.5.0.704, (c) Red Gate Software Ltd 2004 - 2006
10/3/2007 9:15:01 PM:
10/3/2007 9:15:01 PM: Backing up Assesspoint (transaction log) to:
c:\RedGateData\BackupDump\LOG__Assesspoint_200710040115.sqb

10/3/2007 9:15:01 PM: BACKUP LOG [Assesspoint] TO DISK = 'c:\RedGateData\BackupDump\LOG__Assesspoint_200710040115.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', PASSWORD = 'XXXXXXXXXX', KEYSIZE = 128, MAILTO_ONERROR = 'mycompanyerrors@gmail.com', COMPRESSION = 3

10/3/2007 9:15:17 PM: VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had elapsed.)
10/3/2007 9:15:19 PM: SQL error 3013: BACKUP LOG is terminating abnormally.
10/3/2007 9:15:19 PM: SQL error 3201: Cannot open backup device 'SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F'. Operating system error 0x80070002(The system cannot find the file specified.).
10/3/2007 9:15:19 PM:
10/3/2007 9:15:20 PM: Memory profile
10/3/2007 9:15:20 PM: Type Maximum Minimum Average Blk count Total
10/3/2007 9:15:20 PM:





10/3/2007 9:15:20 PM: Commit 796983296 4096 2039938 882 1799225344
10/3/2007 9:15:20 PM: Reserve 1040384 4096 138020 112 15458304
10/3/2007 9:15:20 PM: Free 161189888 4096 2066673 161 332734464
10/3/2007 9:15:20 PM: Private 796983296 4096 3169177 549 1739878400
10/3/2007 9:15:20 PM: Mapped 1060864 4096 118474 53 6279168
10/3/2007 9:15:20 PM: Image 24870912 4096 174811 392 68526080
10/3/2007 9:15:20 PM:
10/3/2007 9:15:20 PM:
10/3/2007 9:15:20 PM: Warning 300: Backup failed. Retry attempt: 1
10/3/2007 9:15:22 PM: BACKUP LOG [Assesspoint] TO DISK = 'c:\RedGateData\BackupDump\LOG__Assesspoint_200710040115.sqb' WITH NAME = 'Database (Assesspoint), 10/3/2007 9:15:01 PM', DESCRIPTION = 'Backup on 10/3/2007 9:15:01 PM Server: mycompany1 Database: Assesspoint', INIT, PASSWORD = 'XXXXXXXXXX', KEYSIZE = 128, MAILTO_ONERROR = 'mycompanyerrors@gmail.com', COMPRESSION = 3

10/3/2007 9:15:22 PM: Backup data size : 1.750 MB
10/3/2007 9:15:22 PM: Compressed data size: 280.500 KB
10/3/2007 9:15:22 PM: Compression rate : 84.35%

Processed 120 pages for database 'Assesspoint', file 'assesspoint_Log' on file 1.
BACKUP LOG successfully processed 120 pages in 0.079 seconds (12.352 MB/sec). :D:D:D

Comments

  • Options
    Our log dump from our production server


    10/04/2007 12:00:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65992:5681:1<c/> last LSN: 65992:7486:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_2139343F-FE4C-4417-9B26-FE9443E4DBCB'}). This is an informational message only. No user action is required.,,,,
    10/04/2007 12:00:01,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65992:5681:1<c/> last LSN: 65992:7486:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_2139343F-FE4C-4417-9B26-FE9443E4DBCB'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1
    10/04/2007 11:55:02,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65992:3426:1<c/> last LSN: 65992:5681:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_B86EF28A-AE03-4B1F-8C83-34CEA815DC0A'}). This is an informational message only. No user action is required.,,,,
    10/04/2007 11:55:02,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65992:3426:1<c/> last LSN: 65992:5681:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_B86EF28A-AE03-4B1F-8C83-34CEA815DC0A'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1
    10/04/2007 11:50:03,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65992:882:1<c/> last LSN: 65992:3426:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_1915F6F2-6364-4476-ABF6-64409245781E'}). This is an informational message only. No user action is required.,,,,
    10/04/2007 11:50:03,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65992:882:1<c/> last LSN: 65992:3426:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_1915F6F2-6364-4476-ABF6-64409245781E'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1
    10/04/2007 11:45:10,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65991:29785:1<c/> last LSN: 65992:882:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_E27EB28E-8DFE-4A64-A524-A012CDC705B9'}). This is an informational message only. No user action is required.,,,,
    10/04/2007 11:45:10,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65991:29785:1<c/> last LSN: 65992:882:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_E27EB28E-8DFE-4A64-A524-A012CDC705B9'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1
    10/04/2007 11:44:07,spid65,Unknown,Using 'xplog70.dll' version '2005.90.3042' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.,,,,
    10/04/2007 11:44:07,MSSQLSERVER,Information,Using 'xplog70.dll' version '2005.90.3042' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.,Server,1073749952,mycompany1\narn,mycompany1
    10/04/2007 11:40:05,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:21504:1<c/> last LSN: 65991:29785:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_086FB579-87EF-4E48-AF8C-70F62AED9AB3'}). This is an informational message only. No user action is required.,,,,
    10/04/2007 11:40:05,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:21504:1<c/> last LSN: 65991:29785:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_086FB579-87EF-4E48-AF8C-70F62AED9AB3'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1
    10/04/2007 11:39:31,Backup,Unknown,Database backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> pages dumped: 1889744<c/> first LSN: 65991:22952:269<c/> last LSN: 65991:29634:1<c/> number of dump devices: 8<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB01'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB02'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB03'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB04'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB05'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB06'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB07'}). This is an informational message only. No user action is required.,,,,
    10/04/2007 11:39:31,MSSQLSERVER,Information,Database backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> pages dumped: 1889744<c/> first LSN: 65991:22952:269<c/> last LSN: 65991:29634:1<c/> number of dump devices: 8<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB01'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB02'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB03'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB04'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB05'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB06'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB07'}). This is an informational message only. No user action is required.,Backup,1073760088,mycompany1\redgate,mycompany1
    10/04/2007 11:39:29,spid67,Unknown,Changing the status to RESUME for full-text catalog "candidates" (7) in database "Assesspoint" (8). This is an informational message only. No user action is required.,,,,
    10/04/2007 11:20:02,spid67,Unknown,Changing the status to PAUSE for full-text catalog "candidates" (7) in database "Assesspoint" (8). This is an informational message only. No user action is required.,,,,
    10/04/2007 00:00:44,spid18s,Unknown,This instance of SQL Server has been using a process ID of 1084 since 9/29/2007 3:53:06 PM (local) 9/29/2007 7:53:06 PM (UTC). This is an informational message only; no user action is required.,,,,
    10/04/2007 00:00:44,MSSQLSERVER,Information,This instance of SQL Server has been using a process ID of 1084 since 9/29/2007 3:53:06 PM (local) 9/29/2007 7:53:06 PM (UTC). This is an informational message only; no user action is required.,Server,1073759001,,mycompany1
    10/03/2007 21:23:15,SceCli,Information,Security policy in the Group policy objects has been applied successfully.,(0),1073743528,,mycompany1
    10/03/2007 21:15:22,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:19598:1<c/> last LSN: 65987:21504:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_778DE3DE-2721-46DB-A04F-FB340D179219'}). This is an informational message only. No user action is required.,,,,
    10/03/2007 21:15:22,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:19598:1<c/> last LSN: 65987:21504:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_778DE3DE-2721-46DB-A04F-FB340D179219'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1
    10/03/2007 21:15:19,spid62,Unknown,Using 'xp_sqlbackup.dll' version '0004.05.00' to execute extended stored procedure 'sqbmemory'. This is an informational message only; no user action is required.,,,,
    10/03/2007 21:15:19,Backup,Unknown,BACKUP failed to complete the command BACKUP LOG Assesspoint. Check the backup application log for detailed messages.,,,,
    10/03/2007 21:15:19,Backup,Unknown,Error: 3041<c/> Severity: 16<c/> State: 1.,,,,
    10/03/2007 21:15:19,Backup,Unknown,Cannot open backup device 'SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F'. Operating system error 0x80070002(The system cannot find the file specified.).,,,,
    10/03/2007 21:15:19,Backup,Unknown,Error: 3201<c/> Severity: 16<c/> State: 7.,,,,
    10/03/2007 21:15:19,MSSQLSERVER,Information,Using 'xp_sqlbackup.dll' version '0004.05.00' to execute extended stored procedure 'sqbmemory'. This is an informational message only; no user action is required.,Server,1073749952,mycompany1\redgate,mycompany1
    10/03/2007 21:15:19,MSSQLSERVER,Error,BACKUP failed to complete the command BACKUP LOG Assesspoint. Check the backup application log for detailed messages.,Backup,3221228513,mycompany1\redgate,mycompany1
    10/03/2007 21:15:19,MSSQLSERVER,Error,Cannot open backup device 'SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F'. Operating system error 0x80070002(The system cannot find the file specified.).,Backup,3221228673,mycompany1\redgate,mycompany1
    10/03/2007 21:15:19,SQLVDI,Error,SQLVDI: Loc=SVDS::Open. Desc=Open(Control). ErrorCode=(2)The system cannot find the file specified.<nl/>. Process=1084. Thread=212. Server. Instance=MSSQLSERVER. VD=Global\SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F_SQLVDIMemoryName_0.,(0),1,,mycompany1
    10/03/2007 21:15:17,SQLVDI,Error,SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=3740. Thread=3152. Client. Instance=. VD=Global\SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F_SQLVDIMemoryName_0.,(0),1,,mycompany1
    10/03/2007 21:15:17,SQLVDI,Error,SQLVDI: Loc=CVDS::Close. Desc=Abnormal termination state. ErrorCode=(0). Process=3740. Thread=3152. Client. Instance=. VD=Global\SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F_SQLVDIMemoryName_0.,(0),1,,mycompany1
    10/03/2007 21:10:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:18610:1<c/> last LSN: 65987:19598:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_70EB5CA3-0A1E-4E28-9B58-8AF4A0C9A1D5'}). This is an informational message only. No user action is required.,,,,
    10/03/2007 21:10:01,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:18610:1<c/> last LSN: 65987:19598:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_70EB5CA3-0A1E-4E28-9B58-8AF4A0C9A1D5'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1
    10/03/2007 21:05:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:17514:1<c/> last LSN: 65987:18610:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_BB6BFF8F-88DA-47C4-8F6D-587B200E193A'}). This is an informational message only. No user action is required.,,,,
    10/03/2007 21:05:01,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:17514:1<c/> last LSN: 65987:18610:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_BB6BFF8F-88DA-47C4-8F6D-587B200E193A'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1
    10/03/2007 21:00:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:16317:1<c/> last LSN: 65987:17514:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_96CEACFB-1969-464F-A6F4-13036346DAA9'}). This is an informational message only. No user action is required.,,,,
    10/03/2007 21:00:01,SQLVDI,Error,SQLVDI: Loc=SVDS::Open. Desc=Open(Control). ErrorCode=(2)The system cannot find the file specified.<nl/>. Process=1084. Thread=212. Server. Instance=MSSQLSERVER. VD=Global\SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F_SQLVDIMemoryName_0.,(0),1,,mycompany1
    10/03/2007 20:55:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:15391:1<c/> last LSN: 65987:16317:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_B242D625-E019-489B-9C90-11A0D04B4C8D'}). This is an informational message only. No user action is required.,,,,
    10/03/2007 20:55:01,SQLVDI,Error,SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=3740. Thread=3152. Client. Instance=. VD=Global\SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F_SQLVDIMemoryName_0.,(0),1,,mycompany1
    10/03/2007 20:50:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:14351:1<c/> last LSN: 65987:15391:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_75F6DFA5-FDA9-449D-A61C-6A5EF60B0773'}). This is an informational message only. No user action is required.,,,,
    10/03/2007 20:50:01,SQLVDI,Error,SQLVDI: Loc=CVDS::Close. Desc=Abnormal termination state. ErrorCode=(0). Process=3740. Thread=3152. Client. Instance=. VD=Global\SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F_SQLVDIMemoryName_0.,(0),1,,mycompany1
    10/03/2007 20:45:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:12761:1<c/> last LSN: 65987:14351:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_6C1D0756-3401-4ABA-980D-B1E1804F5108'}). This is an informational message only. No user action is required.,,,,
    10/03/2007 20:45:01,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:18610:1<c/> last LSN: 65987:19598:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_70EB5CA3-0A1E-4E28-9B58-8AF4A0C9A1D5'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1
    10/03/2007 20:40:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:11610:1<c/> last LSN: 65987:12761:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_8A8AA851-B29E-4DDF-AC7E-37EA7EB9D0C5'}). This is an informational message only. No user action is required.,,,,
    10/03/2007 20:40:01,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:17514:1<c/> last LSN: 65987:18610:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_BB6BFF8F-88DA-47C4-8F6D-587B200E193A'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1
    10/03/2007 20:35:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:10375:1<c/> last LSN: 65987:11610:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_FFE73139-1FFF-4F95-9A91-01B2341CD98C'}). This is an informational message only. No user action is required.,,,,
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi, I did notice this:
    The log in this backup set begins at LSN 65987000002150400001, which is too recent to apply to the database. An earlier log backup that includes LSN 65987000001959800001 can be restored.
    It probably means that some other backup process (native backup?) had backed up the log after SQL Backup or some other process (maintenence plan?) had truncated the log. This would change the LSNs to be out-of-sequence with the standby database. Hopefully that's all it is.
  • Options
    Well we only use the redgate software to do backup so there is no competing backup process. THe problem has not appeared again so far. With our upgrade to SQL 2005 and your insight, I was hoping you might be able to see something we over looked in the logs

    Thanks for taking look
Sign In or Register to comment.