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...

ensure all nodes are online and use SQL Server configuration manager to change the account and\or password. The cluster service should handle the rest.

Reefchief (12/30/2010)

---

Cloned PRD environment to DEV, and after renaming the server, etc. I'm seeing that the SQL Agent jobs are being run from/on PRD. Also, if I delete or...

path and filename of the database or path and filename of the backup file generated by the backup process?

Are your databases backed up natively or using a 3rd party product?

its a fair amount of work, but possible. What is your level of knowledge on SQL Server?

Hi Ankur

i always produce full graphical documentation using Visio. The document details all node details and disks, etc. It provides an "at a glance" view of the current configuration, even...

Donalith (1/7/2011)

---

Ok, thanks everyone. It was an accidental conditional delete on some 26 rows on a relatively inactive table. It made more sense, I guess, to do a full restore...