Where does sql server hold the paths of data and log files?
-1
votes
1
answer
724
views
Sql server configs (logins/roles/server configs) are stored in masterdb
Jobs/schedules are stored in msdb
Where are the following values stored:
1. Data and log file path of system dbs
2. Data and log file path of user dbs. I want to know this because when I restore master db on another server then it doesn't auto create the user dbs in the GUI.
Asked by variable
(3590 rep)
May 7, 2022, 07:20 PM
Last activity: May 8, 2022, 04:54 AM
Last activity: May 8, 2022, 04:54 AM