Thanks.

But I have tried to keep the database in suspect mode and set the alert severity to 23 but I couldn't get any alert.

In event eveviewer, I can see serverity...

Thanks. This was already fixed.

Both Primary and Secondary are running under same service account.

Windows administrator changed the password for the service account running on Primary and missed to change for...

Can someone please help me out?

Thanks and Regards,

Ravi.

Thanks. but it's not possible to take another backup as database is in loading state.

Regards,

Ravi.

Thanks Ashish.

1) If I have performed index rebuilding on one table in logshipped database/Primary database, will it effect the same to secondary database or do we need to again index...

Thanks a lot for your kind reply 🙂

Regards,

Ravi.

Thank you all for your kind replies 🙂

Regards,

Ravi

Thanks Ashish.

But how can I come out from this situation?

Is data after 1200 lost or is there anyway to get the data or how can I restore the Logbackup_201103111215.trn &...

Thanks avinashily.

Then, we can configure logshilpping in SQLServer2005 without IIS and it will work fine..rite?

Regards,

Ravi.

Thanks very much for your valid responses.

Could you please advice for the below questions as well.

1. How many users connected to SQLServer?

2. How many processes are currently running?

Regards,

Ravi.

Thanks for your reply !!

Can anyone advice how to check the user who is running the query?

Regards,

Ravi.

Thanks for you reply !!

Regards,

Ravichandra.

Now my doubt is cleared out.

Thank you all for your help !!

Regards,

Ravi.

Thanks Mahesh.

Yes, RTM is prior to Servicepack 1.

But in the below link, I can see " Microsoft SQL Server 2005 Service Pack 4 RTM" as it's confusing me what RTM...

Thanks Mahesh.

Can I get answer for my question also please?

" In this " Microsoft SQL Server 2005 Service Pack 4 RTM " , what RTM is refers? "

Regards,

Ravi.