Post reply

Resource db in SQL Server 2005

  • August 23, 2011 at 6:46 am

    #256121

    Hi,

    How resourcedb is useful as a DBAs point of view ?

    Thanks in advance.

  • August 23, 2011 at 7:32 am

    #1371983

    It's not.

    It's there to make service packs easier to create.

    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

  • August 23, 2011 at 7:35 am

    #1371986

    Thanks for reply Gail, how does it make service pack easier to create ? And what happens if there is some corruption in resourcedb?

    Thanks in advance.

  • August 23, 2011 at 7:41 am

    #1371993

    It separates out the system views, functions, procedures etc from the master DB, so if those are changed (in a patch say), the entire resource DB can just be replaced. That can't be done with master because it also contains system information.

    If damaged, you could replace the files (with SQL stopped) or rebuild master and then restore the other system databases. If you take file copies, they must be of taken again after any service pack or hotfix.

    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

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

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