September 2, 2014 at 6:31 pm
Hi,
an error occurred while configuring logshipping in SQL Server 2008R2 Ent.Edition. can one of you please suggest me how to fix this error
=================================
TITLE: Microsoft SQL Server Management Studio
------------------------------
The current log shipping configuration is not functional because the required backup job cannot be found. You must drop the current configuration by clearing the 'Enable this as a primary database in a log shipping configuration' checkbox. To resume log shipping, recreate the configuration using the same settings.
If you resume log shipping and you specify the backup and restore paths that you used before, any backup files from the old configuration that are uncopied or unrestored will be copied and restored by the new configuration. Reinitializing the secondary database(s) is unnecessary.
------------------------------
ADDITIONAL INFORMATION:
The specified @job_id ('text') does not exist. (Microsoft SQL Server, Error: 14262)
September 3, 2014 at 2:00 am
The error message tells you how to fix it, look. Do this.
jakeer.basha (9/2/2014)You must drop the current configuration by clearing the 'Enable this as a primary database in a log shipping configuration' checkbox. To resume log shipping, recreate the configuration using the same settings.
If you resume log shipping and you specify the backup and restore paths that you used before, any backup files from the old configuration that are uncopied or unrestored will be copied and restored by the new configuration. Reinitializing the secondary database(s) is unnecessary.
September 4, 2014 at 8:42 pm
Basically it's telling you to remove the existing log-shipping and configure new one.
Regards,
SQLisAwe5oMe.
September 5, 2014 at 5:03 am
Follow the below procedure.....
Step 1: Primary server i run below queries.
Note: here MyDB is your database name.
1)delete from msdb.dbo.log_shipping_primaries where primary_database_name = 'MyDB'
2)delete from msdb.dbo.log_shipping_monitor_primary where primary_database= 'MyDB'
3)delete from msdb.dbo.log_shipping_primary_databases where primary_database= 'MyDB'
4)delete from msdb.dbo.log_shipping_primary_secondaries where secondary_database= 'MyDB'
Step 2: Secondary server i run below queries.
1)delete from msdb.dbo.log_shipping_secondary where primary_database='MyDB';
2)delete from msdb.dbo.log_shipping_monitor_secondary where primary_database='MyDB';
3)delete from msdb.dbo.log_shipping_secondary_databases where secondary_database='MyDB';
Regards
Chowdary...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply