Hi,

If you're looking for the tables that hold information about the status of mirroring, there are few...

Hello,

Traditional failover clustering doesn't include any load balancing technologies, it's purpose is to make sure that you'll have service up and running in case one of the nodes has some...

Hello,

If you're adding node to existing SQL Server 2012 cluster it will perform an installation that is identical to your first node, including any directories you have defined. Pretty much...

Hello,

I believe that message is just letting you know that your transitioning from Mirror to Principal role. What happens there is that your Mirror will roll forward the database, how...

Is there a reason you've moved away from Replication? Just because AlwaysOn technologies like Availability Groups are very popular these days it doesn't mean that Replication would be any less...

Hi,

This has been the case ever since SQL Server 2005 introduced database mirroring. You will definitely have problems after a failover, either with not being able to connect to coordinator...

fawad.majid (6/3/2014)

---

hi there

i want to write the script which can Reorganize all indexes in each database and i have 75 servers and every server have 3 or 4 user...

I would suggest that you use your favorite search engine to find "SQL Server...

Hello,

One of the advantages for using the same instance name that I can think of is that if you're using DNS CNAME (or some other IP/name aliasing option) in your...

No problem.

Just follow the instructions behind either one of those links and you should be good to go.

Br,

Mika

Hi,

With properly setup MSDTC the developers probably ment that DTC Network Access should be enabled in your server. You didn't mention what version of Windows you were running.

If it's...

Hi,

One lesson we've learned from our virtualization experiments a way back is, that you should never use virtual hard drives for databases. Always access your LUN directly from the guest...

Hi!

Thank you for...

Hi,

For your question on which one to believe, I would go with Windows Performance Counters and Task Manager/Resource Monitor over 3rd party monitoring software. I have no experience on Orion...

Hi,

How much you see in Total Server Memory counter? That tells you the current memory consumption and Target shows how much the SQL Server will eventually try to use.

It is...