From Wrox Book " SQL Server Prof admin"

I see the following Info:

Execute the following command on ServerB (which is still the mirror after ServerA becomes unavailable):

ALTER DATABASE <database_name> SET PARTNER...

Also, I am talking about SQL Server standard edition 2008

Thanks Gila, That's good steps what you have given. So last question is When the principal is ready, do we need to do any backup on mirror server and...

These are steps I am thinking..Correct me if anything wrong.

1. Viewing Mirror Information

SELECT d.name, d.database_id, m.mirroring_role_desc,

m.mirroring_state_desc, m.mirroring_safety_level_desc,

...

Thanks All,

So, here is what I understood.

If Server A fails we need to execute the following command on Server B to make it available.

ALTER DATABASE <database name> SET PARTNER...

Thanks Gila. But my question is how to resume the Principal server and make the Mirror server database into Recovering state

Restore verify only with checksum can only be used when the backup file which queried with checksum. If we do not do backup file with checksum, we cannot use the...

When I restarted the server, tempdb - logreuse wait description showing 'Nothing'. So, is this the only way we need to do?

I have a scenario here:

On my TEMPDB, the log reuse wait description shows " Active_transaction".

Then I checked DBCC OPENTRAN('tempdb') . I got message showing there are no open transactions. Then...

oh yeah..forgotten about this...

Anyways now everything working..so I did some DML operations and when I queried on select * from [AuditObjectAccess]..I am not getting pretty precise information of what change...

Thanks for good post..That is whay I would like to go for SQL Server side tracing..

WHERE CAN I FIND "Service Broker GUID of your Audit database?

"

Thanks collen for your immediate info. However, I tried your program on my database. I tried to do some DML operations, but unforutnately I don't see any audit listed...

Collen,

Thanks for your info. Can you provide me the steps to use event notifications and Service Broker to...

You can the following query instead of the one mentioned. I see your query is consuming more cpu which is not good for prod.

Hope you can use my query.

SET NOCOUNT...