pradeep.k 50453 (1/1/2015)

---

Hi,

We are configured the logshipping around 80 gb database.log file growth up to 60 gb .want to shrink the ldf files.what is the best way to shrink file...

ideally reboot as soon as the patches are applied, holding off til the end of the day has never been too much of an issue for me though

why have you configured the instance to use 1434, best practice would be to set a static high range port for the instance

put the clustered DTC resources into the SQL server instances cluster role

full machine backup (system state and app drives)

Yes, if your cluster was a 3 node cluster you wouldnt need a disk based quorum, Majority Node Set would...

ok, that wasn't clear before

SQLKnowItAll (12/30/2014)

---

Do your comments still apply? I.e., In order for the...

matt.newman (12/12/2014)

---

The problem is here that I can't get this one, bigger, more transaction heavy DB to mirror. 27 other databases I can get, but this 1 single DB is...

SQLKnowItAll (12/29/2014)

---

We are building architecture to have 2 FCIs set up in a HAG.

Setup:

Hypervisor = VMWARE

OS = SQL 2012 R2

SQL = SQL Server 2012 Enterprise Ed. (of course)

SAN =...

1433 is the default port, do you havce TCP\IP enabled?

Have you installed a default or named instance?

Yes, a shed load!!!

Really, a simple google search is all you...

The dashboard would be one way, have you looked at this?

saum70 (12/27/2014)

---

Hello,

Previously we used to store sql user logins in registry or xml for our applications(made in C#) to access the database. Now we are proposing that the application be...

nlion84DBA (12/26/2014)

---

Follow on. Found the sequesnce. Pretty straightfoward, eh?

1. Evict the standalone node

2. Install SQL Server

...

Firstly, are both files in the same filegroup??

sextonk (12/23/2014)

---

It is my understanding that is a best-practice. To have multiple data files which are the same size. Performance should be better,...