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 

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"?

Resources