Forum Discussion

manny213's avatar
manny213
Brass Contributor
Dec 31, 2024

Issue migrating SQL Server 2019 db to a new drive

Hi everyone I am a rookie and need some help.  I bought a new drive to store my sql server 2019 db.  The old drive is C-drive and the new drive is F-drive. I followed the 5 step example from here: ...
Yunus_Emre_ISIK's avatar
Yunus_Emre_ISIK
MCT
Jan 02, 2025

Hi Manny, 

You must give access rights to service account for "F:\SQL Server Data" folder. You can see your service accounts from sql server configuration manager

  • manny213's avatar
    manny213
    Brass Contributor
    Jan 02, 2025

    Hi Yunus_Emre_ISIK 

    I figured out the permission portion.  It now has access.  What is the next step to complete the migration?

    Thank you

  • manny213's avatar
    manny213
    Brass Contributor
    Jan 02, 2025

    Hi Yunus_Emre_ISIK 

    Thank you.  I am new to this. How exactly do I give access rights?  I took a look at configuration manager.  Is this the service account  "NT Service\MSSQLSERVER"?

  • manny213's avatar
    manny213
    Brass Contributor
    Jan 02, 2025

    Hi Yunus_Emre_ISIK 

    Thank you for your reply.  I am completely new to this.  How exactly do I do this?  I checked the configuration manner.  Would the service account be "NT Service\MSSQLSERVER"?  Can you please give example on how to give appropriate permission?

    Thank you

Resources