Marios Philippopoulos (2/27/2014)

---

No, the server itself is unusable; something happened and we are no longer able to even remote-desktop to it.

It needs to be rebuilt and the SQL re-installed. Problem...

When you said A has been corrupted, you mean databases?

the above answer was given by microsoft in the below article--

http://connect.microsoft.com/SQLServer/feedback/details/739013/alwayson-failover-results-in-reseed-of-identity

what exactly he meant by performance of identity column or sequence column will be affected?

have you tried giving the network location like \\servername\D$\SQL2K8DATA(UNC path). Try this and let us know if it worked or not ?

Perry,

Just to let you know...

If you require the same identity generation semantics as previous versions of SQL Server there are two options available:

• Use trace flag 272

o This will cause...

Perry Whittle (2/23/2014)

---

It forces identities in sql server to behave as it did in previous versions. The trace flag is added to the service startup list to persist it on...

I did check on that one. But what would be the...

This is by design. This job by default runs every 10 minutes. How big is your distribution database? If possible try to schedule the job to every 30 minutes. Usually...

About the identity column, I just truncated the table on pricipal and inserted few rows and failed over to the other server. When i started inserting the rows again the...

any suggestions?

YES, SQL server gets restarted when you failover to the other node.

Hi ,

Do we need to apply CU after we apply Service pack SP2 for SQL server 2008 R2 servers?

How to check for SQL server security patches?

I am facing the following issues while setting up alwayson.

1) Not able to set the listener to the alwayson group. Error--

The WSFC cluster could not bring the Network Name...

Thanks a lot Perry !!

Thanks a lot Perry !! I am also having trouble to understand what exactly the alwayson availability group listener is ? What this is used for? Does it acts as...