Yes, our issue was fixed.

I don't remember exactly what I did, but I believe I did one of the following :

Click "Resume data movement" again

or

go to the secondary replica, point...

After clicking "Resume data movement" and click OK, the database shows success, but "Updating Object Explorer" error out with the following error message:

A timeout occurred while waiting for the operation...

I tested extended events and it works the way I want. But is there a way to incorporate it into SQL Server Auddit so that I can enforce it as...

1) I already know.

2) I haven't use this tool before.

Meanwhile I welcome others to comment that had the same errors as I have.

BTW, our cluster is Windows Cluster and not SQL Cluster.

Another piece of info I'm providing: recently we applied Windows Update to our secondary node (we have Availability Group in a clustered environment) and then applied the same Windows Update...

You got it right on my hair color 🙂

Version:

Microsoft SQL Server 2012 (SP1) - 11.0.3381.0 (X64)

Aug 23 2013 20:08:13

Copyright (c) Microsoft Corporation

Enterprise Edition (64-bit) on Windows NT 6.2...

I couldn't find it and that's why I'm asking here.

Thanks. I reposted under "SQL Server 2012 - General" with the topic as "DBCC CHECKDB - snapshot error".

Hi Gail,

We run DBCC CHECKDB as a job in the evening when there is less activities. All the jobs are run with a domain account that have local administrator rights....

Thanks for quick reply. Does it matter if I shrink at peak or off-peak hour?

What do you mean by once-off?

What do you mean by once-off?

I just found out that if no "role members" is selected in a group, even if the group exists, it won't show the group.

Thank you so much for your input.

Lowell,

When I ran the (first) SQL statement in a specific database, for some reason, it doesn't show all the users.