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

Native compression is good but if you enable TDE compression is negated. Litespeed or SQLBackup will compress and encrypt your backups

Duran (1/4/2011)

---

Hello,

I had a SQL 2008 R2 cluster ticking along nicely, but then AD corrupted. The network guy recreated AD and all the nodes had to be taken off the...

You do realise that this thread is nearly a year old 😉

Only SQL2008 onwards 😉

No problem, glad I could help.

BTW, happy year.

No problem, glad you found this useful.

m--S3qU3L (1/2/2011)

---

I believe the failure of SQL Server 2008 RTM (Kerberos issue) pops up when we install SQL server...

gttred (12/27/2010)

---

Hi,

I have been assigned to install SQL on a cluster by my boss. Where should the dlls, data file and log file be installed. It is connected to SAN....

sknox (12/28/2010)

---

Therefore some of us have not.

In the interest of sating my (perhaps...

.