Post reply

mssqlsystemresource database

  • July 16, 2008 at 9:00 am

    #124686

    Hello,

    I have moved the master database location as specified in:

    http://support.microsoft.com/kb/224071

    and everything seems to be working fine. I have since discovered this:

    http://msdn.microsoft.com/en-us/library/ms345408.aspx

    which tells me that mssqlsystemresource must be moved to the same location as master.

    I have not moved the mssqlsystemresource files - they are still in the original location of the master files. How can I tell if the mssqlsystemresource database is working correctly or not?

    Am I missing something?

    Thanks,

    Rachel.

  • July 16, 2008 at 9:12 am

    #843864

    That's a good question. Did you check and see if SQL Server moved anything itself on startup? If it's working, I'd note it for yourself and the rest of the team what you did and that you have concerns over this db and leave it alone. It might come back later, but not sure.

    This is a hidden system database and not all that well documented. Not sure even myself what SQL Server does with it.

  • July 16, 2008 at 9:12 am

    #843867

    In my experience, if you can start SQL, you're fine.

    Steve: System resource contains the definitions of all of the system views, DMVs, Information schema views, all of the sp_ procs and a bunch of other stuff.

    If you're curious, stop a SQL instance, copy the two mssqlsystemresource files elsewhere (copy, not move), restart SQL then attach those files as a database with another name. Then you can treat it as any old user DB and look at its contents

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 16, 2008 at 9:15 am

    #843871

    Be very careful about moving master and systemresource db files. They must be in the same location for the SQL 2005 SP2 upgrade to work!

    Believe me, I'm talking from experience... :w00t:

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply