Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 View system messages from a restored Master

Author  Topic 

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2013-04-18 : 14:36:20
We had a problem with our Server. I made a backup of the Master. I want to view the sys.messages that were on this server. I restored this Master backup as MasterOriginal.

I thought I could do this:
SELECT * FROM [MasterOriginal].[sys].[messages]

But then I realized this is giving me the same as what is in [sys].[messages]. Any idea how I can view the messages from the MasterOriginal?
   

- Advertisement -