Easiest method for moving databases from one partition to another

Tech-Archive recommends: Fix windows errors by optimizing your registry

hal_at_nospam.com
Date: 01/25/05 

Date: Tue, 25 Jan 2005 09:12:04 -0700

The first SQL install went on the smaller partition and we need to
move it from C: to D:. It seems to me there should be a startup
parameter we can change, stop the server, move the databases, and
restart the server. Our DB admin is saying we need a full reinstall.
It seems to me this should be easiert. I am seeing pathing
information in the database parameters in the server properties tabs
in enterprize manager. Can I just change those, do my move, and
restart?

suggestions greatly appreciated

Hal

Relevant Pages

  • Easiest method for moving databases from one partition to another
    ... The first SQL install went on the smaller partition and we need to ... restart the server. ... information in the database parameters in the server properties tabs ...
    (microsoft.public.sqlserver.server)
  • 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: ISA 2004 REPORT FAILURE
    ... Update on Restart procedure. ... only way to start firewall was to reapply ISA 2004 SP2 ... this stopped ISA server related services ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • 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)