Hi Turkan,

Are you using third party software? If so i would contact the manufacturer. It sounds like the issue is with the software and not the DB. I mean if...

That's a great article! And the one prior to it specifies the steps required to do the work. Thanks for pointing that!

Thanks for the heads up about that site. i wasn't able to find the specific article you suggested as that site's search function isn't very good and the article titles...

While researching an issue with my transaction logs, I cam across this on msdn:

from http://support.microsoft.com/?id=317375

In addition to this error message, SQL Server may mark databases suspect because of...

lol.. I think you are right about the bad code. No one at my shop is an expert in dbs and unfortunately when the issue of performance hampering behaviors comes...

You're right ...i checked and the transaction logs are backed up every hour. Thanks!

I read the article and it was very good. It filled in some details that other, mostly...

I'm using IE 7 too but get a 400 error. Works good in Firefox. I'm beihind a firewall so maybe that has something to do with it.

lol..Actually, if you reread my initial post I was only asking questions about his situation and suggesting he try telnetting intot he machine if it was unreachable... not terrible advice...

Thanks Gila...I...

You probably mistyped your dbname or password. Have another look at that connection string as that is usually the cause of the problem.

What about Enterprise Manager -->Tools --> Options --Advanced Tab -> Login Timeout?

Any idea why it was flagged as suspect to begin with?

mine ran and completed in 5 seconds. If your server is in heavy use when you ran it perhaps...

I'm an Accidental DBA as well. Just in the past month I have been putting together a small kit of T-Sql, PerfMon routines and a Log analyzer.

Google on "Brad McGehee"...

I tried to add a reply but kept getting a 400 http error..bad request.

"While 1 = 1" ?? I'm surprised it ever ends! lol