Viewing 15 posts - 6,241 through 6,255 (of 9,253 total)
Sure, node and disk majority are the default and the easiest to implement, go with what you're comfortable on.
Since your OP raised concerns around the quorum disk and it's sizing...
November 22, 2011 at 11:12 pm
k-335975 (11/10/2011)
I just see the letter of mount point and not underlying disks in the instance list of above counters
you're looking for volumes not disks. They are not actual disks...
November 22, 2011 at 9:25 am
Ok, with the 2 node cluster you would generally look at the disk and node majority. However, if you wish to remove the dependency on the wuorum disk, as I...
November 21, 2011 at 11:12 pm
MSDTC and quorum are metadata drives, they should both be around 1 GB in size. Carve them out of the shared storage, they have no performance requirement.
Depending on the number...
November 20, 2011 at 3:09 pm
Sorry I'm late mate, been out of UK 😉
Came in around SP2 or SP3 IIRC
November 20, 2011 at 6:00 am
The later SQL server 2005 installers have a /passive option for updating passive cluster nodes. Even so, what you have detailed above seems perfectly reasonable.
November 19, 2011 at 6:11 pm
Are you initialising the database before setting up log shipping or during?
November 19, 2011 at 6:06 pm
Tariq-- (11/19/2011)
hello im looking for an expert who can access remotely and setup for me a database mirroing and troubleshoot it for me,
I can offer a daily rate if that...
November 19, 2011 at 5:56 pm
alban_ml (11/19/2011)
problem risolvet ..a login as sa 😀
I would say that's problems just beginning, but that's just me 😉
😀
November 19, 2011 at 4:26 pm
Check out my highly acclaimed 3 part guide for creating a virtual SQL server cluster on this site. It educates the DBA in server, clustering, AD, networking and storage technologies....
November 18, 2011 at 1:09 pm
alban_ml (11/18/2011)
how to chek the error state ?
It's in the SQL server log 😉
November 18, 2011 at 12:13 pm
Most of the organisations I have worked in previously have virtualised SQL servers. Obviously not all SQL Servers are ideal virtualisation candidates, this requires some due diligence.
In my opinion virtualisation...
November 18, 2011 at 11:07 am
Try adding the node using the setup command line install.
November 18, 2011 at 10:42 am
The other option which may be easier for you is to run sp_change_users_login with 'Auto_Fix' and create a matching login for each orphaned database user using a default password. After...
November 18, 2011 at 10:38 am
Ok, but DR typically does not encompass your whole estate, it's meant as temporary failover with core services\applications exposed.
Do you really need to LS everything??
November 17, 2011 at 7:26 am
Viewing 15 posts - 6,241 through 6,255 (of 9,253 total)