For servers accessible over a network, use TLS whenever your environment allows it. Prefer VERIFY_IDENTITY when you have a stable DNS name and a verifiable certificate. Only save a password if that aligns with your security policy; otherwise, re-enter it during sessions when it is needed.
SQLmig - Database Backup and Migration