reuben.anderson (1/19/2011)

---

We're undergoing an enterprise consolidation and virtualisation project at the moment, and I currently have an external consultant proposing to replace our physical, clustered SQL Servers, with non-clustered VM's...

BigSam (1/19/2011)

---

What edition of Windows & SQL does this article relate to? I would assume Windows Enterprise due to limitations on memory with Standard edition. Will this 3 node solution...

You will need your database administrator to grant this permission for you.

if you're inserting 10-20 million rows you probably do not want the index in place and the table will load faster, however the index creation will take some time

there would need to be a trust relationship between the Forests\Domains

Beth Major-235285 (1/14/2011)

---

I figured it out. Turns out this is easy. Local admins on the server have sysadmin rights from sqlcmd when the database is in single-user mode....

you dont really want to install SSRS on a cluster node as SSRS is not cluster aware. Install it to a separate server and use the cluster for the database...

the MSDTC, like a quorum LUN, only stores logs and configs. I always size it at 1GB for MSDTC and 512MB for a cluster quorum.

It looks very much like you...

you can use the following to update a passive node also from the command line

SQLServer2008SP2-KB92xxxx-x86-ENU.exe /allinstances /passive=1

or

SQLServer2008SP2-KB92xxxx-x86-ENU.exe /instancename = SQLinst1,SQLinst2 /passive=1

This works for SQL2005 SP2 and above 😉

From the SQL Server Licensing Doc

---

When doing failover support, a server is designated as the passive server. The purpose of the passive server is to absorb the data and information...

Fish Man (1/13/2011)

---

Sorry, everyone.

I lost my question.

My question is blow.

I need got all objects script for PROD . but my right is not enough. so I want to apply permession...

it's worth noting that the failover policy usually has a grace of 28 days before requiring licenses. As stated, If you intend to permanently run a SQL Server instance the...

cjohn5552 (1/15/2011)

---

Hey all,

I recently installed 2008 R2 (had 2008 before). There are a number of SQL instances at the company that I work for, and most are referred to simply...

The error 3 leads me to believe that at some point the service account has been modified via services.msc

Check the ms kb article for setting manual permissions, google will help...

ensure all nodes are online and on the node currently owning the resources use sql server config manager to change the username and password for the sql server services, then...