| TIP: Click on subject to list as thread! | ANSI |
| echo: | |
|---|---|
| to: | |
| from: | |
| date: | |
| subject: | Re: Replace 1 pair of mirrored drives without trashing rest of box? |
From: "Geo."
What OS is it running? I was going to suggest backup the mirror drives to
tape, then switch to your bigger drives and recreate the mirror then
restore. But I don't know if that will work with mirroring enabled, you may
have to break the mirror, backup to tape, switch drives, restore, recreate
the mirror. (I know that works)
That will get you the 36g system partition.
Geo.
"Ellen K" wrote in message
news:e09807.d78187{at}harborwebs.com...
> I am allowed 6 drives for my SQL Server boxes and usually configure them as
> follows:
> 2 drives as a mirrored pair - boot partition goes here and another drive
letter
> for the transaction log
> 3 drives in a RAID5 array - data goes here
> 1 singleton drive - nonclustered indexes go here (and I create a script for
use
> in case this one fails that drops all the nonclustered indexes and re-creates
> them on another drive, so the database can stay up until the bad solo drive
can
> be replaced)
>
> So, the first one I did like this, the singleton and mirrored drives are only
> 18 GB each. (The three RAID5 ones are 72, which is fine.) This is plenty
for
> the singleton for that database, but is really too small for the mirrored
pair
> -- currently the boot partition is only 4 GB and the NT admin says it HAS to
> have a swap file of at least 1.2 GB (I wanted to move the swap file to the
> singleton drive) and my transaction log is about 11 GB by the end of the day.
> I would like more headroom for the transaction log because I'm getting at
least
> 100 net new users by the end of the year so there will be considerably more
> activity, and he says we should have 8 GB for the boot partition because
there
> isn't enough room for applying patches. Also the box is constantly showing
> memory usage at 85% or more -- we are going to add RAM (somehow it only got 1
> GB) but squishing the swap file isn't helping.
>
> I asked whether we could replace the two 18's in the mirrored pair with 36's
> and he freaked. Finally after thinking about it he said he wants to know
> whether if we do this we will screw up anything with the other 4 disks.
>
> And I want to know what else we should be worrying about.
>
> TIA :)
--- BBBS/NT v4.01 Flag-5
* Origin: Barktopia BBS Site http://HarborWebs.com:8081 (1:379/45)SEEN-BY: 633/267 270 @PATH: 379/45 1 633/267 |
|
| SOURCE: echomail via fidonet.ozzmosis.com | |
Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.