Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Need help moving a sql server folder(Im not uninstalling)

Answered Need help moving a sql server folder(Im not uninstalling)

  • Wednesday, April 11, 2012 8:00 PM
     
     
    Sign In to Vote
    0

    Hello all,

    MY ISSUE: On server-1, windows server 2008 Standard SP1 is installed, alond with SQL Server 2008 R2 Workgroup. There is only one hard drive in the server. There are two partitions [(C: - 40GB), (D: - 35GB)]. D: is for shared files. Now here is where my problem lies:

    The C: is getting full and I cant update the server because there is not enough space for the updates. So I am wanting to delete D: and dedicate that space to C:, HOWEVER, there is a folder on D: that I am worried about. Below I will list the folder in question and all the subfolders below that, so in the root of the d:, it goes like this:

    Program Files

    Microsoft SQL Server

    MSRS10_50.MSSQLSERVER & MSSQL10_50.MSSQLSERVER

    Now this foler :MSRS10_50.MSSQLSERVER has reporting services foler in it.

    And this folder: MSSQL10_50.MSSQLSERVER has these folders in it:

    Backup

    Binn

    Data

    FTData

    Install

    JOBS

    Log

    repldata

    Upgrade

    I need to move everything that is on the D: onto a new 1TB external hard drive. Is this feasable?????? Thanks in advance.

     

All Replies

  • Wednesday, April 11, 2012 9:07 PM
     
     
    Sign In to Vote
    1
    Yes you can but make sure you stop all the sql services on that server. Then move from the D drive to the External drive, assign the current D drive another letter and finally assign D letter to the external drive. Make sure you have a backup before starting)

    Javier Villegas | @javier_vill | http://sql-javier-villegas.blogspot.com/

    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

     
  • Wednesday, April 11, 2012 10:28 PM
     
     Answered
    Sign In to Vote
    1

    I need to move everything that is on the D: onto a new 1TB external hard drive.

    Hi,

    You may need to be aware of this, if the new drive is removable http://msdn.microsoft.com/en-us/library/ms143547(v=sql.105).aspx

    'Program files and data files cannot be installed on a removable disk drive...'

    You could move the files onto the D drive, but depending on the external drive connection i.e. if you use a USB2 port, then performance will likely be pretty bad due to limited throughput.

     
  • Thursday, April 12, 2012 1:35 PM
     
     
    Sign In to Vote
    0
    Javier, thanks for your input, however, you tell me I can, and KevinNocholas's link to msdn article states that I cannot:/. Please let me know my foreshore options on this task as this is considered critical.
     
  • Thursday, April 19, 2012 4:16 AM
     
     
    Sign In to Vote
    0
    I would not be moving to an external drive as it would not be fast enough to run SQL Server.
     
  • Tuesday, May 01, 2012 9:35 AM
     
     
    Sign In to Vote
    0

    Hi you can also ask your query on the given link, it may help you for the same.

    https://forums.oracle.com/forums/thread.jspa?threadID=2374542&tstart=0

     
  • Wednesday, May 02, 2012 10:06 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi aj,

    Moving the files to a removable drive is not prohibitted but is not be suggested by Microsoft.

    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.