patternMinor
Find old linked servers on a restored copy of master/msdb db
Viewed 0 times
msdboldserverslinkedmasterfindrestoredcopy
Problem
We moved our dbs to a new server and the drives on the old server are still available, but the SQL service is offline and cannot be started.
I want to find the linked servers that were registered on the old server. I tried restoring the master db under a different name on another SQL server. That's all fine, but when I tried to run
it actually looks in the actual master db of that server instead of what I specified?
How do I view the list of linked servers in this case?
I want to find the linked servers that were registered on the old server. I tried restoring the master db under a different name on another SQL server. That's all fine, but when I tried to run
select * from newmaster.sys.serversit actually looks in the actual master db of that server instead of what I specified?
How do I view the list of linked servers in this case?
Solution
The system catalogs (SYS objects) are stored in the resource DB. The resource DB is usually located at:
Check this link on: Moving the master and Resource Databases to move your master and resource DB.
:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\, i.e. the same location of the master DB. Yes, this is like the fifth system database. Check this link on: Moving the master and Resource Databases to move your master and resource DB.
Context
StackExchange Database Administrators Q#14353, answer score: 3
Revisions (0)
No revisions yet.