Yes, it's still showing partially_healthy.  I had already read where someone's primary and secondary had different synchronization modes, and I checked that.  They are both the same.
We've made this...

I need to patch the server, so I need all availability groups in a healthy status.  All of the other AOAG's on the primary and secondary are in a healthy...

OK.  Thank you for the followup.  I haven't found any documentation for it either, but I was hopeful that someone had found a way to make it happen!

Thanks for the reply.  Yes.I use -K when I connect through a command prompt.   However, I am using Management Studio (SSMS).  -K doesn't work there.

In Management studio SQLCMD...

Thanks for the reply.

The link you listed is a good one and was another site I used as a reference.

What we now have is that 1 out of...

I know this is an old thread, but I also have another possible solution in case anyone else encounters this problem.

We were also getting an odbc connection error on mssqlsystemresources...

That's great. Your calc will do exactly what I need then!

And just because I'm paranoid, I have marked on my calendar to double check this on November...

FROM 2005 BOL: The current UTC time is derived from the current local time and the time zone setting in the operating system

"is derived from the current local...

Thanks for the responding, but maybe I need to make my question clearer.

We use SQL2005.

We are in the central time zone.

We observe daylight savings time.

We need to make...

As per http://msdn.microsoft.com/en-us/library/ms175848.aspx

Displaying Object Names When Viewing Traces

--------------------------------------------------------------------------------

If you wish to display the name of an object rather than the object identifier (Object ID), you must capture the...

Vijay - ah yes, I should have used sql coding. My apologies. Nothing special with the data for this since these queries just run against the system tables....

Oh - thanks for the correction!

Currently we are using Standard. We are talking about upgrading to 2008 Enterprise. I will keep that in mind.

Aeterna - Thanks!

klnsuddu - Take a look at Jeffery's post. Bulk_logged recovery mode doesn't matter with indexing.

To answer your question though - According to BOL (

Thanks everyone for your replies.

We already are checking for the degree of fragmentation (mentioned in step 2). Index is reorged if fragmented < 30% (and > 10%)....

Thanks for the reply, Jeffrey.

I just changed the database owner to sa. That matched up the sids in sys.database_principals and sys.databases.

There were no orphans, since...