Sample Header Ad - 728x90

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