Viewing 15 posts - 7,711 through 7,725 (of 9,241 total)
Bradley B (8/25/2010)
Mirroring requires Enterprise Edition.
Mirroring requires Standard or Enterprise editions of 2005\2008
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 6:47 am
christerst (8/25/2010)
Is it possible to make several clustered instances share the same logical disks?
No, that's not how clustering works. Separate storage is required for each instance and ultimately its...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 6:36 am
are you connecting to the database engine with SQL Server or Windows authentication?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 6:28 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 2:10 am
Probably because a cluster with a single node defeats the object of clustering, there is no failover!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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: ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 1:50 am
with only 8 drives available, you are extremely limited!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2010 at 12:53 am
Viewing 15 posts - 7,711 through 7,725 (of 9,241 total)