Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2007

    How to move MSSQL Server data folder

    I have a Windows 2003 server, install MSSQL Server 2005.
    Initially, I installed on D: \ MSSQL. Folder containing the data in D: \ MSSQL \ MSSQL.1 \ Data.
    Now I want to move data folder to E: \ MSSQLDB
    How do I transfer the entire database to a new folder?

  2. #2
    Join Date
    Aug 2009
    Change the data directory in MSSQL, stop MSSQ, move the contents, start MSSQL back up. You may need to edit the registry as well for the data and/or transaction log locations.

  3. #3
    Join Date
    Oct 2007
    I want ask, how to "change" and how to "edit" registry (if need). Where's the value I must change.
    Thank you so much

  4. #4
    Join Date
    Mar 2009
    Santa Monica, CA
    Open SQL Manager, connect to db, Press F1

  5. #5
    For user databases, look at the documentation for sp_detach and sp_attach

    For system databases, it can be done in the gui manager or, search the ms support site for a kb article on that. It may be a startup parameter, but not likely a registry edit.

    You might also want to look at the MSSQL BOL.
    managed dns global failover and load balance (gslb)
    uptime report for

Similar Threads

  1. How to move 60GB data from windows server to linux
    By angelsp in forum Dedicated Server
    Replies: 5
    Last Post: 07-29-2008, 12:31 AM
  2. using rsync to move web data from one server to another server?
    By surfmanjoe in forum Dedicated Server
    Replies: 6
    Last Post: 06-19-2007, 08:39 AM
  3. MSSQL Server and Web Data Admin - Not able to log in!
    By SupermanInNY in forum Hosting Security and Technology
    Replies: 1
    Last Post: 06-13-2006, 05:25 PM
  4. move data to new server ?
    By constantine in forum Web Hosting
    Replies: 1
    Last Post: 04-07-2005, 02:51 AM
  5. Move MySQL data to another server
    By giza in forum Dedicated Server
    Replies: 2
    Last Post: 06-04-2002, 12:14 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts