Forum Discussion
Moving GFI Archiver databases from SQL Sever 2014 to 2019 on different domains
I've just started this job and I have to move 119 GFIArchiver databases from SQL server 2014 to 2019 on a different domain. The backups are approx 160GB each. The plan is to backup the databases and ...
Eugene71 , Windows logins can't have orphaned database user.
Are the user migrated to new domain with the same SID (Security ID) as in the old domain?
If not, they get a new SID. SQL Server mainly stores & uses that SID and so you have to create all Windows login new, same for database users, role assignment, permissions etc.