Re: What should I Do?

From: Mike John (Mike.John_at_knowledgepool.com)
Date: 09/27/04


Date: Mon, 27 Sep 2004 22:32:24 +0100

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: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)

Loading