2/27/2026 1:07:58 PM
Version:V3.0.1
----------------------- SQL SERVER JOBS --------------------------
Job Name: LSCopy_V2_lounge
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.50.6000.34 ((KJ_SP3).140819-1214 )]
Microsoft Corporation. All rights reserved.
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
2026-02-27 12:15:00.78 ----- START OF TRANSACTION LOG COPY -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
2026-02-27 12:15:00.90 Starting transaction log copy. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 12:15:00.90 Retrieving copy settings. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 12:15:00.90 Retrieved copy settings. Primary Server: 'V2', Primary Database: 'lounge', Backup Source Directory: '\\192.168.0.137\sqldata', Backup Destination Directory: 'c:\sqldata', Last Copied File: 'c:\sqldata\lounge_20260227184501.trn'
2026-02-27 12:15:00.92 Copying log backup files. Primary Server: 'V2', Primary Database: 'lounge', Backup Source Directory: '\\192.168.0.137\sqldata', Backup Destination Directory: 'c:\sqldata'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
2026-02-27 12:15:00.97 Copying log backup file to temporary work file. Source: '\\192.168.0.137\sqldata\lounge_20260227190001.trn', Destination: 'c:\sqldata\lounge_20260227190001.wrk'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
2026-02-27 12:15:01.15 Renamed temporary work file. Source: 'c:\sqldata\lounge_20260227190001.wrk', Destination: 'c:\sqldata\lounge_20260227190001.trn'
2026-02-27 12:15:01.19 Checking to see if any previously copied log backup files that are required by the restore operation are missing. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 12:15:01.20 The copy operation was successful. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3', Number of log backup files copied: 1
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
2026-02-27 12:15:01.26 ----- END OF TRANSACTION LOG COPY -----
Exit Status: 0 (Success)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
The job succeeded. The Job was invoked by Schedule 109 (DefaultCopyJobSchedule). The last step to run was step 1 (Log shipping copy job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.50.6000.34 ((KJ_SP3).140819-1214 )]
Microsoft Corporation. All rights reserved.
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
2026-02-27 12:30:00.74 ----- START OF TRANSACTION LOG COPY -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
2026-02-27 12:30:00.85 Starting transaction log copy. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 12:30:00.85 Retrieving copy settings. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 12:30:00.87 Retrieved copy settings. Primary Server: 'V2', Primary Database: 'lounge', Backup Source Directory: '\\192.168.0.137\sqldata', Backup Destination Directory: 'c:\sqldata', Last Copied File: 'c:\sqldata\lounge_20260227190001.trn'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
2026-02-27 12:30:00.88 Copying log backup files. Primary Server: 'V2', Primary Database: 'lounge', Backup Source Directory: '\\192.168.0.137\sqldata', Backup Destination Directory: 'c:\sqldata'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
2026-02-27 12:30:00.93 Copying log backup file to temporary work file. Source: '\\192.168.0.137\sqldata\lounge_20260227191501.trn', Destination: 'c:\sqldata\lounge_20260227191501.wrk'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
2026-02-27 12:30:01.29 Renamed temporary work file. Source: 'c:\sqldata\lounge_20260227191501.wrk', Destination: 'c:\sqldata\lounge_20260227191501.trn'
2026-02-27 12:30:01.30 Checking to see if any previously copied log backup files that are required by the restore operation are missing. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 12:30:01.32 The copy operation was successful. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3', Number of log backup files copied: 1
2026-02-27 12:30:01.32 ----- END OF TRANSACTION LOG COPY -----
Exit Status: 0 (Success)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
The job succeeded. The Job was invoked by Schedule 109 (DefaultCopyJobSchedule). The last step to run was step 1 (Log shipping copy job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.50.6000.34 ((KJ_SP3).140819-1214 )]
Microsoft Corporation. All rights reserved.
2026-02-27 12:45:00.75 ----- START OF TRANSACTION LOG COPY -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
2026-02-27 12:45:00.87 Starting transaction log copy. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
2026-02-27 12:45:00.89 Retrieving copy settings. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 12:45:00.89 Retrieved copy settings. Primary Server: 'V2', Primary Database: 'lounge', Backup Source Directory: '\\192.168.0.137\sqldata', Backup Destination Directory: 'c:\sqldata', Last Copied File: 'c:\sqldata\lounge_20260227191501.trn'
2026-02-27 12:45:00.90 Copying log backup files. Primary Server: 'V2', Primary Database: 'lounge', Backup Source Directory: '\\192.168.0.137\sqldata', Backup Destination Directory: 'c:\sqldata'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
2026-02-27 12:45:00.97 Copying log backup file to temporary work file. Source: '\\192.168.0.137\sqldata\lounge_20260227193001.trn', Destination: 'c:\sqldata\lounge_20260227193001.wrk'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
2026-02-27 12:45:01.26 Renamed temporary work file. Source: 'c:\sqldata\lounge_20260227193001.wrk', Destination: 'c:\sqldata\lounge_20260227193001.trn'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
2026-02-27 12:45:01.28 Checking to see if any previously copied log backup files that are required by the restore operation are missing. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
2026-02-27 12:45:01.31 The copy operation was successful. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3', Number of log backup files copied: 1
2026-02-27 12:45:01.31 ----- END OF TRANSACTION LOG COPY -----
Exit Status: 0 (Success)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
The job succeeded. The Job was invoked by Schedule 109 (DefaultCopyJobSchedule). The last step to run was step 1 (Log shipping copy job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.50.6000.34 ((KJ_SP3).140819-1214 )]
Microsoft Corporation. All rights reserved.
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.46 ----- START OF TRANSACTION LOG COPY -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.58 Starting transaction log copy. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 13:00:00.58 Retrieving copy settings. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.60 Retrieved copy settings. Primary Server: 'V2', Primary Database: 'lounge', Backup Source Directory: '\\192.168.0.137\sqldata', Backup Destination Directory: 'c:\sqldata', Last Copied File: 'c:\sqldata\lounge_20260227193001.trn'
2026-02-27 13:00:00.63 Copying log backup files. Primary Server: 'V2', Primary Database: 'lounge', Backup Source Directory: '\\192.168.0.137\sqldata', Backup Destination Directory: 'c:\sqldata'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.69 Copying log backup file to temporary work file. Source: '\\192.168.0.137\sqldata\lounge_20260227194501.trn', Destination: 'c:\sqldata\lounge_20260227194501.wrk'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.98 Renamed temporary work file. Source: 'c:\sqldata\lounge_20260227194501.wrk', Destination: 'c:\sqldata\lounge_20260227194501.trn'
2026-02-27 13:00:00.98 Checking to see if any previously copied log backup files that are required by the restore operation are missing. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 13:00:00.99 The copy operation was successful. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3', Number of log backup files copied: 1
2026-02-27 13:00:01.01 ----- END OF TRANSACTION LOG COPY -----
Exit Status: 0 (Success)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
The job succeeded. The Job was invoked by Schedule 109 (DefaultCopyJobSchedule). The last step to run was step 1 (Log shipping copy job step.).
-----------------------------------------------------------------------------------------------------------------
Job Name: LSRestore_V2_lounge
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.50.6000.34 ((KJ_SP3).140819-1214 )]
Microsoft Corporation. All rights reserved.
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
2026-02-27 12:15:00.79 ----- START OF TRANSACTION LOG RESTORE -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
2026-02-27 12:15:00.94 Starting transaction log restore. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 12:15:00.94 Retrieving restore settings. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 12:15:00.94 Retrieved common restore settings. Primary Server: 'V2', Primary Database: 'lounge', Backup Destination Directory: 'c:\sqldata', File Retention Period: 4320 minute(s)
2026-02-27 12:15:00.95 Retrieved database restore settings. Secondary Database: 'lounge', Restore Delay: 0, Restore All: True, Restore Mode: Standby, Disconnect Users: True, Last Restored File: c:\sqldata\lounge_20260227183001.trn, Block Size: Not Specified, Buffer Count: Not Specified, Max Transfer Size: Not Specified
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
2026-02-27 12:15:01.12 Disconnecting users. Secondary DB: 'lounge'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 46 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
2026-02-27 12:15:45.91 Restored log backup file. Secondary DB: 'lounge', File: 'c:\sqldata\lounge_20260227184501.trn'
2026-02-27 12:15:45.92 The restore operation was successful. Secondary Database: 'lounge', Number of log backup files restored: 1
2026-02-27 12:15:45.94 Deleting old log backup files. Primary Database: 'lounge'
2026-02-27 12:15:45.94 Deleting log backup file. File: 'c:\sqldata\lounge_20260224190001.trn', Last Write Time (UTC): '2/24/2026 7:00:01 PM'
2026-02-27 12:15:45.95 The restore operation was successful. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 12:15:45.97 ----- END OF TRANSACTION LOG RESTORE -----
Exit Status: 0 (Success)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 47 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 47 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
The job succeeded. The Job was invoked by Schedule 110 (DefaultRestoreJobSchedule). The last step to run was step 1 (Log shipping restore log job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.50.6000.34 ((KJ_SP3).140819-1214 )]
Microsoft Corporation. All rights reserved.
2026-02-27 12:30:00.72 ----- START OF TRANSACTION LOG RESTORE -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
2026-02-27 12:30:00.85 Starting transaction log restore. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
2026-02-27 12:30:00.87 Retrieving restore settings. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 12:30:00.87 Retrieved common restore settings. Primary Server: 'V2', Primary Database: 'lounge', Backup Destination Directory: 'c:\sqldata', File Retention Period: 4320 minute(s)
2026-02-27 12:30:00.87 Retrieved database restore settings. Secondary Database: 'lounge', Restore Delay: 0, Restore All: True, Restore Mode: Standby, Disconnect Users: True, Last Restored File: c:\sqldata\lounge_20260227184501.trn, Block Size: Not Specified, Buffer Count: Not Specified, Max Transfer Size: Not Specified
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
2026-02-27 12:30:00.99 Disconnecting users. Secondary DB: 'lounge'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 46 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
2026-02-27 12:30:46.29 Restored log backup file. Secondary DB: 'lounge', File: 'c:\sqldata\lounge_20260227190001.trn'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 46 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
2026-02-27 12:30:46.32 The restore operation was successful. Secondary Database: 'lounge', Number of log backup files restored: 1
2026-02-27 12:30:46.32 Deleting old log backup files. Primary Database: 'lounge'
2026-02-27 12:30:46.34 Deleting log backup file. File: 'c:\sqldata\lounge_20260224191500.trn', Last Write Time (UTC): '2/24/2026 7:15:01 PM'
2026-02-27 12:30:46.35 The restore operation was successful. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 12:30:46.37 ----- END OF TRANSACTION LOG RESTORE -----
Exit Status: 0 (Success)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 48 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 48 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
The job succeeded. The Job was invoked by Schedule 110 (DefaultRestoreJobSchedule). The last step to run was step 1 (Log shipping restore log job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.50.6000.34 ((KJ_SP3).140819-1214 )]
Microsoft Corporation. All rights reserved.
2026-02-27 12:45:00.75 ----- START OF TRANSACTION LOG RESTORE -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
2026-02-27 12:45:00.87 Starting transaction log restore. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
2026-02-27 12:45:00.89 Retrieving restore settings. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 12:45:00.90 Retrieved common restore settings. Primary Server: 'V2', Primary Database: 'lounge', Backup Destination Directory: 'c:\sqldata', File Retention Period: 4320 minute(s)
2026-02-27 12:45:00.90 Retrieved database restore settings. Secondary Database: 'lounge', Restore Delay: 0, Restore All: True, Restore Mode: Standby, Disconnect Users: True, Last Restored File: c:\sqldata\lounge_20260227190001.trn, Block Size: Not Specified, Buffer Count: Not Specified, Max Transfer Size: Not Specified
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
2026-02-27 12:45:01.09 Disconnecting users. Secondary DB: 'lounge'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 231 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
2026-02-27 12:47:31.13 Restored log backup file. Secondary DB: 'lounge', File: 'c:\sqldata\lounge_20260227191501.trn'
2026-02-27 12:47:31.16 The restore operation was successful. Secondary Database: 'lounge', Number of log backup files restored: 1
2026-02-27 12:47:31.16 Deleting old log backup files. Primary Database: 'lounge'
2026-02-27 12:47:31.16 Deleting log backup file. File: 'c:\sqldata\lounge_20260224193000.trn', Last Write Time (UTC): '2/24/2026 7:30:01 PM'
2026-02-27 12:47:31.16 Deleting log backup file. File: 'c:\sqldata\lounge_20260224194501.trn', Last Write Time (UTC): '2/24/2026 7:45:01 PM'
2026-02-27 12:47:31.19 The restore operation was successful. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 12:47:31.19 ----- END OF TRANSACTION LOG RESTORE -----
Exit Status: 0 (Success)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 233 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 233 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
The job succeeded. The Job was invoked by Schedule 110 (DefaultRestoreJobSchedule). The last step to run was step 1 (Log shipping restore log job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.50.6000.34 ((KJ_SP3).140819-1214 )]
Microsoft Corporation. All rights reserved.
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.46 ----- START OF TRANSACTION LOG RESTORE -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.60 Starting transaction log restore. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 13:00:00.60 Retrieving restore settings. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 13:00:00.63 Retrieved common restore settings. Primary Server: 'V2', Primary Database: 'lounge', Backup Destination Directory: 'c:\sqldata', File Retention Period: 4320 minute(s)
2026-02-27 13:00:00.63 Retrieved database restore settings. Secondary Database: 'lounge', Restore Delay: 0, Restore All: True, Restore Mode: Standby, Disconnect Users: True, Last Restored File: c:\sqldata\lounge_20260227191501.trn, Block Size: Not Specified, Buffer Count: Not Specified, Max Transfer Size: Not Specified
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.80 Disconnecting users. Secondary DB: 'lounge'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 51 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:51.95 Restored log backup file. Secondary DB: 'lounge', File: 'c:\sqldata\lounge_20260227193001.trn'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 52 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:51.98 The restore operation was successful. Secondary Database: 'lounge', Number of log backup files restored: 1
2026-02-27 13:00:51.98 Deleting old log backup files. Primary Database: 'lounge'
2026-02-27 13:00:52.01 The restore operation was successful. Secondary ID: '63b25b32-41bc-464e-9a78-8a5543bd47a3'
2026-02-27 13:00:52.01 ----- END OF TRANSACTION LOG RESTORE -----
Exit Status: 0 (Success)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 53 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 53 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
The job succeeded. The Job was invoked by Schedule 110 (DefaultRestoreJobSchedule). The last step to run was step 1 (Log shipping restore log job step.).
-----------------------------------------------------------------------------------------------------------------
Job Name: LSRestore_V2_archives26
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.50.6000.34 ((KJ_SP3).140819-1214 )]
Microsoft Corporation. All rights reserved.
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
2026-02-27 12:15:00.78 ----- START OF TRANSACTION LOG RESTORE -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
2026-02-27 12:15:00.90 Starting transaction log restore. Secondary ID: 'c92d4185-b721-4641-97de-4cf95a86aeab'
2026-02-27 12:15:00.90 Retrieving restore settings. Secondary ID: 'c92d4185-b721-4641-97de-4cf95a86aeab'
2026-02-27 12:15:00.92 Retrieved common restore settings. Primary Server: 'V2', Primary Database: 'archives26', Backup Destination Directory: 'c:\sqldata', File Retention Period: 2880 minute(s)
2026-02-27 12:15:00.92 Retrieved database restore settings. Secondary Database: 'archives26', Restore Delay: 0, Restore All: True, Restore Mode: No Recovery, Disconnect Users: False, Last Restored File: c:\sqldata\archives26_20260227072600.trn, Block Size: Not Specified, Buffer Count: Not Specified, Max Transfer Size: Not Specified
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
2026-02-27 12:15:01.06 Could not find a log backup file that could be applied to secondary database 'archives26'.
2026-02-27 12:15:01.06 The restore operation was successful. Secondary Database: 'archives26', Number of log backup files restored: 0
2026-02-27 12:15:01.06 Deleting old log backup files. Primary Database: 'archives26'
2026-02-27 12:15:01.06 The restore operation was successful. Secondary ID: 'c92d4185-b721-4641-97de-4cf95a86aeab'
2026-02-27 12:15:01.08 ----- END OF TRANSACTION LOG RESTORE -----
Exit Status: 0 (Success)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121500
Message:
The job succeeded. The Job was invoked by Schedule 140 (DefaultRestoreJobSchedule). The last step to run was step 1 (Log shipping restore log job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.50.6000.34 ((KJ_SP3).140819-1214 )]
Microsoft Corporation. All rights reserved.
2026-02-27 12:30:00.72 ----- START OF TRANSACTION LOG RESTORE -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
2026-02-27 12:30:00.85 Starting transaction log restore. Secondary ID: 'c92d4185-b721-4641-97de-4cf95a86aeab'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
2026-02-27 12:30:00.87 Retrieving restore settings. Secondary ID: 'c92d4185-b721-4641-97de-4cf95a86aeab'
2026-02-27 12:30:00.87 Retrieved common restore settings. Primary Server: 'V2', Primary Database: 'archives26', Backup Destination Directory: 'c:\sqldata', File Retention Period: 2880 minute(s)
2026-02-27 12:30:00.87 Retrieved database restore settings. Secondary Database: 'archives26', Restore Delay: 0, Restore All: True, Restore Mode: No Recovery, Disconnect Users: False, Last Restored File: c:\sqldata\archives26_20260227072600.trn, Block Size: Not Specified, Buffer Count: Not Specified, Max Transfer Size: Not Specified
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
2026-02-27 12:30:00.99 Could not find a log backup file that could be applied to secondary database 'archives26'.
2026-02-27 12:30:00.99 The restore operation was successful. Secondary Database: 'archives26', Number of log backup files restored: 0
2026-02-27 12:30:00.99 Deleting old log backup files. Primary Database: 'archives26'
2026-02-27 12:30:00.99 The restore operation was successful. Secondary ID: 'c92d4185-b721-4641-97de-4cf95a86aeab'
2026-02-27 12:30:00.99 ----- END OF TRANSACTION LOG RESTORE -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
Exit Status: 0 (Success)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
The job succeeded. The Job was invoked by Schedule 140 (DefaultRestoreJobSchedule). The last step to run was step 1 (Log shipping restore log job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.50.6000.34 ((KJ_SP3).140819-1214 )]
Microsoft Corporation. All rights reserved.
2026-02-27 12:45:00.75 ----- START OF TRANSACTION LOG RESTORE -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
2026-02-27 12:45:00.87 Starting transaction log restore. Secondary ID: 'c92d4185-b721-4641-97de-4cf95a86aeab'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
2026-02-27 12:45:00.89 Retrieving restore settings. Secondary ID: 'c92d4185-b721-4641-97de-4cf95a86aeab'
2026-02-27 12:45:00.90 Retrieved common restore settings. Primary Server: 'V2', Primary Database: 'archives26', Backup Destination Directory: 'c:\sqldata', File Retention Period: 2880 minute(s)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
2026-02-27 12:45:00.90 Retrieved database restore settings. Secondary Database: 'archives26', Restore Delay: 0, Restore All: True, Restore Mode: No Recovery, Disconnect Users: False, Last Restored File: c:\sqldata\archives26_20260227072600.trn, Block Size: Not Specified, Buffer Count: Not Specified, Max Transfer Size: Not Specified
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 1 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
2026-02-27 12:45:01.06 Could not find a log backup file that could be applied to secondary database 'archives26'.
2026-02-27 12:45:01.08 The restore operation was successful. Secondary Database: 'archives26', Number of log backup files restored: 0
2026-02-27 12:45:01.08 Deleting old log backup files. Primary Database: 'archives26'
2026-02-27 12:45:01.08 The restore operation was successful. Secondary ID: 'c92d4185-b721-4641-97de-4cf95a86aeab'
2026-02-27 12:45:01.09 ----- END OF TRANSACTION LOG RESTORE -----
Exit Status: 0 (Success)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124500
Message:
The job succeeded. The Job was invoked by Schedule 140 (DefaultRestoreJobSchedule). The last step to run was step 1 (Log shipping restore log job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.50.6000.34 ((KJ_SP3).140819-1214 )]
Microsoft Corporation. All rights reserved.
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.46 ----- START OF TRANSACTION LOG RESTORE -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.60 Starting transaction log restore. Secondary ID: 'c92d4185-b721-4641-97de-4cf95a86aeab'
2026-02-27 13:00:00.60 Retrieving restore settings. Secondary ID: 'c92d4185-b721-4641-97de-4cf95a86aeab'
2026-02-27 13:00:00.63 Retrieved common restore settings. Primary Server: 'V2', Primary Database: 'archives26', Backup Destination Directory: 'c:\sqldata', File Retention Period: 2880 minute(s)
2026-02-27 13:00:00.63 Retrieved database restore settings. Secondary Database: 'archives26', Restore Delay: 0, Restore All: True, Restore Mode: No Recovery, Disconnect Users: False, Last Restored File: c:\sqldata\archives26_20260227072600.trn, Block Size: Not Specified, Buffer Count: Not Specified, Max Transfer Size: Not Specified
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.80 Could not find a log backup file that could be applied to secondary database 'archives26'.
2026-02-27 13:00:00.80 The restore operation was successful. Secondary Database: 'archives26', Number of log backup files restored: 0
2026-02-27 13:00:00.80 Deleting old log backup files. Primary Database: 'archives26'
2026-02-27 13:00:00.80 The restore operation was successful. Secondary ID: 'c92d4185-b721-4641-97de-4cf95a86aeab'
2026-02-27 13:00:00.82 ----- END OF TRANSACTION LOG RESTORE -----
Exit Status: 0 (Success)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
The job succeeded. The Job was invoked by Schedule 140 (DefaultRestoreJobSchedule). The last step to run was step 1 (Log shipping restore log job step.).
-----------------------------------------------------------------------------------------------------------------
Job Name: LSCopy_V2_WhoViewed
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121000
Message:
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.50.6000.34 ((KJ_SP3).140819-1214 )]
Microsoft Corporation. All rights reserved.
2026-02-27 12:10:00.34 ----- START OF TRANSACTION LOG COPY -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121000
Message:
2026-02-27 12:10:00.45 Starting transaction log copy. Secondary ID: 'c883be25-5dfa-49ff-b4d2-e2b9bfc55ce5'
2026-02-27 12:10:00.45 Retrieving copy settings. Secondary ID: 'c883be25-5dfa-49ff-b4d2-e2b9bfc55ce5'
2026-02-27 12:10:00.47 Retrieved copy settings. Primary Server: 'V2', Primary Database: 'WhoViewed', Backup Source Directory: '\\192.168.0.137\sqldata', Backup Destination Directory: 'c:\sqldata', Last Copied File: 'c:\sqldata\WhoViewed_20260227180501.trn'
2026-02-27 12:10:00.48 Copying log backup files. Primary Server: 'V2', Primary Database: 'WhoViewed', Backup Source Directory: '\\192.168.0.137\sqldata', Backup Destination Directory: 'c:\sqldata'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121000
Message:
2026-02-27 12:10:00.53 Copying log backup file to temporary work file. Source: '\\192.168.0.137\sqldata\WhoViewed_20260227190500.trn', Destination: 'c:\sqldata\WhoViewed_20260227190500.wrk'
2026-02-27 12:10:00.61 Renamed temporary work file. Source: 'c:\sqldata\WhoViewed_20260227190500.wrk', Destination: 'c:\sqldata\WhoViewed_20260227190500.trn'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121000
Message:
2026-02-27 12:10:00.63 Checking to see if any previously copied log backup files that are required by the restore operation are missing. Secondary ID: 'c883be25-5dfa-49ff-b4d2-e2b9bfc55ce5'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121000
Message:
2026-02-27 12:10:00.64 The copy operation was successful. Secondary ID: 'c883be25-5dfa-49ff-b4d2-e2b9bfc55ce5', Number of log backup files copied: 1
2026-02-27 12:10:00.64 ----- END OF TRANSACTION LOG COPY -----
Exit Status: 0 (Success)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121000
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121000
Message:
The job succeeded. The Job was invoked by Schedule 137 (DefaultCopyJobSchedule). The last step to run was step 1 (Log shipping copy job step.).
-----------------------------------------------------------------------------------------------------------------
Job Name: LSCopy_V2_geoipdata
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.50.6000.34 ((KJ_SP3).140819-1214 )]
Microsoft Corporation. All rights reserved.
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.46 ----- START OF TRANSACTION LOG COPY -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.58 Starting transaction log copy. Secondary ID: '9c55e92e-e8f2-4eeb-b42d-359855b6002d'
2026-02-27 13:00:00.58 Retrieving copy settings. Secondary ID: '9c55e92e-e8f2-4eeb-b42d-359855b6002d'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.60 Retrieved copy settings. Primary Server: 'V2', Primary Database: 'geoipdata', Backup Source Directory: '\\192.168.0.137\sqldata', Backup Destination Directory: 'c:\sqldata', Last Copied File: 'c:\sqldata\geoipdata_20260226190000.trn'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.63 Copying log backup files. Primary Server: 'V2', Primary Database: 'geoipdata', Backup Source Directory: '\\192.168.0.137\sqldata', Backup Destination Directory: 'c:\sqldata'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.68 Copying log backup file to temporary work file. Source: '\\192.168.0.137\sqldata\geoipdata_20260227190001.trn', Destination: 'c:\sqldata\geoipdata_20260227190001.wrk'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
2026-02-27 13:00:00.90 Renamed temporary work file. Source: 'c:\sqldata\geoipdata_20260227190001.wrk', Destination: 'c:\sqldata\geoipdata_20260227190001.trn'
2026-02-27 13:00:00.93 Checking to see if any previously copied log backup files that are required by the restore operation are missing. Secondary ID: '9c55e92e-e8f2-4eeb-b42d-359855b6002d'
2026-02-27 13:00:00.94 The copy operation was successful. Secondary ID: '9c55e92e-e8f2-4eeb-b42d-359855b6002d', Number of log backup files copied: 1
2026-02-27 13:00:00.94 ----- END OF TRANSACTION LOG COPY -----
Exit Status: 0 (Success)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping copy job step. Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
The job succeeded. The Job was invoked by Schedule 131 (DefaultCopyJobSchedule). The last step to run was step 1 (Log shipping copy job step.).
-----------------------------------------------------------------------------------------------------------------
Job Name: LSAlert_SGDB1
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 120800
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 120800
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121000
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121000
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121200
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121200
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121400
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121400
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121600
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121600
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121800
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121800
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 122000
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 122000
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 122200
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 122200
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 122400
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 122400
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 122600
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 122600
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 122800
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 122800
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123000
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123200
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123200
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123400
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123400
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123600
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123600
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123800
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 123800
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124000
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124000
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124200
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124200
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124400
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124400
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124600
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124600
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124800
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 124800
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 125000
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 125000
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 125200
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 125200
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 125400
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 125400
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 125600
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 125600
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 125800
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 125800
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130000
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130200
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130200
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130400
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130400
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping alert job step. Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130600
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 0 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 130600
Message:
The job succeeded. The Job was invoked by Schedule 16 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
-----------------------------------------------------------------------------------------------------------------
Job Name: LSRestore_V2_WhoViewed
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121400
Message:
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.50.6000.34 ((KJ_SP3).140819-1214 )]
Microsoft Corporation. All rights reserved.
2026-02-27 12:14:00.37 ----- START OF TRANSACTION LOG RESTORE -----
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121400
Message:
2026-02-27 12:14:00.50 Starting transaction log restore. Secondary ID: 'c883be25-5dfa-49ff-b4d2-e2b9bfc55ce5'
2026-02-27 12:14:00.50 Retrieving restore settings. Secondary ID: 'c883be25-5dfa-49ff-b4d2-e2b9bfc55ce5'
2026-02-27 12:14:00.50 Retrieved common restore settings. Primary Server: 'V2', Primary Database: 'WhoViewed', Backup Destination Directory: 'c:\sqldata', File Retention Period: 2880 minute(s)
2026-02-27 12:14:00.51 Retrieved database restore settings. Secondary Database: 'WhoViewed', Restore Delay: 0, Restore All: True, Restore Mode: No Recovery, Disconnect Users: False, Last Restored File: c:\sqldata\WhoViewed_20260227180501.trn, Block Size: Not Specified, Buffer Count: Not Specified, Max Transfer Size: Not Specified
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121400
Message:
2026-02-27 12:14:00.84 Restored log backup file. Secondary DB: 'WhoViewed', File: 'c:\sqldata\WhoViewed_20260227190500.trn'
2026-02-27 12:14:00.87 The restore operation was successful. Secondary Database: 'WhoViewed', Number of log backup files restored: 1
2026-02-27 12:14:00.87 Deleting old log backup files. Primary Database: 'WhoViewed'
2026-02-27 12:14:00.87 Deleting log backup file. File: 'c:\sqldata\WhoViewed_20260225190500.trn', Last Write Time (UTC): '2/25/2026 7:05:00 PM'
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 0 Run Status: 4 Retries Attempted: 0 Run Date: 20260227 Run Time: 121400
Message:
2026-02-27 12:14:00.89 The restore operation was successful. Secondary ID: 'c883be25-5dfa-49ff-b4d2-e2b9bfc55ce5'
2026-02-27 12:14:00.89 ----- END OF TRANSACTION LOG RESTORE -----
Exit Status: 0 (Success)
-----------------------------------------------------------------------------------------------------------------
Step ID: 1 Step Name: Log shipping restore log job step. Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121400
Message:
Executed as user: SGDB1\Odysseus. The step succeeded.
-----------------------------------------------------------------------------------------------------------------
Step ID: 0 Step Name: (Job outcome) Run Duration: 1 Run Status: 1 Retries Attempted: 0 Run Date: 20260227 Run Time: 121400
Message:
The job succeeded. The Job was invoked by Schedule 138 (DefaultRestoreJobSchedule). The last step to run was step 1 (Log shipping restore log job step.).
-----------------------------------------------------------------------------------------------------------------
-------------------- SQL SERVER BLOCKING LOCKS -------------------
No Blocking Locks.
------------------- SQL SERVER LAST BACKUP DATES -----------------
| DBASE NAME | BACKUP FINISHED |
|---|
archives03 | 2/27/2026 12:03:01 AM |
archives04 | 2/27/2026 12:04:01 AM |
archives05 | 2/27/2026 12:05:01 AM |
archives06 | 2/27/2026 12:06:02 AM |
archives07 | 2/27/2026 12:07:01 AM |
archives08 | 2/27/2026 12:08:01 AM |
archives09 | 2/27/2026 12:09:01 AM |
archives10 | 2/27/2026 12:10:01 AM |
archives11 | 2/27/2026 12:11:01 AM |
archives12 | 2/27/2026 12:12:01 AM |
archives13 | 2/27/2026 12:13:01 AM |
archives14 | 2/27/2026 12:14:04 AM |
archives15 | 2/27/2026 12:15:01 AM |
archives16 | 2/27/2026 12:16:00 AM |
archives17 | 2/27/2026 12:17:00 AM |
archives18 | 2/27/2026 12:18:00 AM |
archives19 | 2/27/2026 12:19:00 AM |
archives20 | 2/27/2026 12:20:00 AM |
archives21 | 2/27/2026 12:22:01 AM |
archives22 | 2/27/2026 12:22:01 AM |
archives23 | 2/27/2026 12:23:00 AM |
archives24 | 2/26/2026 12:24:01 AM |
archives25 | 2/27/2026 12:25:01 AM |
archives26 | 2/27/2026 12:26:00 AM |
customers | 6/19/2025 9:00:43 PM |
geoipdata | 2/26/2026 12:00:00 PM |
lounge | 2/27/2026 12:30:02 PM |
master | 6/19/2025 9:00:43 PM |
model | 6/19/2025 9:00:43 PM |
msdb | 6/19/2025 9:00:43 PM |
WhoViewed | 2/27/2026 12:05:00 PM |
----------------- SQL SERVER TRANSACTION LOG INFO ----------------
| DBASE NAME | TRANSACTION LOG Size (MB) | TRANSACTION LOG Usage (%) |
|---|
master | 0.7421875 | 43.28947 |
tempdb | 0.7421875 | 60.46053 |
model | 5.554688 | 98.72539 |
msdb | 61.92969 | 16.72449 |
lounge | 13307.36 | 2.942414 |
customers | 4.992188 | 18.62285 |
|