Prev: SQL Server 2008 64bit services fail to start
Next: Change Data Capture: Preserve capture instance data when adding co
From: George on 16 Apr 2010 11:50
One of my N/A's deleted a primary database in SQL 2005 which had log shipping
configured. Needless to say, now I get errors in the log shipping reports
and event viewer.
I have removed the SQL Agent jobs for the backup, copy & restore jobs for
this database in Mangement Studio. However, I stil see the errors. I have
googled it to death and see some documents that tell me to delete the
database name from the tables in the system database.
I was under the impression you can not edit system tables in SQL 2005. Any
informtation that can be provided is greatly appreciated.
Thanks in advance.
From: Kevin Nicholas on 17 Apr 2010 00:46
This blog may help you