We have 2 SQL 2005 servers and would like to move the database and the logins and passwords from server to server. I ran backup and restored the full database with no recovery mode which allow me to copy the transaction logs then I transfered the logons and ran sp_change_users_login to associate a server login with database user login. Now I need to turn on mirror and since the new server database is not in restore mode, I cannot run the mirror between the 2 servers. Any solutions please?
September 10, 2008 10:14 PM
September 11, 2008 2:03 PM