do you intend to remove the primary and all secondarys?

RUNNERSQL (1/24/2015)

---

i have created a new login in principle server and provided dbowner permission to principle db.

how do i transfer this login to mirror server and assign the same permission...

which edition\version of sql server are you using?

done this before a few times, i have used a new cluster with its own storage and mighrated databases between clusters.

Leaves a you a rollback scenario in place

also read the doc at the following link

https://msdn.microsoft.com/en-us/library/gg981694.aspx

there is a patch to enable 15000 partitions what is your exact sql server edition\version?

johnnyrmtl (1/25/2015)

---

K great... Although I do have to install this FCI tomorrow and wanted to understand it as much as possible by then as to not start it over.

Any draft...

yes level 5 is to be published on 11th feb

Levels 1 to 4 detail the requirements for a windows server failover cluster, this forms the basis of either an FCI or an AlwaysOn Availability group setup.

Level 5 details FCIs...

johnnyrmtl (1/24/2015)

---

I am somewhat confused as the guide for an " AlwaysOn Failover Cluster Instance" mentions the creation of "Availability groups".

If my application is constantly creating new databases, do I...

the cert should only require creating once, is this a backup of the same database or another?

Has the cert changed on the source server maybe and now doesn't match the...

chucking in SSDs will just probably mask the real issue. SSDs are indeed faster than traditional disks but even they have a limit.

It's been said already, code and database design...

see my stairway series on this site starting at this link[/url]

What is it you're looking to achieve, high...

check everything, the networking between the nodes, the networking between the domain controller and the node, also the permission level of the user running the add node operation