Monday, March 12, 2012

Missing table log_shipping_monitor table

We upgraded SQL Server from standard to enterprise edition. When attempting to setup a maintenance plan we got an error 208: Invalid object name: msdb.dbo.log_shipping_monitor.
The table log_shipping_monitor doesn't exist in the msdb database.
Any ideas?
what happens if you appy/re-apply the latest sp.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"John M. Snarski" <John M. Snarski@.discussions.microsoft.com> wrote in
message news:8C1CFC6B-49B9-44A9-8FDC-E5A463C6E1D7@.microsoft.com...
> We upgraded SQL Server from standard to enterprise edition. When
attempting to setup a maintenance plan we got an error 208: Invalid object
name: msdb.dbo.log_shipping_monitor.
> The table log_shipping_monitor doesn't exist in the msdb database.
> Any ideas?
|||no change
"Hilary Cotter" wrote:

> what happens if you appy/re-apply the latest sp.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "John M. Snarski" <John M. Snarski@.discussions.microsoft.com> wrote in
> message news:8C1CFC6B-49B9-44A9-8FDC-E5A463C6E1D7@.microsoft.com...
> attempting to setup a maintenance plan we got an error 208: Invalid object
> name: msdb.dbo.log_shipping_monitor.
>
>

No comments:

Post a Comment