Post reply

Only user database was backed up

  • March 9, 2005 at 12:06 pm

    #102418

    One of the sql server crashed, only user database was backed up, after restored user db, application won't work. where do I know the logins?

  • March 9, 2005 at 12:28 pm

    #546220

    Hi,

    Resore the database on the new server

    In Query Analyzer do "Select * from sysusers". This way you will get SID and User Name which is mostly the login name if we are talking about Standard Authentication.

    Create a short script that uses sp_addlogin with those names and SIDs as parameters. You will be fine. Let me know if you need the script example

    Yelena

    Regards,Yelena Varsha

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

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