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,...

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...

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...

Mirroring requires Standard or Enterprise editions of 2005\2008

No, that's not how clustering works. Separate storage is required for each instance and ultimately its...

are you connecting to the database engine with SQL Server or Windows authentication?

Only if using ado.net or SQL native client can...

Probably because a cluster with a single node defeats the object of clustering, there is no failover!

Personally I would issue the following configuration

C: RAID1 (OS & SQL Logs)

D: RAID10 (SQL Data)

E: NORAID (Backup drive)

F: ...

with only 8 drives available, you are extremely limited!!

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...

ha ha 🙂 Dude you are too kind!

pshaship (8/24/2010)

---

But still I would like to know the reason why SP1 is unable to extract files...

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)

---

However, in the database the user shows Disabled, which it...

This is not strictly true. Failover to the mirror can be slow, it depends on the time...

agnnga. (8/24/2010)

---

Hello to all,

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...