I set up a test box with SQL 2008R2 on it and it works perfectly both ways.

It seems R2 can replicate to 2008, but not from 2008 to R2.

Thank you

Confusing. Do you suggest upgrading to R2?

Thanks Gail, I really appreciate your assistance.

Can you suggest a SQL Recovery tool to try?

Sorry, my mistake. I was led to believe it was a SQL 2008 DB, not 2005.

I'm now working in 2005. I created the dummy DB (same file names and sizes),...

Gail

DBCC CheckDB (HeatCS) WITH No_INFOMSGS, ALL_ERRORMSGS gives me Database 'HeatCS' is being recovered. Waiting until recovery is finished.

My apologies...put it down to blind terror 🙂

Set emergency mode ran ok. It was set to single user too and when I ran set to multi_user, this ran ok too.

Just...

Hi Gail,

Have done exactly as suggested in the link.

Database is attached, but in suspect mode.

This is what I did subsequently, errors included:

1) DBCC CHECKDB (HeatCS, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS

Database 'HeatCS' is...

Do any of there .mdf/SQL recovery tools work? Can anyone recommend anything?

DB came up suspect, was detached and no backups

Hi,

Sorry, I should have been clearer - the db was detached

Hi,

Storage on the server failed. I have the broken .mdf and .ldf files

I created a new database, stopped SQL, substituted new .mdf with old .mdf, deleted the log file and...

Thanks Meghana. I don't know why using aliases works, but it works great

Thanks for the help Folks