Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2009
    Posts
    1

    Unanswered: authentication wen we backup and restore DB

    Dear All,

    Whenever we backup a DB or restore from a dump, i need the authentication (it should ask for a Username and password). How can we achieve this in Ms sql server.. Waiting for ur reply..


    Thanks in advance

    Sripad Rao

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    Hi, may be I understand your question, but, when you make a bck, you can stable a password for this.

    In a bck you dont include a secury users/roles.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    It sounds like you may have had a problem with people restoring a database, and causing you to lose current data. In this case, the best solution would be to restrict the rights of these users. Putting a "speed bump" in front of them will not likely solve such a problem.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    BACKUP (Transact-SQL)

    Look at the MEDIAPASSWORD option
    George
    Home | Blog

Posting Permissions

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