Viewing 15 posts - 541 through 555 (of 4,745 total)
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.
July 17, 2013 at 8:57 am
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...
July 17, 2013 at 6:50 am
is this 32bit, if so thats all the memory you will get unless you set the /3Gb flag in the boot.ini
July 16, 2013 at 2:45 pm
peacesells (7/16/2013)
george sibbald (7/16/2013)
You...
July 16, 2013 at 9:27 am
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)
July 16, 2013 at 8:44 am
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...
July 16, 2013 at 5:18 am
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...
July 16, 2013 at 4:04 am
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
July 15, 2013 at 3:57 pm
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...
July 15, 2013 at 3:29 pm
DHeath (7/15/2013)
July 15, 2013 at 8:22 am
the checkdb will give you the corrupted object names
July 15, 2013 at 5:54 am
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...
July 15, 2013 at 5:34 am
imran.adam (7/15/2013)
george sibbald (7/15/2013)
select OBJECT_NAME(632864)Sorry that did not work, it came back with NULL
it would work for a valid id. Just wanted to show you a quick way to resolve...
July 15, 2013 at 5:29 am
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...
July 15, 2013 at 5:24 am
Viewing 15 posts - 541 through 555 (of 4,745 total)