HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Find old linked servers on a restored copy of master/msdb db

Submitted by: @import:stackexchange-dba··
0
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

select * from newmaster.sys.servers


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?

Solution

The system catalogs (SYS objects) are stored in the resource DB. The resource DB is usually located at: :\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.