Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Logshipping Err14262 - Unable 2 Disable Logshippin

Author  Topic 

Rajeshjaiswalraj
Starting Member

7 Posts

Posted - 2011-06-23 : 01:04:24
Hi

I wanted to disable logshipping, so i deleted all the jobs (Backup job in primary instance,Copy and Restore in sencondary instance), later i right clicked on my database -->properties-->transaction log shipping but i am not able to disable the logshipping and getting this Error 14262...

Please help in solving the above problem

chethu
Starting Member

3 Posts

Posted - 2011-06-23 : 01:32:08
I am facing the same problem aswell.... instead of disabling the logshipping by

1.RC on Database
2.properties
3.transaction log shipping
4.Unchecking the Enable this as a primary database in a logshipping configuration

I deleted the jobs and later tried to do the above steps, now i am unable to disable logshipping

Please help
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-23 : 12:24:58
You can manually remove log shipping by deleting all rows in the log shipping tables in the msdb database on each of the servers (primary, secondary, and monitor).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

chethu
Starting Member

3 Posts

Posted - 2011-06-24 : 00:47:32
Thanks tkizer...

But the above issue got solved when i used a login with sysadmin priv
Go to Top of Page

Rajeshjaiswalraj
Starting Member

7 Posts

Posted - 2011-06-24 : 00:49:48
Thanks Tara..........
Go to Top of Page
   

- Advertisement -