HanShi (8/27/2013)

---

When you install a SQL instance on a cluster and as a clustered instance, you first need to create a cluster group for each instance. Because this cluster group...

Placing system dbs on C is not too dramatic as the boot drive it will always be online while the server is up. Obviously tempdb and distribution db should be...

Dont panic, what was the exact command you used?

Get the current paths from sys.master_files and compare them

dokledon (8/25/2013)

---

My question is:

Can I have:

- Node 1: SQL1\Default and SQL2\Default (different/unique SQL VIP Name w/ Default Instance)

- Node 2: SQL3\Default and SQL3\Default

,so It won't be necessary to...

yes the loss of that drive\folder will stop sql server from running, the system database path is where the master database sits and is critical for sql server operation.

You can...

for more info on mountpoints see here[/url]

these may help

alwayson[/url]

alwayson with clustered instances[/url]

BobMcC (8/20/2013)

---

So it looks like you're saying I'm still making things too complex.

Rather than have one file group with files on six LUNS; perhaps have multiple file groups;...

BobMcC (8/20/2013)

---

Thanks Perry.

So in the case of my six luns; I guess the best thing to do is create one FileGroup with a data files on each LUN (of the...

introduce the new node to the cluster and present the storage, then run add node on the new cluster node. Ensure that any validation checks complete successfully before adding the...

Hmmmm, no, that's only really valid for...

anybody wanting the guide please download from this link

Creating a 2 node SQL Server 2008 Cluster Configuration

ArjunaReddy (8/18/2013)

---

Hi,

We have got new space (SAN) allocated recently by storage folks to one of our database server to resolve I/O issues with some specific drives (D: & E:). Inorder...

ananda.murugesan (8/14/2013)

---

I have doubt.. I have Mirror setup manual failover without witness server

If Principal server is down due to N/W or H/W issues, In this cause mirror database condition is...

you can assign any unused port you want but default is 1433.