about the only use for multiple log files would be the following type of scenario

You have your database log file on drive D:

The drive runs out of space

You have free...

fail.gary (4/6/2011)

---

Instance | Server1 / Server 2

A Active / Passive

B Passive...

personally, i still prefer a freenas or openfiler VM for the virtual storage for my virtual systems

build the clustered instance on your new hardware and migrate the databases across to the cluster from the stand alone machine

what does the following return when executed against the sql instance

SELECT

SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS PhysicalNodeName,

SERVERPROPERTY('ServerName') AS ClusteredInstName,

SERVERPROPERTY('IsClustered') AS IsClustered

Windows 2003 or 2008 cluster?

firstly confirm that both nodes can communicate with each other over public and private connections.

What has changed since the passive node was operational, check your change...

You're welcome

only the master database and the error log location are held in the registry along with default data and log and backup paths. Tempdb location is taken from the master...

no, i put "" around the url which is ok for Safari but IE doesnt like it :crazy:

should be now

Windows 2008 clusters no longer use a domain account it runs as local system.

See the following KB from Microsoft for further info

Yes, pretty much or alternatively

As i said if you have SQL Server 2008 central management server...

my apologies i have fixed the link now

M.Kahn (4/3/2011)

---

I have a group in AD that logins to windows and what i want to do is, the same AD group to access also SQL Server using the AD...

How many filegroups\files do you currently have in use for this database?

Toothpicker (4/3/2011)

---

I have the same issue. Anyone who found the efficient way...