Post reply

sql server2005 +How to move data from one drive to another drive

  • May 8, 2009 at 6:53 am

    #204124

    My database server (Sql server2005)is having disk space problem and it contains some data which is not very important but it is huge in terms of size.The server have some extra space on D: drive .

    To solve space issues, a job needs to be created that will move unused data from the data drives to D:

    Please any body tell me how to move data using job to another drive (D: drive in my case )

  • May 8, 2009 at 9:07 am

    #991185

    Create a new filegroup

    Create a new file in that filegroup and put it on the D drive

    You can move entire tables to the new filegroup by rebuilding the clustered index with the ON clause (CREATE Index ...... WITH DROP_EXISTING ON Secondary), or you can create new tables on that filegroup and use insert...select to copy data over.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 13, 2009 at 6:18 am

    #993610

    Hi Gail Shaw,

    Thanks for ur reply but can u also tell me code .I am new to database

  • May 13, 2009 at 6:39 am

    #993630

    asked and answered here................

    http://www.sqlservercentral.com/Forums/Topic712821-145-1.aspx

    ---------------------------------------------------------------------

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply