Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Unanswered: Help reqd on permission & security

    Hi Every body,
    I have newly joined this group. I am new to DB administration.
    I wanted some information as to if my Server crashes (which has) & i reinstall SQL server, will restoring master database restore all my permissions & security which was set before crash. It would be great in anybody can help me on this.

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    Restoring MASTER database (rebuilding and then restoring) would get you back with your logins, default database and language assignments, and fixed server roles. The rest is stored in user databases.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts