February 16, 2012 at 7:18 am
I just to the log shipping for the CnSx database, I get the below errors in the reporting server,
*** Error: The log backup file '\\islrptsql\log-ship-backups\CnSx_20120214143000.trn' was verified but could not be applied to secondary database 'CnSx'.(Microsoft.SqlServer.Management.LogShipping) ***
The restore operation completed with errors. Secondary ID: 'ab6bda6f-24fe-4065-b2d6-876acf911efd'
Thanks,
Dev
February 16, 2012 at 8:20 am
database is simple
February 16, 2012 at 8:31 am
dsohal (2/16/2012)
database is simple
Previous forum poster is asking to share full error message if you have any.
M&M
February 16, 2012 at 8:38 am
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 10.0.0.0, File Version = 10.0.5500.0 ((Katmai_PCU_Main).110922-0336 )]
Microsoft Corporation. All rights reserved.
Message
2012-02-16 10:33:36.16----- START OF TRANSACTION LOG RESTORE -----
Message
2012-02-16 10:33:36.26Starting transaction log restore. Secondary ID: 'ab6bda6f-24fe-4065-b2d6-876acf911efd'
2012-02-16 10:33:36.27Retrieving restore settings. Secondary ID: 'ab6bda6f-24fe-4065-b2d6-876acf911efd'
2012-02-16 10:33:36.28Retrieved common restore settings. Primary Server: 'ISLCNSSQL', Primary Database: 'CnSx', Backup Destination Directory: '\\islrptsql\log-ship-backups', File Retention Period: 2880 minute(s)
2012-02-16 10:33:36.28Retrieved database restore settings. Secondary Database: 'CnSx', Restore Delay: 2, Restore All: True, Restore Mode: Standby, Disconnect Users: True, Last Restored File: \\islrptsql\log-ship-backups\CnSx_20120214140000.trn, Block Size: Not Specified, Buffer Count: Not Specified, Max Transfer Size: Not Specified
Message
2012-02-16 10:33:36.41Disconnecting users. Secondary DB: 'CnSx'
Message
2012-02-16 10:33:36.65*** Error: Could not apply log backup file '\\islrptsql\log-ship-backups\CnSx_20120214143000.trn' to secondary database 'CnSx'.(Microsoft.SqlServer.Management.LogShipping) ***
2012-02-16 10:33:36.65*** Error: There is insufficient free space on disk volume 'L:\' to create the database. The database requires 15587278848 additional free bytes, while only 8799973376 bytes are available.
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
RESTORE LOG is terminating abnormally.(.Net SqlClient Data Provider) ***
Message
2012-02-16 10:34:31.68*** Error: The log backup file '\\islrptsql\log-ship-backups\CnSx_20120214143000.trn' was verified but could not be applied to secondary database 'CnSx'.(Microsoft.SqlServer.Management.LogShipping) ***
2012-02-16 10:34:31.68Deleting old log backup files. Primary Database: 'CnSx'
Message
2012-02-16 10:34:31.79The restore operation completed with errors. Secondary ID: 'ab6bda6f-24fe-4065-b2d6-876acf911efd'
Message
2012-02-16 10:34:31.83----- END OF TRANSACTION LOG RESTORE -----
Exit Status: 1 (Error)
Message
Executed as user:
. The step failed.
February 16, 2012 at 8:50 am
I get this message at the Alert Job,
Message
Executed as user: sa. The log shipping secondary database ISLRPTSQL.CnSx has restore threshold of 840 minutes and is out of sync. No restore was performed for 2911 minutes. Restored latency is 77 minutes. Check agent log and logshipping monitor information. [SQLSTATE 42000] (Error 14421). The step failed.
Please Help with this,
Regards,
February 16, 2012 at 8:59 am
problems in the error log
Error: There is insufficient free space on disk volume 'L:\' to create the database. The database requires 15587278848 additional free bytes, while only 8799973376 bytes are available.
Your out of disk space, and you will get the out of sync message as restores cant happen so your database is out of sync from the primary node
February 16, 2012 at 9:35 am
Thanks a Lot, it is fixed, it was a space issue,
February 16, 2012 at 10:21 am
happy to help as always
always good to give the error log a good read usually contains the problem your facing
February 16, 2012 at 10:24 am
that's correct, I will keep that in mind Thanks Again
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply