Any DR solution directly depends on the following.

• Amount data loss that is affordable.

• Maximum downtime of database that is affordable.

• Budget allotted to accomplish this...

Hi,

If you are not expecting answer to interview question, there are many DR plans. Before deciding on anything you ask yourself

• Incase of failure how much data loss can I...

Rebuild must be done in single user mode.

“\Program File\Microsoft SQL Server\MSSQL.1\MSSQL\BINN\sqlservr.exe" -m

Start a DOS box:

C:\> sqlcmd

Restore database master from DISK = ‘\Path of backup file .bak'

Can you post your summary.txt log and also please post detail.log file that is in the same folder.

I would recommend take full backup of live database, create a dummy database restore live database into the dummy DB.

Take total count...

Hi All,

Thanks a lot for posting suggestions, this issue is now fixed without data loss.

There were 5 consistency errors in one system table and one consistency error in one user...

Yes my management is aware of this and we are scheduled this task for tomorrow. I will update you all with the outcome.

Thanks everybody for your time and suggestions...

Yes, we do take log backups every 10 minutes and for my bad we recycle t-logs every 3 days :crying :

Hello Sir,

Thank you for quick response. I do have full backups running every day.

We are getting this consistency errors since two weeks, that means I should be restoring affected...