Viewing 15 posts - 7,711 through 7,725 (of 9,244 total)
The thing is, in a multi node cluster the passive nodes are patched. The passive node has no active disk resources so it should only ever choose the C drive,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 2:00 pm
I have compared these before and there seems little difference. You can check the comparisons at these links
http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx#scalability
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
There are some items in Enterprise only but they werent there in 2005...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 9:00 am
hmm, can't see anything wrong there. At this point i think i would be tempted to stop the ArcSDE services that use the sde user and do the following
1/ Drop...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 8:49 am
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
Viewing 15 posts - 7,711 through 7,725 (of 9,244 total)