Viewing 15 posts - 7,726 through 7,740 (of 9,253 total)
Tim-153783 (8/24/2010)
When setup correctly, clients will connect to the one server and on failure, immediately reconnect to the other server.
Only if using ado.net or SQL native client can...
August 25, 2010 at 2:10 am
Probably because a cluster with a single node defeats the object of clustering, there is no failover!
August 25, 2010 at 2:01 am
Personally I would issue the following configuration
C: RAID1 (OS & SQL Logs)
D: RAID10 (SQL Data)
E: NORAID (Backup drive)
F: ...
August 25, 2010 at 1:50 am
with only 8 drives available, you are extremely limited!!
August 24, 2010 at 4:43 pm
partitioning, transparent data encryption, data\backup compression, indexed views,online restores, .......etc
Depends on features you are going to need. Chances are if you have managed with 2005 Std so far then 2008...
August 24, 2010 at 4:23 pm
pshaship (8/24/2010)
Hi Perry,You are awesome.
ha ha 🙂 Dude you are too kind!
pshaship (8/24/2010)
August 24, 2010 at 4:14 pm
What version SQL server 2005 are you using?
Has this database been upgraded from a previous version of SQL Server?
Also,
Hawkeye_DBA (8/24/2010)
August 24, 2010 at 2:48 pm
agnnga (8/24/2010)
it is said "Mirroring works faster than clustering" but there weren't any explanation.
This is not strictly true. Failover to the mirror can be slow, it depends on the time...
August 24, 2010 at 2:34 pm
agnnga. (8/24/2010)
As mentionned in the subject, would you tell me what are the differencies (with details) between those technologies in term of performance, broadband and simplicity? Or...
August 24, 2010 at 5:10 am
pshaship (8/23/2010)
Do we need to stop the SQL Server services before applying SP1 in Cluster environment? Because , we have only Single node.
Not normally, no! But a cluster with only...
August 24, 2010 at 4:57 am
just a thought.
Have you tried manually extracting the SP1 to a temp folder on C drive and launching it from there??
execute the following
en_sql_server_2008_sp1_x64.exe /X:"C:\SP1"
Once the files are extracted launch the...
August 24, 2010 at 4:50 am
Taking the SQL server service resource offline will not offline the disks. The installer must be offlining the whole group.
Take the whole group offline before running the installer, not...
August 24, 2010 at 12:53 am
pshaship (8/22/2010)
As i suspected you are using file share quorum.
NO. As you see my Quorum configuration says Node Majority.
:blush: sorry my bad. yes. Was meant to say Node majority
pshaship (8/22/2010)
August 23, 2010 at 9:34 am
if the nodes are close enough then yes, a bit of a crude way but yes. However, your heartbeat network could easily be 2 ports on the network switch that...
August 23, 2010 at 9:20 am
Indianrock (8/19/2010)
Great info!
the info provided is designed to help re create an environment not upgrade it!
August 23, 2010 at 8:53 am
Viewing 15 posts - 7,726 through 7,740 (of 9,253 total)