smtzac (10/23/2014)

---

I already have a service account created in Logins: SQL\SVC.

---CREATE ENDPOINT <endpoint_mirroring>

STATE = STARTED

AS TCP ( LISTENER_PORT = 7023 )

FOR DATABASE_MIRRORING (ROLE=PARTNER)-----

If I run above script, I think,...

before you even consider alwayson groups do you actually have the appropriate windows server and sql server licences?

another newbie (10/23/2014)

---

I managed to get it working by following the suggestion about backing up the db and then restoring it - you get the option to rename the mdf/ldf...

i'd love to help more but it's not entriely clear what your issue is

what command did you use to backup and restore the cert?

smtzac (10/23/2014)

---

Where do I put service account name and how?

CREATE ENDPOINT <endpoint_mirroring>

STATE = STARTED

...

You can still use the wizard if...

Have you run a full backup on the primary since LS...

Duran (10/22/2014)

---

Hi George,

Thanks for getting back. I'll see if I can try that.

Perry, my error is as follows

Cannot open backup device G:\SQLBackup\dbname.bak. Operating System error2(failed to retrieve text for this...

fantom (10/22/2014)

---

It's a two node Windows Failover Cluster. However, it doesn't appear to be a sql server cluster. Do I have to rebuild as a sql server cluster...

Once you understand the first comment the rest gets easy 😉

To re cap, An AlwaysOn Availability group across 2 Failover Cluster Instances of SQL...

How many nodes in the cluster?

Who installed the current instance?

Add node is only used once you have run the New failover cluster instance wizard.

Each new clustered instance needs its own...

what errors do you see in the error log?

What detail does the wizard dispaly, click the error hyperlink for more detail

pawana.paul (10/20/2014)

---

I have question related to this topic.

I want to have 2 node cluster. Node 1 will have instanceA, Database ABC, Node 2 will have instanceB, Database ABC. Can I...

Biank (10/21/2014)

---

Hello,

I'm wondering if I can take native SQL log backup in addition to DPM backups. We're using DPM for both databases (daily) and logs (every 15min). So,...

Firstly, it's...