SQL 2005 DB recovery

Question

Post reply

SQL 2005 DB recovery

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

anilambedkar (7/16/2010)
the recovery model of the DB is Simple

Then there's no chance for point in time recovery anyway. You can't take log backups in Simple recovery.

is there any way to downgrade and recover from LOG explorer.

No. SQL databases cannot be downgraded.

If the apexsql can do it then there should be some way we can do it.....

You could try to read the log manually, but it's not intended to be human-readable and it's very hard to interpret. (DBCC LOG...)

There's a reason the log readers are expensive - they're doing difficult things.

Which is going to cost the company more? The log reader ($1000) or losing all that data, the client's confidence, the business that will go elsewhere, etc?

I also suggest that you speak to your manager ans explain that this could have been completely recoverable had there been a knowledgable DBA on staff responsible for the databases.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

anilambedkar SSC Enthusiast Points: 170 More actions · Answer 2

thanks a lot Mr. Gail

Last question on this...........

If the DB was in FULL Recovery mode........... and if they had copied.. .mdf and .ldf files to some other location.

is there any chance of recovering it...........

Last one please.......

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Full recovery and completely lost both mdf and ldf?

Only if there was a full backup at least, preferably full and log backups.

Bottom line. No backups, no recovery.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

anilambedkar SSC Enthusiast Points: 170 More actions · Answer 4

thanks a lot.... for... getting back on that one.... ???

When I have checked the database.............. today

it is actually "in full recovery mode" and it's compatibility version is SQL 2000 (80)

It was created on SQL 2000 and now the server was upgraded to SQL 2005

I am able to recover the log ..... using some Apex SQL 1.86 Version for 2000 server DBs