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 restore them to the new server. If I script out the logins will it suffice to add the new server and domain to the generated logins create script or will it orphan the logins on the new server? Any advice is greatly appreciated.
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.
