Sample Header Ad - 728x90

Is the master db aware of user dbs?

-3 votes
2 answers
149 views
Where does SQL Server record the presence/paths of user dbs? I tried following approaches: Approach 1. I restored a master db on svr2 from a backup from svr1 Apprpach 2. I replaced the master db data/log files of svr2 with with copy from svr1 In both approaches, the GUI creates the user dbs on svr2 in recovery pending mode. Hence I want to ask where exactly does sql server store the information about whether user dbs are attached to it and their paths.
Asked by variable (3590 rep)
May 8, 2022, 05:08 AM
Last activity: May 14, 2022, 08:27 AM