none
Move partition DB with large number of file-group to another disk. RRS feed

  • Question

  • Hello,

    We are in transition with a vendor to handover SQL server from their domain to our domain. While doing the health check, I found they have one 1 DB with 2200 file-group (Partition DB) and it's on C drive. DB is only 60 GB big. Now, i wanted to move the DB from C drive to dedicated SQL data drive. What would be the best way to move partition DB with such a large number of file-group? Any immediate response will be greatly appreciated.

    Tuesday, July 9, 2019 7:22 PM

Answers

  • Backup and restore? Script out the restore command, build it using a SELECT from sys.database_files before you remove the "old" database. And, of course, test with a new db name before doing it in real...

    Tibor Karaszi, SQL Server MVP (Web Blog)

    • Marked as answer by Chickoo79 Wednesday, July 10, 2019 4:11 PM
    Tuesday, July 9, 2019 7:47 PM

All replies

  • Backup and restore? Script out the restore command, build it using a SELECT from sys.database_files before you remove the "old" database. And, of course, test with a new db name before doing it in real...

    Tibor Karaszi, SQL Server MVP (Web Blog)

    • Marked as answer by Chickoo79 Wednesday, July 10, 2019 4:11 PM
    Tuesday, July 9, 2019 7:47 PM
  • Hi Chick0079,

    We can try to use detach/attach database method, ALTER DATABASE files method, backup/ restore database method.

    I find a similar thread, hope it could help you. Please refer to Moving partitioned file to another drive.

    Best regards,
    Cathy Ji

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, July 10, 2019 3:16 AM