Re: What should I Do?
From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 09/27/04
- Next message: Aaron [SQL Server MVP]: "Re: Setting "Maximum characters per column" in TSQL"
- Previous message: Johnny Silvestre: "Setting "Maximum characters per column" in TSQL"
- In reply to: Cinderella: "What should I Do?"
- Next in thread: Cinderella: "Re: What should I Do?"
- Reply: Cinderella: "Re: What should I Do?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 27 Sep 2004 14:25:41 -0400
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: Aaron [SQL Server MVP]: "Re: Setting "Maximum characters per column" in TSQL"
- Previous message: Johnny Silvestre: "Setting "Maximum characters per column" in TSQL"
- In reply to: Cinderella: "What should I Do?"
- Next in thread: Cinderella: "Re: What should I Do?"
- Reply: Cinderella: "Re: What should I Do?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|