Ahh! Thanks for your help! You have been great!

Jason Nance, MHA

Gila:

I went through your steps successfully, but I have a question about #5. How do i know if the results from DBCC OPENTRAN are related to 'distributed and non-distributed...

Is this a BUG with SS2008? Is there a specific patch that fixes it?

Thanks again for your help!

Jason

Gail:

I need to get those other steps from you, the database is already back in a REPLICATION state when I query sys.databases.

Thanks,

Jason Nance, MHA

Excellent, Thank you Gail! ~ Jason

Your comment made me think a little differently about this. I queried the sys.databases table and looked at the log_reuse_wait_desc column, it stated REPLICATION. I have NO IDEA...

I also switched the recovery model to simple ran the DBCC OPENTRAN (which returned no results), tried to shrink the log, and it is still the same size. Jason

And I have no open old transactions : ran this command DBCC OPENTRAN

Received these results

Transaction information for database 'CareCast'.

Oldest active transaction:

SPID (server process ID): 55

...

I went through the tasks -> backup GUI and ensure truncate the transaction log was checked. It was and I am not able to reclaim any of the 430K...

How do I truncate the transaction log in SS2008? I thought that command is invalid in sql server 2008? Is there any code you could give me for...