Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MSSQL 2K Log Shipping monitor

Status
Not open for further replies.
wbodger

wbodger

Programmer
Apr 23, 2007
769
US
I have a little problem. I have log shipping setup, but my monitor server died and now I can't figure out how to delete that maintenance plan so that I can build another one with a working monitor server. Any help out there for me?

Thanks,
Willie
 
Sort by date Sort by votes
OK, I found how to do it with sp_define_log_shipping_monitor and sp_remove_log_shipping_monitor.

wb
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

GCL2007
  • Locked
  • Question
Simple Recovery model - Huge Trans Log
Replies
0
Views
160
GCL2007
GCL2007
JScannell
  • Locked
  • Question
SQL login on Classic ASP localhost site
Replies
0
Views
166
JScannell
JScannell
RRinTetons
  • Locked
  • Question
SQL Server 2008 R2 login auditing
Replies
0
Views
155
RRinTetons
RRinTetons
RRinTetons
  • Locked
  • Question
Logging into a database using SSMS from non-domain machine
Replies
1
Views
207
fredericofonseca
fredericofonseca
basball
  • Locked
  • Question
re: can't see mssql.1 in dos window on 2008r2 - help : (
Replies
5
Views
112
philhege
philhege

Part and Inventory Search

Sponsor

Back
Top