Move SQL Databse (in MSDE) to another path

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Batista (carlos.batista_at_cmz.pt)
Date: 05/10/04 

Date: Mon, 10 May 2004 06:28:52 -0700

I have a server W2K (and MSDE) with 2 partitions one for
system (3GB) and one for data (37GB).
An application creates ALL SQL databases, in the default
folder for MSDE 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data' in the system partition.
It intended to move the databases for the data partition?

Relevant Pages

  • Unterschied SQL-Server und MSDE
    ... einem NT 4.0 Server liegt. ... MSDE 2000, ... Programm auf einer freígegebenen Partition installiert werden oder nur die ... Datendatei auf der freigegebenen Partition liegen? ...
    (microsoft.public.de.access.clientserver)
  • Re: Rebuilding SBS Server 2003 SP2
    ... issues with exchange system manager because the SSL server name ... figured a rebuild was the perfect time to investigate these (chuck more RAM ... lot with re-installs but havent a clue with partition sizes with SBS, ...
    (microsoft.public.windows.server.sbs)
  • Software Raid for clones
    ... Personally I inherited this E6750 ASUS motherboard and wanted thought I'd build a nice server for general use. ... I added 4 SATA 250 Gb disc drives and after reading about the horrors & failures of the cheapie Raid controllers, I decided to try Linux software raid. ... I got a message from every MD partition that there were not ... Disk partitions and LVM limits ...
    (RedHat)
  • Re: SBS2003 Partitioning
    ... sell a server to a customer to maximise billing hours. ... I realise that capacity is all down to the business that you are selling to ... just makes our experiences different. ... If the partition is on the same set of spindles then I could care ...
    (microsoft.public.windows.server.sbs)
  • Re: Is it possible to redirect the default user shares?
    ... The server is a rack mounted HP ProLiant ML 350 G4 and the integrated NIC ... I understand most people thatr design a server around W2k3 SBS Premium start ... OS partition and only a single additional partition if the underlying drive ... RAID1+RAID5) it may be worthwhile putting the shadowcopies from one array on ...
    (microsoft.public.windows.server.sbs)