Rebuild of system databases, what else needs to be recreated

  • So what would need to be recreated

    logins

    jobs

    maintenance plans

    Normally a restore after the rebuild would occur and we would double check all of these. What I am really doing is changing the server collation and will need to recreate the above.

    Mark

  • Should have added restore or reattach user databases.

    Mark

  • DTS packages

    Linked servers

    Server-scoped DDL triggers

    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
  • Thank-you:)

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

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