Post reply

Restoring a database from different server (both have window 2008r2)

  • October 16, 2012 at 11:43 am

    #265781

    Hello experts,

    I am refreshing a database, so I need to take a current full back up of ‘mydb’ database (which is production database) from server A and restore ‘TMydb’ database with replace on server B (which is staging database).

    Since ‘Mydb’ database on server B had so many users and logins, will be replaced by ‘TMydb’ database of server A restore, how can I have exactly same logins and user names on ‘TMydb’ database on server B as it had before refresh (before latest backup restored)

    Note: both different servers are on window 2008r2.

  • October 16, 2012 at 11:57 am

    #1549716

    you will need to record the users in database on server B before you restore over it. There is a script here [/url]to do that, read the discussion attached as well to get the improved version.

    you can then run the users back in after first deciding what you want to do with the users bought across from server A. Keep your final script so you can reuse it.

    ---------------------------------------------------------------------

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

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