william.rees.howells (4/28/2014)

---

I am looking for the easiest way of rebalancing data across multiple files.

Instead of creating a secondary filegroup and then dropping and recreating all indexes in the database...

456789psw (4/28/2014)

---

I have an A & B node set up and running. I now want to add a C NODE.

The catch is the C NODE is in a SQL...

Drop the group and re create it, ensure you note the listener IP address and TCP port first so that you may rercreate it correctly to avoid permanently impacting user...

it might require one before you run the installer if you have a pending reboot.

When installing the new instance it's unlikely to require a...

need a biot more info on the server spec and the resources assigned (such as max mem setting) to the other instances.

Is the instance of sql server a named instance or default instance?

dexdev (4/28/2014)

---

We are looking into setting up a cluster, but we are getting mixes opinions on whether to convert all our individual databases (about 5000) to one big individual database,...

andrew gothard (4/28/2014)

---

Bear in mind, the server you restore to should be exactly the same (version, sp possibly even cu, but I'd not swear to that one) as your old...

karend211 34657 (4/28/2014)

---

I am thinking worst case scenario & want to be prepared & have a plan for...

If you wanted to change the system collation.

karend211 34657 (4/25/2014)

---

I brought up a...

You'll also need to drop any constraints on the columns before you alter them, see books online for more detail

SQL!$@w$0ME (4/24/2014)

---

All,

I have an urgent requirement to implement encryption (Data at rest) for our SQL 2005 instance. Please let me know your thoughts if I can accomplish this through SQL...

are you using shared storage?

in one scenario previously, i had a set of LUNs presented to server A and it turned out they shared storage pools with another server B....

please provide futher info from this file

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140417_191232\Detail.txt

lilywhites (4/22/2014)

---

Each restore in the chain is running using the STANDBY file....i was wondering if we could remove these STANDBY commands and just use it at the end of the...