SQL Advanced and Complex Configuration with Best Practices

preview_player
Показать описание
What is the right way to discover stand-alone instances? How about AG SQL DB's?
Want to mount your DB at multiple sites?
How do you leverage data masking with an Actifio managed SQL instance?
Forget doing all of this manually, workflows will automate your refresh process, come and learn how!

In part 2 of 2 in our SQL Advanced Administration we cover:

Failover clusters
Discover on all nodes, talk about stand-alone vs. clustered instances
Physical vs. Virtual, the issue with Virtual and SCSI Reserve/HBA Scan times
When we do vs. when we don't add disks into the cluster (i.e., not for backup, not for restore/clone, but yes for mount
AAG
Discover on all nodes - identify stand-alone DBs vs. AG DBs
External to SQL Instance, use Consistency Groups
Setting the node for backup (i.e., service IP) and restore flag
Restoring with CLONE!
Mounts for testing at multiple sites
Workflows
Scheduled vs. On Demand
Refreshing on-demand
Direct Mount vs. LiveClone
Masking
Sensitive Data
Рекомендации по теме