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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Invalid object 'msdb.dbo.log_shipping_databases'

Author  Topic 

ddamico
Yak Posting Veteran

76 Posts

Posted - 2008-11-05 : 15:27:33
Good afternoon

This should be under SQL SERVER 2000 Forum... My Bad

I have an error showing up in my maintenance plan logs. It appears that the job is completing successfully and transaction logs are generated but I receive the following

[Microsoft SQL-DMO (ODBC SQLState: 42S02)] Error 208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'msdb.dbo.log_shipping_databases'.
[9] Database <dbname>: Transaction Log Backup...
Destination: [E:\Microsoft SQL Server\MSSQL\BACKUP\Transaction Log\<dbname>.TRN]

Has anyone seen this and know what is up. These errors just started cropping up about 1 week ago and hte maintenance plan has been in use for the last 3 years without any error like this.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-11-05 : 15:44:17
Google is your friend..

http://www.plack.net/index.php/2006/02/16/log_shipping_databases_error
Go to Top of Page

ddamico
Yak Posting Veteran

76 Posts

Posted - 2008-11-05 : 15:48:08
RickD

I did find that. Now I am wondering what happened to those objects if I was never receiving these errors before last week. I thought maybe there was more to this than the fact that these were missing.
Go to Top of Page

saurabhsrivastava
Posting Yak Master

216 Posts

Posted - 2008-11-05 : 15:52:18

1)Have you upgraded the service pack recently?

2)Run DBCC Checkdb against msdb


Thanks Tara for pointing it out. My bad. I had something else running in my mind and I didn't realize that.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-11-05 : 16:15:39
What does an external RAID array have to do with this issue?

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

Subscribe to my blog
Go to Top of Page

ddamico
Yak Posting Veteran

76 Posts

Posted - 2008-11-06 : 08:36:06
We have been at SP4 for over since the inception of this instance of SQL back in March of 2006.

Storage is all local disk and I don't notice any comments about external RAID in the replies.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-11-06 : 15:56:55
SQL Server 2005 does not even have service pack 4, so you are mistaken. We are only at SP2 currently with SP3 getting released soon.

The external RAID post of mine had to do with the previous poster's original post. He edited it to remove the info as it wasn't related to your issue. You'll notice the edit in that post.

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

Subscribe to my blog
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-11-07 : 07:57:54
ddamico - Not sure, but something must have changed to cause this to happen, please check ALL of your updates, including Windows updates. If nothing obvious, open a call with Microsoft.

Tara - The OP does say in the first post that this shouls have been posted in the SQL 2000 forum.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-11-07 : 13:47:10
I'm moving it to the SQL Server 2000 forum.

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

Subscribe to my blog
Go to Top of Page
   

- Advertisement -