I just restored a database on a new server with a backup(complete backup stored in backup device) from another database on another server using the "with move" option. In fact here was my process:
Alter database ngauge SET SINGLE_USER WITH ROLLBACK IMMEDIATE
restore database ngauge
from disk = 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\ngauge1.BAK'
with move 'NGAUGE' to 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\ngauge_Data.MDF',
move 'NGAUGE_Log' to 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\ngauge_Log.LDF'
Alter database ngauge SET READ_WRITE
But it did not move the 98 or so users/logins...from the source database
what is going on??? what am I doing wrong??!!
did you port your users in the old master database to the master database on the new server? if not, you have created orphaned users in the database that you restored to the new server. Check this article for information: