Grant Fritchey (11/7/2013)

---

In what might be an epic role reversal, don't you mean RESTORE...

Ryan007 (11/11/2013)

---

Thanks Perry

But disk might get full due to huge transactions. So to prevent this, is there anything that can be done so that LUN does not go offline if...

Reg_Mayfield (11/8/2013)

---

When I stepped thru the process on the first server (Primary server) when I got to the dialog screen that asked for "Select Servers or a Cluster" I am...

at the Netapp filer level if the LUN space depletes the LUN goes offline, this in turn will take the disk offline in Windows.

That is correct

muthukkumaran Kaliyamoorthy (11/8/2013)

---

I did some online searching. Here is the step I have to perform. Am I missing anything.

> Need a Shared disk

> Need a Third server/node

> create a new...

No, you dont...

anoop.mig29 (11/7/2013)

---

Perry Whittle (11/6/2013)

---

A port in the high end range is usually good, say 50000 - 60000.

Where firewalls are in place and you wish to connect via the instance name...

muthukkumaran Kaliyamoorthy (11/7/2013)

---

I have a 2 node cluster (2-physical servers) “instance1” is passive for “instance2” & “instance2” is passive for "instance1" vice versa.

I want to add/install 3rd SQL “instance3”....

you can use a single one, it's probably easier to store the mapping files with the VM. I have done this in the past.

If your procedure only accepts a scalar value why are you dumping the value provided to the sp into a cursor looping through sys.database_principals??

A port in the high end range is usually good, say 50000 - 60000.

Where firewalls are in place and you wish to connect via the instance name you'll need the...

You must grant share permissions on the share itself and ntfs permissions on the folders\files. Where the 2 combine the most restrictive applies, this is the default when creating a...

yes i see what you mean, the following shows correctly the server role members but probably shouldnt be granted to ordinary users

grant VIEW ANY DEFINITION TO [youruser]

You could use a manual log backup instead of a differential and restore WITH NORECOVERY, MOVE.

The easiest option...