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)
 Tlog backup error

Author  Topic 

Hommer
Aged Yak Warrior

808 Posts

Posted - 2005-04-05 : 12:09:48
I started to notice this application error in the event log whenever my tlog backup was run. The backups run fine.

Unable to open the eventlog on forwarding server '[New forwarding server]'(Reason: Sockets error 11004)

The error started to show after the network admin changed several settings on the server box based on the recommendations from the SAN vendor.

I googled it, but did not find any meaningful answers.

Does any of you know what is the nature of it?

Thanks in advance!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-04-05 : 17:32:32
Are the tlog backups restorable? Assuming that they are based upon the success of the command is not wise. Do you get the same error in the Event Log if you run BACKUP LOG in Query Analyzer?

Tara
Go to Top of Page

Hommer
Aged Yak Warrior

808 Posts

Posted - 2005-04-06 : 12:45:26

Thank you for your reply. I just saw it, and will try both (restore it to a test server and run a tlog backup from QA--this one I need to look it up from BOL, haven't done it recently).

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-04-06 : 12:48:08
BACKUP LOG DBName
TO DISK = 'F:\SomeBackupFolder\DBName.TRN'
WITH INIT

Hopefully you aren't log shipping as this will break it.

Is this from a maintenance plan? If so, try recreating it to see if the problem goes away.

Tara
Go to Top of Page
   

- Advertisement -