Move data file

• WhiteLotus

  SSChampion

  Points: 12122

  More actions

  August 27, 2019 at 5:45 am

  #3674577

  Hi,

  I need to move data file from 1 drive to another drive under the same server ,

  I am using SQL 2016 , the data file that I want to move is in Database that is in Always On ( High Availability )

  How do I move the data file (.MDF ) WITHOUT downtime at all ?

  Thank you

  Your feedback is much appreciated !

   

   

• as_1234

  SSCrazy

  Points: 2865

  More actions

  August 27, 2019 at 8:29 am

  #3674628

  I don't think you can move a file with the database online (Microsoft reference here https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases?view=sql-server-2017 ).

  Others may have better ideas but what you might be able to do is create a new filegroup and move the tables across. More details here https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases?view=sql-server-2017. This is more of an 'in theory' answer as I've only done it once with a small number of tables so don't have much practical experience.

  This thread my also help https://www.sqlservercentral.com/forums/topic/move-clustered-index-to-a-new-filegroup