Re: What should I Do?
From: Cinderella (Cinderella_at_discussions.microsoft.com)
Date: 09/27/04
- Next message: Diane: "RE: URGENT!!! cant start sql service"
- Previous message: ChrisR: "Clustered Index Question"
- In reply to: Geoff N. Hiten: "Re: What should I Do?"
- Next in thread: Mike John: "Re: What should I Do?"
- Reply: Mike John: "Re: What should I Do?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 27 Sep 2004 14:03:04 -0700
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!
> >
>
>
>
- Next message: Diane: "RE: URGENT!!! cant start sql service"
- Previous message: ChrisR: "Clustered Index Question"
- In reply to: Geoff N. Hiten: "Re: What should I Do?"
- Next in thread: Mike John: "Re: What should I Do?"
- Reply: Mike John: "Re: What should I Do?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
