One more thing - people that know stuff like IP port numbers, and can answer follow-on questions have obviously used them enough to have them in their heard, therefore you...

There's a cliched phrase: the more you know, the further you go.

When I used to interview people to be devs or managers on my various teams at Microsoft, one of...

If you don't know the name of the executable, how can you do resource balancing on a machine with multiple instances - e.g. using WSRM?

I think it's a reasonable question.

If you can run a DBCC CHECKDB and log backups successfully then I say that it looks like the db is clean.

Make sure you do some root cause analysis to...

Mani - what do you mean you changed the path and it worked? Can you explain in more detail? That doesn't make any sense.

Thanks

ok - so you really did mean the database state is ONLINE. In that case, why do anything else? You don't need to detach or build a new log file....

David O (3/7/2009)

My thought process was the corruption might be limited to a section of the log file. By rebuilding, the hope was to force all the transactions to...

David - your post is more or less ok - you're not advocating detaching the database from the prod system. However, on the test system, if the database comes online...

The link is fixed - look - I can do databases - not Internet stuff, right? 😛

Thanks Steve

Here's the post, with links to deeper explanations in each case How can a log backup fail but a full backup succeed?

Be sure to vote in the backup verification poll...

Yes, to what Gail said about bad advice - don't ever detach a broken database.

Back to the original problem - the log was corrupt, but in an interesting way. The...

Also consider that if you let chkdsk do any repairs, and it touches anything in the database files, it will most-likely result in database corruption.

You're welcome. Check out the other ones too - see the TechNet Magazine category on my blog.

Cheers

ok - no offense - but if you don't know how to do a RESTORE then I don't think this forum is the right way for you to address this....

It's no big deal - just be wary of making sweeping assertions/generalizations. Cheers