Re: Replacing Raid5 drives with new drives

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 02/21/04 

Date: Fri, 20 Feb 2004 20:32:14 -0500

It depends. If your database is the only thing on the drive, I'd just do a
SQL Server backup, drop the database, rebuild the disk array and then
restore from backup. If you have other stuff on the disks, then shut down
all SQL Server related services, backup the disks, rebuild and xcopy them
back. Start up the services and you're done. 

-- 
   Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON   Canada
www.pinnaclepublishing.com/sql
.
"Jim Watson" <anonymous@discussions.microsoft.com> wrote in message
news:135f701c3f812$81854340$a101280a@phx.gbl...
SQL2000. Currently the db's are on a 4 drive raid5.
I want to backup, pull out the 4 drives and install 6 new
drives and config for raid 1+0, then restore the db.
Question: Is it that simple. Any gotchas. Do I need to
detach the db's before removing the drives?
Plan on doing this Saturday night 2/21.
Tks, ...Jim

Relevant Pages

  • Re: Beginning to think about VMware and SCO 5.0.5
    ... faster 15K drives will provide ... I am now gun shy of SCSI RAID: On 6/12 I was called at 19:50 ... the two RAID1 disks in the primary were down ... and the nightly backup was restored to it. ...
    (comp.unix.sco.misc)
  • LVM on raid1: looking to future, RFC
    ... My testing box is an amd64, 1 G ram with dual 80 GB Seagate SATA drives, ... Since I also am changing off-site backup media, ... when my /home needs to expand to other disks. ... I can partition the backup disks: ...
    (Debian-User)
  • Re: The Future of Backing Up & Drobo-like Technologies
    ... to external hard drives, using alternating, dual, incremental backups. ... backup space will be needed in the near future. ... as I've lost disks and data. ... incentive to continue Mac development. ...
    (comp.sys.mac.system)
  • Re: file Backup strategies?
    ... I dont like the program that came with the drive much ... there's another very popular and standard backup program to get? ... I'm not a fan of external backpack disk drives. ... I distrust large disks in tiny, hot, boxes powered from wall warts, ...
    (alt.graphics.photoshop)
  • Re: VAX VMS 7.3, ana/image running out of virtual memory ?
    ... drives, this is less needed, but not unneeded. ... I have a bound volume set (4 dssi disks of 2gigs). ... However while using BACKUP to populate an ISO container file ... %ANALDISK-F-ALLOCMEM, error allocating virtual memory ...
    (comp.os.vms)