Re: Replacing Raid5 drives with new drives

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/21/04


Date: Fri, 20 Feb 2004 20:28:10 -0500

As long as the only thing that is one the RAID 5 is the data and or log
files you should be fine with a backup and restore. If the binaries,
systems db's etc are on another array they should be fine. Otherwise you
may have to reinstall sql or restore Master, Model, MSDB etc. You might want
to drop or detach the db before shutting down sql server since if you don't
it will mark the db as suspect when you restart it. Just make sure you have
valid backups and that you have tested them to ensure they restore properly
before you proceed.

-- 
Andrew J. Kelly
SQL Server MVP
"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: Computer problem, need help
    ... defining the three levels of backup and recovery. ... has been corrupted, use backup and restore. ... hard drives and a reliable backup utility like Ghost. ...
    (soc.retirement)
  • Re: Computer problem, need help
    ... Having a backup is often the only solution. ... system restore for software failures ... I found the only one to be 100% reliable was Ghost 2003. ... has problems with SATA drives and perhaps problems with partitioned ...
    (soc.retirement)
  • Re: RAID, SCHMAID.......
    ... And risky to change it later without a full image backup. ... partition, & then restore only the OS, but still verydoable. ... partition before an install of something you havent installed before, ... but so many ppl make a mess of things esp with today's big drives. ...
    (comp.sys.ibm.pc.hardware.storage)
  • Re: Computer problem, need help
    ... >>> defining the three levels of backup and recovery. ... >>> has been corrupted, use backup and restore. ... >>hard drives and a reliable backup utility like Ghost. ... doesn't work I use my preferred backup utility, ...
    (soc.retirement)
  • Re: Computer problem, need help
    ... Having a backup is often the only solution. ... system restore for software failures ... I found the only one to be 100% reliable was Ghost 2003. ... has problems with SATA drives and perhaps problems with partitioned ...
    (soc.retirement)