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
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…