Moving/Migrating a SQL Server Database

When migrating or moving a database from one instance to another, be careful with logins and database owners. Ideally, all logins, principals etc. on the source instance should be present on the new instance. after the move, ensure that the new databases all have valid owners. If the database owner changes, privileges on database objects may cause stored procedures and other processes to malfunction. This can also cause many errors in the SQL Server logs and lead to disk full conditions.

Leave a Reply

Your email address will not be published. Required fields are marked *