Post reply

backup user

  • January 17, 2010 at 1:55 am

    #386119

    Hi All,

    i am creat users in my database and assing give permission to users to assing database.

    now i will format the database server and i need to backupthis user and then restore them.

    how can i do this?

    Regards.

  • January 17, 2010 at 2:06 am

    #1104676

    Try to script them all and save as files... then after all things that you will do after format you can bring them again in your DB running scripts!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • January 17, 2010 at 6:35 am

    #1104701

    i think but iam not sure that i will face problem that the user exsit in the database.

  • January 17, 2010 at 6:39 am

    #1104702

    Make script with drop user/login first then create it again!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • January 20, 2010 at 2:48 am

    #1105907

    i do script. but when i restore users it is not mapping to there database and the user also can't loging.

    there is sign on the user indicate that it is down.

    sorry for my language.

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

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