Are you referring to the source database??

Mac1986 (11/4/2012)

---

But wait a min the how can I...

What is the failure message in the sql server error log?

Have a read through this

Books online should tell you all you need. Have you had a look on google. I seem to remember there was a whitepaper from Microsoft on the HA technologies.

Once you...

scogeb (11/2/2012)

---

That is intersting. When I run that query, I get no results. When I take out the where clause, I see that the only class_desc of Endpoint...

The mirroring wizard states

Database Mirroring Wizard

---

For SQL server accounts in the same domain or trusted domains, specify the service accounts below. If the accounts are non-domain accounts or the accounts...

How are the disks presented to the OS, (iscsi, fibre channel, local raid,etc)?

Furthermore, the script targets files with ".ldf" extension. What happens if a DBA creates a database and gives one of the data files on a database the ".ldf" extension 😉

At...

OK, you're joking right??

Firstly, TRUNCATEONLY does not apply to T-log files!

A wholesale shrink of all log files on the instance, and you believe this will be beneficial?

What do you do...

runal_jagtap (11/1/2012)

---

Ok fine.. willl see to it 🙂

thank you everyone for quick response n help 🙂

I will like to add one more thing

We have one Rack Space server & other...

runal_jagtap (11/1/2012)

---

Thanks Gila, but reagrding SQL SERVER Error Log, will this will a file stored on any location???

coz if DB wont start how to check Error logs then??

More over coming...

can you supply the results of this query please against primary and secondaries

selectar.replica_server_name

, ar.endpoint_url

, ar.replica_server_name

, ar.availability_mode_desc

, ar.failover_mode_desc

, ar.session_timeout

, ar.primary_role_allow_connections_desc

, ar.secondary_role_allow_connections_desc

, ar.backup_priority

, ar2.read_only_routing_url

from sys.availability_replicas ar

inner join sys.availability_read_only_routing_lists avr

on ar.replica_id =...

you're welcome 😉

check your event logs for more info, there'll be some errors there that will be relative.

normally stopping and restarting the endpoints will cure the issue

SQLSACT (10/31/2012)

---

Perry Whittle (10/31/2012)

---

SQLSACT (10/31/2012)

---

Hi Guys

Please help me understand something the Cluster Quorum and specifically Node and Disk Majority

I understand that if you have an even amount on nodes on...