How to recover SQL server 2005[Standard] Data base in suspeect mode its produciton

Question

How to recover SQL server 2005[Standard] Data base in suspeect mode its produciton

naga.rohitkumar

SSCertifiable

Points: 5738
More actions
September 19, 2014 at 2:40 am

#150182

Hi all ,
SQL server 2005[Standard]
Data base in suspeect mode its produciton and it runns 24/7 no down time will be provided dataloss
how can we recover this 2tb of database with out data loss
can any one please mention the things in detail
Thanks
Naga.RohitKumar
Thanks
Naga.Rohitkumar

Viewing 8 posts - 1 through 7 (of 7 total)

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

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

To recover without data loss, restore your last full backup and all log backups since that backup. Since the DB is so critical, I assume you must have those backups.

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

naga.rohitkumar SSCertifiable Points: 5738 More actions · Answer 2

Can u please mention how To recover 2tb of database it will allow loss in millions of rupees and no one can able to access db untill the db becomes online bcoz while restoring 2tb of backup it will take so much of time

Thanks
Naga.Rohitkumar

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

Fail over to your DR server.

You do have a DR server, given that the system is so critical that downtime will cause the loss of millions of rupees?

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

naga.rohitkumar SSCertifiable Points: 5738 More actions · Answer 4

Hi Gail ,,

it intresting now its a SQL Server 2005 Standard edition

There is no DR server no logshipping no mirroing no replication it has only cluster with Active /Passive enviroment

Thanks
Naga.Rohitkumar

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

If you have no DR server, then yes, the DB is down until you can finish the restore. No way around that. That's why critical servers should have HA/DR plans, so that there isn't massive downtime and financial loss when something goes wrong.

Is this also a scenario which the previous DBA has given you to solve?

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

naga.rohitkumar SSCertifiable Points: 5738 More actions · Answer 6

Yes can you please make me in figuring out

Thanks
Naga.Rohitkumar

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

Surely he expects you to figure it out by yourself? Are you going to tell him, when you present the answers, that they were given by other people?

Anyway, I already answered this one.

GilaMonster (9/19/2014)
To recover without data loss, restore your last full backup and all log backups since that backup.

GilaMonster (9/19/2014)
If you have no DR server, then the DB is down until you can finish the restore. No way around that.

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