Mani

Were you able to restore this database after your log issue?

David

Mani

You have to test your ability to restore this database up to your last log backup. I've very suspicious about this "resolution" to your problem.

David

In my step 5 on the test system, starting the database with the files copied from prod (essential a cold backup and restore) should have caused a standard roll forward...

Paul

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 commit and...

Obviously, if your choice is to follow Paul Randall's advice or mine, that is officially a no-brainer.:D

That said, I have successfully used the advice I gave. I...

Is the database still operational? If the log is corrupt I would suspect the database would come up as corrupt and\or be unable to process.

I would try this:

1. On a...

Since you don't have a complete backup of table X and the data was deleted he can't load\restore from that file.

Sql Server 7 and up doesn't not support table level...

I've been doing Sql Server for 12 years and I learn something from every video. This one was great.

Thanks

The last two shops I've been in have had Second level support teams for that situation. Other than that I've seen "who touched it last" as a...

I found the code I was looking for. I might be from one of the previously mentioned KB articles but if you send me your e-mail via a...

I like G's answer. Certs don't mean much if you haven't at least played around with stuff on your own.

Another thought is Reporting Services is popular...

I think you have got a decent shot. I can only speak for the Minneapolis market but their are new Sql Server jobs everyday on Craigslist and Monster....

Hmmm it doesn't appear there is any easy way to do that. Writing a script to add all the logins and resolve the database users should be...

Are you dealing with Windows Auth or Sql logins?

If you made the jump to 2005 ok you should be able to use:

ALTER DATABASE database_name

SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 }

to fix the compat...