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.
G
From: Kevin Nicholas on 17 Apr 2010 00:46
This blog may help you

http://sqlserver-qa.net/blogs/tools/archive/2007/04/24/sql-server-2005-ad-hoc-updates-to-system-catalogs-are-not-allowed.aspx

 | 
Pages: 1
Prev: SQL Server 2008 64bit services fail to start
Next: Change Data Capture: Preserve capture instance data when adding co