Re: What should I Do?

From: Cinderella (Cinderella_at_discussions.microsoft.com)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 14:59:02 -0700

If the c:/ and d:/ were really on seperate physical disks then would it then
make a difference of where I had the program files? Am I correct to think
that it then makes more sense because if something happened to d:/ and that's
where the data is that I would just need to recover the data but not
reinstall sql server because it was still safe on c:/?

Now with the set up I have now shouldn't I be fine with this one disk that
everything resides on because it is mirrored....plus my backups are backed up
yet again each night to tape. So it's I have mirrored disks plus I have a
second set up backups somewhere else?

"Mike John" wrote:

> Having the program files on C is no more correct than anywhere else, so I
> really would not bother moving them back. I would be far more concerned
> about recoverability of data and performance from having logs and data on
> same discs.
>
> Mike John
>
> "Cinderella" <Cinderella@discussions.microsoft.com> wrote in message
> news:3DEE92D3-D2EB-47A8-B733-A0C9C43CA331@microsoft.com...
> > So basically I should leave the configuration as it is?
> > My thought was that I should move the program files back to the C:/ drive
> > where it should've originally been installed. Esp that going forward if
> > someone else takes over the server then it's been set up properly.
> >
> > If I do decide to move it back what is the best way to do this? Is there
> > a
> > way with out taking the server down?
> >
> > "Geoff N. Hiten" wrote:
> >
> >> Moving files around on partitions will have no impact on performance,
> >> reliability, or recoverability if the are all partitions on the same
> >> physical disk or disk arrays.
> >>
> >> --
> >> Geoff N. Hiten
> >> Microsoft SQL Server MVP
> >> Senior Database Administrator
> >> Careerbuilder.com
> >>
> >> I support the Professional Association for SQL Server
> >> www.sqlpass.org
> >>
> >> "Cinderella" <Cinderella@discussions.microsoft.com> wrote in message
> >> news:6B8D9363-C55F-40FC-A92F-A31E21F347C8@microsoft.com...
> >> > Ok so I have some servers that have the program files and the data
> >> > files
> >> all
> >> > on the same Drive. ...that would be the D:/ drive.
> >> > But I came to find out that the C:/ drive and the D:/ drive on these
> >> servers
> >> > are just partions from the the same actual physical drive.
> >> > Also came to find out that all servers have mirrored drives. And if
> >> > there
> >> > is a server that happens to have it's C:/ and D:/ on actual seperate
> >> physical
> >> > drives. Then the D:/ drive is again mirrored.
> >> >
> >> > So here's my question. Because the program files and data files are
> >> > installed on the same drive would it be worth it to try to seperate
> >> > this
> >> so
> >> > that the program files are where they should be on C:/ drive regardless
> >> that
> >> > it's just a partition off the same physical drive or because they are
> >> > just
> >> a
> >> > partition and they are mirrored is it okay to just leave it?
> >> >
> >> > I also know that having seperate drives for each program
> >> > files/data/logs/backups is ideal but this isn't how the configuration
> >> > is.
> >> > Right now all is on the D:/ partition.
> >> >
> >> > If I should be moving back the program files from D:/ to C:/ regardless
> >> that
> >> > it's just a partition what is the best way to do this? I'm assuming
> >> > that
> >> > just by moving it by dragging in program files is not the best way.
> >> >
> >> > Thank you!
> >> >
> >>
> >>
> >>
>
>
>

Relevant Pages

  • Re: For OS 10.4, do I need to have a 3rd party application do HD maintenance?
    ... >> I paid my Mac dealer about ... and they managed to recover all. ... Disks fail. ... the contractor was supposed to have backups, ...
    (comp.sys.mac.apps)
  • Help! I lost my life (Again)!
    ... In the matter of fact I used that HD to hold old backups from ... I have asked for quote to restore some folder from the HD from an UK based ... the prelim quote was 275 UKP (I only asked to recover on directory ... and it holds also copies from at least 2 older hard disks. ...
    (comp.arch.fpga)
  • Re: [SLE] Machine Building - Nightmare Alley - Compatibility and Upgrade
    ... On the other side I've been using Gigabyte boards with SuSE for years no ... graphic cards as the server terminal stays in text mode anyway. ... > department) that I will have to install their SuSe 9.1 distribution from ... Disks have a limited life time... ...
    (SuSE)
  • Re: Unix runs faster, maybe (was: Re: Educating potential VMS users)
    ... That's what I just suggested, Kerry: they're limited by disk I/O, not CPU, and hence CPU utilization *will* be low, even if the disks are working their little tails off. ... A server with very low CPU utilization is a *good* candidate for virtualization, since it's got lots of horsepower left over for other tasks that admins might be reluctant to run on the same OS instance: just hook up some more disks to service the added applicationand let 'er rip. ...
    (comp.os.vms)
  • Re: Lan server disaster recovery
    ... > second pc and have the server up in a few minutes. ... put the user disks in an appropriate RAID configuration. ... hot-server and then do backups from that system. ...
    (comp.os.linux.networking)