How to move MS SQL instance folder containing system databases to a new location
0
votes
1
answer
118
views
Similiar question : we are trying to secure a machine with backups on a Hyper-V host which also runs a MSSQL database in a small company and we don't want to back up a partition where all VM disks reside, however I've noticed that someone installing the database service left MSSQL16.MSSQLSERVER folder with system databases and the Resource database on the same drive (non-default location,
F:\SQL\MSSQL16.MSSQLSERVER
). I want these files to be covered with backups "just in case" and I have normal SQL backups in place, but right now if I restore the full machine backup, these files won't be there.
I've seen people suggesting to backup these files, reinstall MSSQL during the installation pick a new installation. Some places suggest copying files to a new location while the DBs are off, changing some registry edits and edits in SQL Server configuration Manager. Ultimately, what would be the best solution in my scenario?
I'll add that MDF/LDF files for production databases are on separate disks.
Asked by Radosław Serba
(1 rep)
Feb 1, 2025, 12:22 AM
Last activity: Feb 1, 2025, 10:45 AM
Last activity: Feb 1, 2025, 10:45 AM