SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Invalid object 'msdb.dbo.log_shipping_databases'
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ddamico
Yak Posting Veteran

76 Posts

Posted - 11/05/2008 :  15:27:33  Show Profile  Reply with Quote
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.

Edited by - tkizer on 11/07/2008 13:47:19

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 11/05/2008 :  15:44:17  Show Profile  Reply with Quote
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 - 11/05/2008 :  15:48:08  Show Profile  Reply with Quote
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

USA
216 Posts

Posted - 11/05/2008 :  15:52:18  Show Profile  Reply with Quote

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.

Edited by - saurabhsrivastava on 11/05/2008 17:01:20
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 11/05/2008 :  16:15:39  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 11/06/2008 :  08:36:06  Show Profile  Reply with Quote
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

USA
37133 Posts

Posted - 11/06/2008 :  15:56:55  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

United Kingdom
3608 Posts

Posted - 11/07/2008 :  07:57:54  Show Profile  Reply with Quote
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

USA
37133 Posts

Posted - 11/07/2008 :  13:47:10  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000