The old path looks like it was assuming there would be a "data" folder in the root. They aren't even in a folder called "Data". ![]() What does SQLDataRoot need to be if I keep the system databases in a separate folder then the user databases? As Daniel mentioned, there seems to be an assumption that there is a DATA folder in the root.Īccording to the Microsoft documentation,, they mention to set the SQLDataRoot value to the "new path", which I guess is exactly how it was presented in this article here. So clearly SQLDataRoot, at least by default, should not directly be the same folder that contains the master db. The default SQLDataRoot value is: C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL The master db is stored in: C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA ![]() I am also wondering about SQLDataRoot, it is not quite clear to me. ![]() Thank you so much for this article and on how to move the System databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |