Move SQL 2005 System Databases - Resource DB Read_Only?

• hayden_jones

  SSCrazy

  Points: 2099

  More actions

  January 19, 2012 at 2:27 pm

  #249376

  I have read 3 writeups (Including a Microsoft Article) on how to move 2005 system database files. It's all clear and works just dandy. I see, though, that all instructions say to alter the resource database to make it read_only. But they never indicate that it should be altered back to read_write. Is that really how it is supposed to work? Doesn't this data ever get updated?

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  January 19, 2012 at 3:12 pm

  #1436216

  The resource database is NEVER updated, and is therefore read only. It just contains metadata and system objects.

  the only time it ever changes is when you patch SQL, and then it gets completely replaced.

  ---------------------------------------------------------------------