Copy-DbaAgentAlert View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies SQL Server Agent alerts from source instance to destination instances
Description Transfers SQL Server Agent alerts from a source instance to one or more destination instances, preserving their configurations, notification settings, and job associations. This function handles the complex dependencies between alerts, operators, and jobs automatically, ensuring alerts work properly after migration.
Essential for server migrations, disaster recovery preparation, and standardizing monitoring across multiple SQL Server environments.
Copy-DbaAgentJob View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Migrates SQL Server Agent jobs between instances with dependency validation
Description Copies SQL Server Agent jobs from one instance to another while automatically validating all dependencies including databases, logins, proxy accounts, and operators. This eliminates the manual process of checking prerequisites before moving jobs during migrations, disaster recovery, or environment promotions.
The function intelligently skips jobs associated with maintenance plans and provides detailed validation messages for any missing dependencies.
Copy-DbaAgentJobCategory View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies custom SQL Agent categories for jobs, alerts, and operators between SQL Server instances.
Description Migrates custom SQL Agent categories from a source SQL Server to one or more destination servers, so you don’t have to manually recreate organizational structures during server migrations or environment setups.
This function copies only user-defined categories (ID >= 100), preserving built-in system categories on the destination.
Copy-DbaAgentOperator View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies SQL Server Agent operators between instances for migration and standardization.
Description Copies SQL Server Agent operators from a source instance to one or more destination instances, preserving all operator properties including email addresses, pager numbers, and notification schedules. This is essential during server migrations, environment standardization, or when setting up identical alerting configurations across multiple instances.
All operators are copied by default, but you can target specific operators or exclude certain ones.
Copy-DbaAgentProxy View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies SQL Server Agent proxy accounts from one instance to another.
Description Migrates SQL Server Agent proxy accounts between instances, enabling job steps to run under different security contexts than the SQL Agent service account. By default, all proxy accounts are copied, but you can specify individual accounts to migrate or exclude specific ones. The function requires that associated credentials already exist on the destination server before copying proxy accounts.
Copy-DbaAgentSchedule View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Migrates SQL Agent shared job schedules between SQL Server instances for job schedule standardization.
Description Copies shared job schedules (not job-specific schedules) from the source SQL Server Agent to one or more destination instances using T-SQL scripting. This is essential when standardizing job schedules across multiple servers or migrating Agent configurations to new instances. Existing schedules are skipped by default unless -Force is specified, and schedules with associated jobs cannot be overwritten even with Force to prevent breaking existing job assignments.
Copy-DbaAgentServer View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies all SQL Server Agent objects and server properties between instances.
Description Migrates complete SQL Server Agent configuration including jobs, operators, alerts, schedules, job categories, and proxies from one instance to another. This function handles the proper sequence of object creation and also copies server-level Agent properties like job history retention settings, error log locations, and database mail profiles.
Copy-DbaBackupDevice View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Migrates SQL Server backup devices between instances including both device definitions and physical files
Description Copies SQL Server backup devices from one instance to another, handling both the logical device definition and the physical backup files. This simplifies server migrations and disaster recovery setup by ensuring backup devices are available on target instances.
Physical backup files are transferred using admin shares, and if the original directory structure doesn’t exist on the destination, files are automatically placed in SQL Server’s default backup directory.
Copy-DbaCredential View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Migrates SQL Server credentials between instances while preserving encrypted passwords.
Description Copies SQL Server credentials from source to destination instances without losing the original passwords, which normally can’t be retrieved through standard methods. This function uses a Dedicated Admin Connection (DAC) and password decryption techniques to extract the actual credential passwords from the source server and recreate them identically on the destination.
Copy-DbaCustomError View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Migrates custom error messages and their language translations between SQL Server instances
Description Copies user-defined error messages from the source server’s sys.messages system catalog to one or more destination servers. This is essential when migrating applications that rely on custom error numbers and messages, or when standardizing error handling across multiple SQL Server environments.
Custom errors created with sp_addmessage are automatically discovered and migrated, including all language translations.
dbatools