Hi,

I have not faced the same issue but troubleshooted so many corruption related cases. 

SQL Server error logs will log all the operation performaed on the database. Is it possible for...

Please see the BOL " How to Restore to the point of failure". I think you should restore it with STOP AT clause.

Regards,

Minaz Amin

You can use the profiler trace as back ground process and find out the culprit.

Regards,

Minaz Amin

Is this the exact error message you receive in the error log.

>> Check thr network protocol is enabled ( TCP/IP)

Regards,

Minaz

Thanks Mohammed,

Where to check this ?

Minaz Amin

If you are still not confident of writing the script you can use the backup / Restore wizard.

As directed by MohammedU please check the BOL.

Minaz Amin 

I strongly agree with Steve, As a DBA our primary goal is to save data. Depending on your business requirement you should have different recovery model.

Please make a point :

1) Backing...

What is the recovery model you have ?

1. Backup the transaction log.

2. Shrink it.

3 Create a maintenanace plan to do the backup regularly.

Minaz Amin

Thanks Dinakar.

we decided to do the same as you said, use connection string in the application which will check the domain and redirect it to the respective server.

Have nice day.

Regards,

Minaz Amin

Thanks Mohammed.

Minaz Amin

Hi,

Check the following KB :

http://support.microsoft.com/kb/328306/en-us

Minaz Amin

Before applying the hotfix please take

-> Master / MSDB / User database backup for safety then apply the hotfix.

Minaz Amin

This is a very good KB on connectivity to SQL Server.

http://support.microsoft.com/kb/827422/en-us

Minaz Amin