Showing posts with label drives. Show all posts
Showing posts with label drives. Show all posts

Thursday, March 22, 2012

A complete uninstall of SQL 2005

I recently re-built my entire system from ground up (new hard drives, OS, etc). I now have the problem of SQL 2005 installed partially, but no way to get the management tools installed. I get an "already installed message when I try". I've never encounted this before on any other SQL install.

Sequence of events. I installed VS 2005 Pro first, then followed by SQL 2005. Somewhere this install didn't work, and I was left with the MS installed thinking I suceeded, yet none of the functions of SQL were worked or more importantly accessable.

I tried to re-install after using the ADD/Remove App from the control panel (which was sucessfull). SQL thought it was still installed. So I uninstalled VS 2005 as well, and deleted any programs in the SQL directory. Then I checked ADD/Remove programs and nothing was showing. The re-install still did not work. My guess is that the registry is still loaded with now useless entries.

Is there any solution left that does not require me to hand delete any SQL registry entries, since that is always a great way to completely kill my system.

Thanks.

Please send email to me and I will forward a script to clean those installed components.

Thursday, March 8, 2012

64-bit Windows/64-bit SQL - External Drives

Hi,
I read in the SQL 2005 Exam guides for clustering that (p.283 - 70-443),
that if building a cluster on 64-bit Windows then must use Fibre drives?
I'm trying to verying this with help of Google/MSDN, and not found
confirmation anywhere.
Is this the case that running a cluster on 64-bit editions places these
restrictions on hardware?
If we want use 64-bit clustered system, are we basically forced to accept a
fibre-based SAN as I/O system?
Thank you.
CraigYour hardware for Cluster must be in the Hardware Compatibility List. Check
out the following site:
http://support.microsoft.com/kb/309395
--
Ekrem Ã?nsoy
"craig_amtdatatechnologies@.discussions.mi"
<craigamtdatatechnologiesdiscussionsmi@.discussions.microsoft.com> wrote in
message news:25BEEEE9-2C79-4377-83D5-CAA0574273B2@.microsoft.com...
> Hi,
> I read in the SQL 2005 Exam guides for clustering that (p.283 - 70-443),
> that if building a cluster on 64-bit Windows then must use Fibre drives?
> I'm trying to verying this with help of Google/MSDN, and not found
> confirmation anywhere.
> Is this the case that running a cluster on 64-bit editions places these
> restrictions on hardware?
> If we want use 64-bit clustered system, are we basically forced to accept
> a
> fibre-based SAN as I/O system?
>
> Thank you.
> Craig
>

Thursday, February 16, 2012

5 hard drives

On a server with 5 hard drives, I presume a 2-drive raid-1 and a 3-drive
raid-5 (each 146gb) would be the appropriate config.
The user databases only take up 10-20GB.
This is for a very busy web site, so maintasks are reading and fulltext
search.
What would you recommend locating on the raid-1 as well as the OS?
Thanks SOC.If it's really a busy system, then you should seperate the TLog and Data
files of the database. You should locate the TLog on a RAID1 and locate the
data files on a RAD10 if possible, if not then RAID5.
Locate your OS and SQL Server binaries on a RAID1 so in this case, you'll
need 2 more disks :)
--
Ekrem Önsoy
"SOC" <zxc1@.hotmail.com> wrote in message
news:uXNvyrADIHA.972@.TK2MSFTNGP05.phx.gbl...
> On a server with 5 hard drives, I presume a 2-drive raid-1 and a 3-drive
> raid-5 (each 146gb) would be the appropriate config.
> The user databases only take up 10-20GB.
> This is for a very busy web site, so maintasks are reading and fulltext
> search.
> What would you recommend locating on the raid-1 as well as the OS?
> Thanks SOC.
>
>|||Consider placing the transaction logs and tempdb there. HEAVY writes, which
suffer on RAID5. Your mostly-read application 'should' be ok on the RAID5.
--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"SOC" <zxc1@.hotmail.com> wrote in message
news:uXNvyrADIHA.972@.TK2MSFTNGP05.phx.gbl...
> On a server with 5 hard drives, I presume a 2-drive raid-1 and a 3-drive
> raid-5 (each 146gb) would be the appropriate config.
> The user databases only take up 10-20GB.
> This is for a very busy web site, so maintasks are reading and fulltext
> search.
> What would you recommend locating on the raid-1 as well as the OS?
> Thanks SOC.
>
>