Thanks for the suggestion. I am really tempted to go try it just to see the results (on a non-production server of course). To anyone unfamiliar with the DBCC REBUILD_LOG,...

Franco,

I think you should definitely want to try the options to not lose data first. In our case, they did not fix the DB so we could reattch. So, we...

Here are the following steps that got my corrupted and detached DB re-attached and into emergency mode so that I could retrieve data from it. NOTE THAT DATA WAS LOST...

Andy, thanks for the suggestion. I tried it and it failed. I then tried on a completely different server and that failed too.

Eventually a co-worker called MS and they were...

Thanks for your suggestions.

The account which SQL runs was not changed.

The service accounts are with an administrator account on the local server(server in a workgroup not in a domain).

I...