sorry that would take more time than i have and we cannot be totaly sure memory is the main problem. Maximise the memory you do have available to you first.

just set the /3GB switch in the boot.ini and get the server restarted.

See how that helps and take it from there, you may well still need to look at and...

is this 32bit, if so thats all the memory you will get unless you set the /3Gb flag in the boot.ini

peacesells (7/16/2013)

---

george sibbald (7/16/2013)

---

each node with two instances gives you 4 instances, and that is very much active\active, or as I believe Microsoft would officially call it, a multi-instance cluster.

You...

local accounts will not be able to communicate across the network, i.e to file shares or other SQL server instances (for instance for mirroring or log shipping purposes)

each node with two instances gives you 4 instances, and that is very much active\active, or as I believe Microsoft would officially call it, a multi-instance cluster.

You will have to...

following on from what Perry said if you do in fact truly need up to the minute reporting you may need to look at transactional replication, its the only option...

is the database put into single user mode or is the option to backup the tail of the log selected? both would cause this error

@DHeath

my feeling at the moment is we have a misunderstanding of clustering rather than a cluster issue, seems a bit early to start advocating rebuilding it. 🙂

@peacesells

SQLAgent jobs are held...

DHeath (7/15/2013)

---

...I have usually found that depending how far along you are in this set up..meaning production or still setting it up,its easier to completely rebuild the cluster than to...

the checkdb will give you the corrupted object names

check also the minimum repair level checkdb reports.

If its a non-clustered index that turns out to be corrupted you may be able to just drop and recreate it.

Do you have...

it would work for a valid id. Just wanted to show you a quick way to resolve...

clusters use shared disks, there is only one copy of all the databases, connect to them using the virtual sql instance name (thats why its called virtual, it sits above...

select OBJECT_NAME(632864)