Post reply

Restoring a DB to Another Server

  • November 1, 2002 at 3:11 am

    #158523

    I have 2 SQL Servers, one is live and the other is a test/standby server. The live server has a full backup taken at midnight with a differential every hour.

    I recently restored the full backup to the test server; everything appeared fine until I looked at the users for this DB. Only dbo was present however there should be several others, the user logins are the there however. When I tried to add one of the users I get error 15023: user already exits in DB. I have tried transferring the logins using DTS but it has not made any difference. The sql I used to restore the DB was - RESTORE DATABASE [HPT] FROM DISK = 'g:\hpt.bak'.

    Any help would be greatly appreciated.

  • November 1, 2002 at 3:35 am

    #440023

    Hi, see the article: -

    qa.sqlservercentral.com/columnists/nboyle/fixingbrokenlogins.asp

    Regards,

    Andy Jones

    .

  • November 1, 2002 at 4:42 am

    #440030

    Thanks for that Andy, I now have my list of users associated with the DB again.

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

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