Cloning two SQL Servers 2008 R2 from one site to another. Health checks.
Posted on 2016-09-12
I will be involved in a migration event from our SQL servers our local office to a data centre and I have been asked to create a list of health checks. Other than creating lists of current user permissions and their associated databases, as well as the default schemas for each database (see query below), is there anything else other than database backups, I should be creating copies of.
DECLARE @command varchar(1000)
select @command = 'USE ?; select DB_NAME(), default_schema_name
order by default_schema_name
EXEC sp_MSforeachdb @command
Any assistance is appreciated.