Help - dbatools.io - Start-DbaMigration - Maintenance Plans and Custom Server roles not migrated #8445

DBAgnew · 2022-07-12T14:43:45Z

DBAgnew
Jul 12, 2022

Hello,
I just used Start-DbaMigration and noticed that my maintenance plan as well as a Server Role I had created did not make it to the destination server. I reviewed the verbose output and no mention of any issues. SSIS was installed and running. I used the BackupRestore(True) and Force (True) a shared path and source and destination parameters. All other objects made it ok. The server was rebooted post process completion.

Maybe this function is not available in the version I'm using which is 1.1.88.

The source SQL Server is 2019 Enterprise Edition and the source is SQL Server 2019 Developer edition. Both patched up-to-date and both are on OS 2019.

Thanks

$params = @{
Source = "SQLSTG01"
Destination = "SQLEDTN01"
SharedPath = "\ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01"
BackupRestore = $true
Force = $true
}
Start-DbaMigration @params -Verbose

VERBOSE: [13:00:50][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:00:50][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:00:50][Start-DbaMigration] Migrating SQL Server Configuration
VERBOSE: [13:00:50][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:00:50][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:00:50][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:00:50][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:00:51][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object

VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option UserConnections (user connections) requires restart.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option Locks (locks) requires restart.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option OpenObjects (open objects) requires restart.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option FillFactor (fill factor (%)) requires restart.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option RemoteAccess (remote access) requires restart.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option C2AuditMode (c2 audit mode) requires restart.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option PriorityBoost (priority boost) requires restart.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option SetWorkingSetSize (set working set size) requires restart.
VERBOSE: [13:00:51][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Updated MaxServerMemory (max server memory (MB)) from 2147483647 to 11264.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option LightweightPooling (lightweight pooling) requires restart.
VERBOSE: [13:00:51][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Updated ScanForStartupProcedures (scan for startup procs) from 0 to 1.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option ScanForStartupProcedures (scan for startup procs) requires restart.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option AffinityIOMask (affinity I/O mask) requires restart.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option Affinity64IOMask (affinity64 I/O mask) requires restart.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option CommonCriteriaComplianceEnabled (common criteria compliance enabled) requires restart.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option AutomaticSoftnumaDisabled (automatic soft-NUMA disabled) requires restart.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option ColumnEncryptionEnclaveType (column encryption enclave type) requires restart.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option TempdbMetadataMemoryOptimized (tempdb metadata memory-optimized) requires restart.
VERBOSE: [13:00:51][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Updated AdrCleanerRetryTimeout (ADR cleaner retry timeout (min)) from 0 to 120.
VERBOSE: [13:00:51][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Updated AdrPreallcationFactor (ADR Preallocation Factor) from 0 to 4.
VERBOSE: [13:00:51][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Updated DatabaseMailEnabled (Database Mail XPs) from 0 to 1.
VERBOSE: [13:00:51][Copy-DbaSpConfigure] Configuration option HadoopConnectivity (hadoop connectivity) requires restart.
VERBOSE: [13:00:51][Start-DbaMigration] Copying certificates in the master database
VERBOSE: [13:00:52][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:00:52][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:00:52][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:00:52][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:00:53][Start-DbaMigration] Migrating custom errors (user defined messages)
VERBOSE: [13:00:53][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:00:55][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:00:55][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:00:55][Start-DbaMigration] Migrating SQL credentials
VERBOSE: [13:00:55][Copy-DbaCredential] We will try to use a dedicated admin connection.
VERBOSE: [13:00:55][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:00:55][Connect-DbaInstance] DedicatedAdminConnection provided. Does not match ConnectionContext.ServerInstance, copying ConnectionContext and setting the ServerInstance
VERBOSE: [13:01:11][Copy-DbaCredential] Failed to open a dedicated admin connection. We will fallback to a normal connection.
VERBOSE: [13:01:11][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:11][Copy-DbaCredential] Decrypting all Credential logins and passwords on SQLSTG01
VERBOSE: [13:01:11][Get-DecryptedObject] Querying service master key
VERBOSE: [13:01:11][Resolve-DbaNetworkName] Resolving SQLSTG01 using .NET.Dns GetHostEntry
VERBOSE: [13:01:11][Resolve-DbaNetworkName] Resolving 10.255.27.184 using .NET.Dns GetHostByAddress
VERBOSE: [13:01:11][Get-DbaCmObject] Configuration loaded | Cache disabled: False
VERBOSE: [13:01:11][Get-DbaCmObject] [sqlstg01] Retrieving Management Information
VERBOSE: [13:01:11][Get-DbaCmObject] [sqlstg01] Accessing computer using Cim over WinRM
VERBOSE: [13:01:11][Get-DbaCmObject] [sqlstg01] Accessing computer using Cim over WinRM - Success
VERBOSE: [13:01:11][Resolve-DbaNetworkName] Resolving SQLSTG01.AD.XXXXXX.ORG using .NET.Dns GetHostEntry
VERBOSE: [13:01:11][Resolve-DbaComputerName] Resolved 'SQLSTG01' to 'SQLSTG01.AD.XXXXXX.ORG'
VERBOSE: [13:01:11][Get-DecryptedObject] Decrypt the service master key
VERBOSE: [13:01:12][Get-DecryptedObject] Choose the encryption algorithm based on the SMK length - 3DES for 2008, AES for 2012
VERBOSE: [13:01:12][Get-DecryptedObject] Query password information from the Db.
WARNING: [13:01:27][Copy-DbaCredential] Failed to decrypt credentials on SQLSTG01 | Exception calling "Open" with "0" argument(s): "A network-related or instance-specific error occurred while establishing a connection to SQL Server. T
he server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 43 - An error occurred while obtaining th
e dedicated administrator connection (DAC) port. Make sure that SQL Browser is running, or check the error log for the port number)"
VERBOSE: [13:01:27][Disconnect-DbaInstance] removing from connection hash
VERBOSE: [13:01:27][Start-DbaMigration] Migrating database mail
VERBOSE: [13:01:27][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:27][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:01:27][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:01:27][Copy-DbaDbMailConfig] Migrating mail server configuration values.
VERBOSE: [13:01:27][Copy-DbaDatabaseAccount] Migrating accounts.
VERBOSE: [13:01:27][Copy-DbaDatabaseAccount] Updating account name from 'SQL Alerts' to 'SQL Alerts'.
VERBOSE: [13:01:27][Copy-DbaDatabaseAccount] Copying mail account 'SQL Alerts'.
VERBOSE: [13:01:27][Copy-DbaDbMailProfile] Migrating mail profiles.
VERBOSE: [13:01:27][Copy-DbaDbMailProfile] Updating profile name from 'SQL Alerts' to 'SQL Alerts'.
VERBOSE: [13:01:27][Copy-DbaDbMailProfile] Copying mail profile 'SQL Alerts'.
VERBOSE: [13:01:27][Copy-DbaDbMailServer] Getting mail server credentials.
VERBOSE: [13:01:27][Copy-DbaDbMailServer] Migrating mail servers.
VERBOSE: [13:01:27][Copy-DbaDbMailServer] Copying mail server mail.XXXXXXXX.org.
VERBOSE: [13:01:27][Start-DbaMigration] Migrating Central Management Server
VERBOSE: [13:01:27][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:27][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:27][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:01:27][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:01:27][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:27][Start-DbaMigration] Migrating Backup Devices
VERBOSE: [13:01:27][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:28][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:01:28][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:01:28][Start-DbaMigration] Migrating System Triggers
VERBOSE: [13:01:28][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:28][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:01:28][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:01:28][Start-DbaMigration] Migrating databases
VERBOSE: [13:01:28][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:28][Resolve-DbaNetworkName] Resolving SQLSTG01 using .NET.Dns GetHostEntry
VERBOSE: [13:01:28][Resolve-DbaNetworkName] Resolving 10.255.27.184 using .NET.Dns GetHostByAddress
VERBOSE: [13:01:28][Get-DbaCmObject] Configuration loaded | Cache disabled: False
VERBOSE: [13:01:28][Get-DbaCmObject] [sqlstg01] Retrieving Management Information
VERBOSE: [13:01:28][Get-DbaCmObject] [sqlstg01] Accessing computer using Cim over WinRM
VERBOSE: [13:01:28][Get-DbaCmObject] [sqlstg01] Accessing computer using Cim over WinRM - Success
VERBOSE: [13:01:28][Resolve-DbaNetworkName] Resolving SQLSTG01.AD.XXXXXX.ORG using .NET.Dns GetHostEntry
VERBOSE: [13:01:28][Resolve-DbaComputerName] Resolved 'SQLSTG01' to 'SQLSTG01.AD.XXXXXX.ORG'
VERBOSE: [13:01:28][Copy-DbaDatabase] Using SQLSTG01.AD.XXXXXX.ORG as sourceFullComputerName.
VERBOSE: [13:01:28][Copy-DbaDatabase] Ensuring user databases exist (counting databases).
VERBOSE: [13:01:28][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:01:28][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:01:28][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:29][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:29][Copy-DbaDatabase] Using CNAME records for the network share may present an issue if an SPN has not been created. Trying anyway. If it doesn't work, use a different (A record) hostname.
VERBOSE: [13:01:29][Resolve-DbaNetworkName] Resolving SQLEDTN01 using .NET.Dns GetHostEntry
VERBOSE: [13:01:29][Resolve-DbaNetworkName] Resolving 10.255.27.155 using .NET.Dns GetHostByAddress
VERBOSE: [13:01:29][Get-DbaCmObject] Configuration loaded | Cache disabled: False
VERBOSE: [13:01:29][Get-DbaCmObject] [sqledtn01] Retrieving Management Information
VERBOSE: [13:01:29][Get-DbaCmObject] [sqledtn01] Accessing computer using Cim over WinRM
VERBOSE: [13:01:29][Get-DbaCmObject] [sqledtn01] Accessing computer using Cim over WinRM - Success
VERBOSE: [13:01:30][Resolve-DbaNetworkName] Resolving SQLEDTN01.AD.XXXXXX.ORG using .NET.Dns GetHostEntry
VERBOSE: [13:01:30][Resolve-DbaComputerName] Resolved 'SQLEDTN01' to 'SQLEDTN01.AD.XXXXXX.ORG'
VERBOSE: [13:01:30][Copy-DbaDatabase] Using SQLEDTN01.AD.XXXXXX.ORG as destFullComputerName.
VERBOSE: [13:01:30][Copy-DbaDatabase] Performing SMO version check.
VERBOSE: [13:01:30][Copy-DbaDatabase] Checking to ensure the source isn't the same as the destination.
VERBOSE: [13:01:30][Copy-DbaDatabase] Checking to ensure server is not SQL Server 7 or below.
VERBOSE: [13:01:30][Copy-DbaDatabase] Checking to ensure detach/attach is not attempted on SQL Server 2000.
VERBOSE: [13:01:30][Copy-DbaDatabase] Checking to ensure SQL Server 2000 migration isn't directly attempted to SQL Server 2012.
VERBOSE: [13:01:30][Copy-DbaDatabase] Warning if migration from 2005 to 2012 and above and attach/detach is used.
VERBOSE: [13:01:30][Copy-DbaDatabase] Ensuring destination server version is equal to or greater than source.
VERBOSE: [13:01:30][Copy-DbaDatabase] Writing warning about filestream being enabled.
VERBOSE: [13:01:30][Copy-DbaDatabase] Building database list.
VERBOSE: [13:01:30][Copy-DbaDatabase] Performing count.
VERBOSE: [13:01:30][Copy-DbaDatabase] Building file structure inventory for 14 databases.
VERBOSE: [13:01:30][Get-SqlFileStructure] CCCv2
VERBOSE: [13:01:30][Get-SqlFileStructure] COI
VERBOSE: [13:01:30][Get-SqlFileStructure] DBA
VERBOSE: [13:01:30][Get-SqlFileStructure] FootPrints
VERBOSE: [13:01:30][Get-SqlFileStructure] FPReports
VERBOSE: [13:01:30][Get-SqlFileStructure] HFWE
VERBOSE: [13:01:30][Get-SqlFileStructure] LOGW
VERBOSE: [13:01:30][Get-SqlFileStructure] SP_DAC
VERBOSE: [13:01:30][Get-SqlFileStructure] SP_DAEP
VERBOSE: [13:01:30][Get-SqlFileStructure] SP_MAS
VERBOSE: [13:01:30][Get-SqlFileStructure] SP_MSHP
VERBOSE: [13:01:30][Get-SqlFileStructure] SP_SWAV
VERBOSE: [13:01:30][Get-SqlFileStructure] SPAT
VERBOSE: [13:01:30][Get-SqlFileStructure] VISITS
VERBOSE: [13:01:30][Copy-DbaDatabase]
######### Database: CCCv2 #########
VERBOSE: [13:01:30][Copy-DbaDatabase] Checking for accessibility.
VERBOSE: [13:01:30][Copy-DbaDatabase] Checking Availability Group status.
VERBOSE: [13:01:30][Copy-DbaDatabase] Started: 07/11/2022 13:01:30.
VERBOSE: [13:01:30][Backup-DbaDatabase] Setting Default timestampformat
VERBOSE: [13:01:30][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:30][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:01:30][Backup-DbaDatabase] 1 database to backup
VERBOSE: [13:01:30][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:30][Backup-DbaDatabase] Backup database [CCCv2]
VERBOSE: [13:01:31][Backup-DbaDatabase] Creating full backup
VERBOSE: [13:01:31][Backup-DbaDatabase] Building file name
VERBOSE: [13:01:31][Backup-DbaDatabase] Setting filename - 202207111301
VERBOSE: [13:01:31][Backup-DbaDatabase] Building backup path
VERBOSE: [13:01:31][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:31][Backup-DbaDatabase] Devices added
VERBOSE: [13:01:39][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:39][Get-DbaDbBackupHistory] Processing CCCv2
VERBOSE: [13:01:39][Get-DbaDbBackupHistory] Executing sql query on [SQLSTG01].
VERBOSE: [13:01:39][Get-DbaDbBackupHistory] Processing as grouped output.
VERBOSE: [13:01:39][Get-DbaDbBackupHistory] 3 result-groups found.
VERBOSE: [13:01:39][Copy-DbaDatabase] Reuse = False.
VERBOSE: [13:01:39][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:39][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:01:39][Restore-DbaDatabase] Changing statement timeout to infinity
VERBOSE: [13:01:39][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:39][Restore-DbaDatabase] ParameterSet = Restore
VERBOSE: [13:01:39][Restore-DbaDatabase] Trust Database Backup History Set
VERBOSE: [13:01:39][Restore-DbaDatabase] Processing DatabaseName - CCCv2
VERBOSE: [13:01:39][Format-DbaBackupInformation] Starting
VERBOSE: [13:01:39][Format-DbaBackupInformation] String passed in for DB rename
VERBOSE: [13:01:39][Format-DbaBackupInformation] New DbName (String) = CCCv2
VERBOSE: [13:01:39][Format-DbaBackupInformation] 1 PhysicalName = E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\CCCv2.mdf
VERBOSE: [13:01:39][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\CCCv2.mdf
VERBOSE: [13:01:39][Format-DbaBackupInformation] 1 PhysicalName = F:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\CCCv2.ldf
VERBOSE: [13:01:39][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\CCCv2.ldf
VERBOSE: [13:01:39][Select-DbaBackupInformation] Filtering by DatabaseName
VERBOSE: [13:01:39][Select-DbaBackupInformation] processing diffs
VERBOSE: [13:01:39][Select-DbaBackupInformation] Found LogBaseLsn: 3125000000135500001 and FirstRecoveryForkID:
VERBOSE: [13:01:39][Restore-DbaDatabase] VerifyOnly = False
VERBOSE: [13:01:39][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:39][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:39][Test-DbaBackupInformation] Testing restore for CCCv2
VERBOSE: [13:01:39][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:39][Test-DbaBackupInformation] VerifyOnly = False
VERBOSE: [13:01:40][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:40][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:40][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:40][Test-DbaLsnChain] Testing LSN Chain
VERBOSE: [13:01:40][Test-DbaLsnChain] Testing LSN Chain - Type Type
VERBOSE: [13:01:40][Test-DbaLsnChain] Passed LSN Chain checks
VERBOSE: [13:01:40][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:40][Test-DbaBackupInformation] Marking CCCv2 as verified
VERBOSE: [13:01:40][Restore-DbaDatabase] CCCv2 passed testing
VERBOSE: [13:01:40][Restore-DbaDatabase] Passing in to restore
VERBOSE: [13:01:40][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:40][Invoke-DbaAdvancedRestore] Performing restore action
VERBOSE: [13:01:42][Invoke-DbaAdvancedRestore] Succeeded, Closing Server connection
VERBOSE: [13:01:42][Copy-DbaDatabase] Successfully restored CCCv2 to SQLEDTN01.
VERBOSE: [13:01:43][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\CCCv2_202207111301-1-of-3.bak.
VERBOSE: [13:01:43][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\CCCv2_202207111301-2-of-3.bak.
VERBOSE: [13:01:43][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\CCCv2_202207111301-3-of-3.bak.
VERBOSE: [13:01:44][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:44][Copy-DbaDatabase] Finished: 07/11/2022 13:01:43.
VERBOSE: [13:01:44][Copy-DbaDatabase] Elapsed time: 00:00:13.
VERBOSE: [13:01:44][Copy-DbaDatabase]
######### Database: COI #########
VERBOSE: [13:01:44][Copy-DbaDatabase] Checking for accessibility.
VERBOSE: [13:01:44][Copy-DbaDatabase] Checking Availability Group status.
VERBOSE: [13:01:44][Copy-DbaDatabase] Started: 07/11/2022 13:01:44.
VERBOSE: [13:01:44][Backup-DbaDatabase] Setting Default timestampformat
VERBOSE: [13:01:44][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:44][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:01:44][Backup-DbaDatabase] 1 database to backup
VERBOSE: [13:01:44][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:44][Backup-DbaDatabase] Backup database [COI]
VERBOSE: [13:01:44][Backup-DbaDatabase] Creating full backup
VERBOSE: [13:01:44][Backup-DbaDatabase] Building file name
VERBOSE: [13:01:44][Backup-DbaDatabase] Setting filename - 202207111301
VERBOSE: [13:01:44][Backup-DbaDatabase] Building backup path
VERBOSE: [13:01:44][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:44][Backup-DbaDatabase] Devices added
VERBOSE: [13:01:46][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:46][Get-DbaDbBackupHistory] Processing COI
VERBOSE: [13:01:46][Get-DbaDbBackupHistory] Executing sql query on [SQLSTG01].
VERBOSE: [13:01:46][Get-DbaDbBackupHistory] Processing as grouped output.
VERBOSE: [13:01:46][Get-DbaDbBackupHistory] 3 result-groups found.
VERBOSE: [13:01:47][Copy-DbaDatabase] Reuse = False.
VERBOSE: [13:01:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:47][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:01:47][Restore-DbaDatabase] Changing statement timeout to infinity
VERBOSE: [13:01:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:47][Restore-DbaDatabase] ParameterSet = Restore
VERBOSE: [13:01:47][Restore-DbaDatabase] Trust Database Backup History Set
VERBOSE: [13:01:47][Restore-DbaDatabase] Processing DatabaseName - COI
VERBOSE: [13:01:47][Format-DbaBackupInformation] Starting
VERBOSE: [13:01:47][Format-DbaBackupInformation] String passed in for DB rename
VERBOSE: [13:01:47][Format-DbaBackupInformation] New DbName (String) = COI
VERBOSE: [13:01:47][Format-DbaBackupInformation] 1 PhysicalName = E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\COI.mdf
VERBOSE: [13:01:47][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\COI.mdf
VERBOSE: [13:01:47][Format-DbaBackupInformation] 1 PhysicalName = F:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\COI.ldf
VERBOSE: [13:01:47][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\COI.ldf
VERBOSE: [13:01:47][Select-DbaBackupInformation] Filtering by DatabaseName
VERBOSE: [13:01:47][Select-DbaBackupInformation] processing diffs
VERBOSE: [13:01:47][Select-DbaBackupInformation] Found LogBaseLsn: 251000000044100001 and FirstRecoveryForkID:
VERBOSE: [13:01:47][Restore-DbaDatabase] VerifyOnly = False
VERBOSE: [13:01:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:47][Test-DbaBackupInformation] Testing restore for COI
VERBOSE: [13:01:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:47][Test-DbaBackupInformation] VerifyOnly = False
VERBOSE: [13:01:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:47][Test-DbaLsnChain] Testing LSN Chain
VERBOSE: [13:01:47][Test-DbaLsnChain] Testing LSN Chain - Type Type
VERBOSE: [13:01:47][Test-DbaLsnChain] Passed LSN Chain checks
VERBOSE: [13:01:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:47][Test-DbaBackupInformation] Marking COI as verified
VERBOSE: [13:01:47][Restore-DbaDatabase] COI passed testing
VERBOSE: [13:01:47][Restore-DbaDatabase] Passing in to restore
VERBOSE: [13:01:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:47][Invoke-DbaAdvancedRestore] Performing restore action
VERBOSE: [13:01:48][Invoke-DbaAdvancedRestore] Succeeded, Closing Server connection
VERBOSE: [13:01:48][Copy-DbaDatabase] Successfully restored COI to SQLEDTN01.
VERBOSE: [13:01:48][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\COI_202207111301-1-of-3.bak.
VERBOSE: [13:01:48][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\COI_202207111301-2-of-3.bak.
VERBOSE: [13:01:48][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\COI_202207111301-3-of-3.bak.
VERBOSE: [13:01:48][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:48][Copy-DbaDatabase] Finished: 07/11/2022 13:01:48.
VERBOSE: [13:01:48][Copy-DbaDatabase] Elapsed time: 00:00:04.
VERBOSE: [13:01:48][Copy-DbaDatabase]
######### Database: DBA #########
VERBOSE: [13:01:48][Copy-DbaDatabase] Checking for accessibility.
VERBOSE: [13:01:48][Copy-DbaDatabase] Checking Availability Group status.
VERBOSE: [13:01:48][Copy-DbaDatabase] Started: 07/11/2022 13:01:48.
VERBOSE: [13:01:48][Backup-DbaDatabase] Setting Default timestampformat
VERBOSE: [13:01:48][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:48][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:01:49][Backup-DbaDatabase] 1 database to backup
VERBOSE: [13:01:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:49][Backup-DbaDatabase] Backup database [DBA]
VERBOSE: [13:01:49][Backup-DbaDatabase] Creating full backup
VERBOSE: [13:01:49][Backup-DbaDatabase] Building file name
VERBOSE: [13:01:49][Backup-DbaDatabase] Setting filename - 202207111301
VERBOSE: [13:01:49][Backup-DbaDatabase] Building backup path
VERBOSE: [13:01:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:01:49][Backup-DbaDatabase] Devices added
VERBOSE: [13:21:19][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:21:19][Get-DbaDbBackupHistory] Processing DBA
VERBOSE: [13:21:19][Get-DbaDbBackupHistory] Executing sql query on [SQLSTG01].
VERBOSE: [13:21:19][Get-DbaDbBackupHistory] Processing as grouped output.
VERBOSE: [13:21:19][Get-DbaDbBackupHistory] 3 result-groups found.
VERBOSE: [13:21:19][Copy-DbaDatabase] Reuse = False.
VERBOSE: [13:21:19][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:21:19][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:21:19][Restore-DbaDatabase] Changing statement timeout to infinity
VERBOSE: [13:21:19][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:21:19][Restore-DbaDatabase] ParameterSet = Restore
VERBOSE: [13:21:19][Restore-DbaDatabase] Trust Database Backup History Set
VERBOSE: [13:21:19][Restore-DbaDatabase] Processing DatabaseName - DBA
VERBOSE: [13:21:19][Format-DbaBackupInformation] Starting
VERBOSE: [13:21:19][Format-DbaBackupInformation] String passed in for DB rename
VERBOSE: [13:21:19][Format-DbaBackupInformation] New DbName (String) = DBA
VERBOSE: [13:21:19][Format-DbaBackupInformation] 1 PhysicalName = E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\DBA.mdf
VERBOSE: [13:21:19][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\DBA.mdf
VERBOSE: [13:21:19][Format-DbaBackupInformation] 1 PhysicalName = F:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\DBA_log.ldf
VERBOSE: [13:21:19][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\DBA_log.ldf
VERBOSE: [13:21:19][Select-DbaBackupInformation] Filtering by DatabaseName
VERBOSE: [13:21:19][Select-DbaBackupInformation] processing diffs
VERBOSE: [13:21:19][Select-DbaBackupInformation] Found LogBaseLsn: 319400000000306100001 and FirstRecoveryForkID:
VERBOSE: [13:21:19][Restore-DbaDatabase] VerifyOnly = False
VERBOSE: [13:21:20][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:21:20][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:21:20][Test-DbaBackupInformation] Testing restore for DBA
VERBOSE: [13:21:20][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:21:20][Test-DbaBackupInformation] VerifyOnly = False
VERBOSE: [13:21:20][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:21:20][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:21:20][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:21:20][Test-DbaLsnChain] Testing LSN Chain
VERBOSE: [13:21:20][Test-DbaLsnChain] Testing LSN Chain - Type Type
VERBOSE: [13:21:20][Test-DbaLsnChain] Passed LSN Chain checks
VERBOSE: [13:21:20][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:21:20][Test-DbaBackupInformation] Marking DBA as verified
VERBOSE: [13:21:20][Restore-DbaDatabase] DBA passed testing
VERBOSE: [13:21:20][Restore-DbaDatabase] Passing in to restore
VERBOSE: [13:21:20][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:21:20][Invoke-DbaAdvancedRestore] Performing restore action
VERBOSE: [13:41:50][Invoke-DbaAdvancedRestore] Succeeded, Closing Server connection
VERBOSE: [13:41:50][Copy-DbaDatabase] Successfully restored DBA to SQLEDTN01.
VERBOSE: [13:41:50][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\DBA_202207111301-1-of-3.bak.
VERBOSE: [13:41:50][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\DBA_202207111301-2-of-3.bak.
VERBOSE: [13:41:50][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\DBA_202207111301-3-of-3.bak.
VERBOSE: [13:41:50][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:41:50][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:41:50][Copy-DbaDatabase] Finished: 07/11/2022 13:41:50.
VERBOSE: [13:41:50][Copy-DbaDatabase] Elapsed time: 00:40:02.
VERBOSE: [13:41:50][Copy-DbaDatabase]
######### Database: FootPrints #########
VERBOSE: [13:41:50][Copy-DbaDatabase] Checking for accessibility.
VERBOSE: [13:41:50][Copy-DbaDatabase] Checking Availability Group status.
VERBOSE: [13:41:50][Copy-DbaDatabase] Started: 07/11/2022 13:41:50.
VERBOSE: [13:41:51][Backup-DbaDatabase] Setting Default timestampformat
VERBOSE: [13:41:51][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:41:51][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:41:51][Backup-DbaDatabase] 1 database to backup
VERBOSE: [13:41:51][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:41:51][Backup-DbaDatabase] Backup database [FootPrints]
VERBOSE: [13:41:51][Backup-DbaDatabase] Creating full backup
VERBOSE: [13:41:51][Backup-DbaDatabase] Building file name
VERBOSE: [13:41:51][Backup-DbaDatabase] Setting filename - 202207111341
VERBOSE: [13:41:51][Backup-DbaDatabase] Building backup path
VERBOSE: [13:41:51][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:41:52][Backup-DbaDatabase] Devices added
VERBOSE: [13:43:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:43:37][Get-DbaDbBackupHistory] Processing FootPrints
VERBOSE: [13:43:37][Get-DbaDbBackupHistory] Executing sql query on [SQLSTG01].
VERBOSE: [13:43:37][Get-DbaDbBackupHistory] Processing as grouped output.
VERBOSE: [13:43:37][Get-DbaDbBackupHistory] 3 result-groups found.
VERBOSE: [13:43:37][Copy-DbaDatabase] Reuse = False.
VERBOSE: [13:43:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:43:37][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:43:37][Restore-DbaDatabase] Changing statement timeout to infinity
VERBOSE: [13:43:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:43:37][Restore-DbaDatabase] ParameterSet = Restore
VERBOSE: [13:43:37][Restore-DbaDatabase] Trust Database Backup History Set
VERBOSE: [13:43:37][Restore-DbaDatabase] Processing DatabaseName - FootPrints
VERBOSE: [13:43:37][Format-DbaBackupInformation] Starting
VERBOSE: [13:43:37][Format-DbaBackupInformation] String passed in for DB rename
VERBOSE: [13:43:37][Format-DbaBackupInformation] New DbName (String) = FootPrints
VERBOSE: [13:43:37][Format-DbaBackupInformation] 1 PhysicalName = E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\FootPrints.mdf
VERBOSE: [13:43:37][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\FootPrints.mdf
VERBOSE: [13:43:37][Format-DbaBackupInformation] 1 PhysicalName = F:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\FootPrints.ldf
VERBOSE: [13:43:37][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\FootPrints.ldf
VERBOSE: [13:43:37][Select-DbaBackupInformation] Filtering by DatabaseName
VERBOSE: [13:43:37][Select-DbaBackupInformation] processing diffs
VERBOSE: [13:43:37][Select-DbaBackupInformation] Found LogBaseLsn: 122497000000007800001 and FirstRecoveryForkID:
VERBOSE: [13:43:37][Restore-DbaDatabase] VerifyOnly = False
VERBOSE: [13:43:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:43:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:43:37][Test-DbaBackupInformation] Testing restore for FootPrints
VERBOSE: [13:43:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:43:37][Test-DbaBackupInformation] VerifyOnly = False
VERBOSE: [13:43:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:43:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:43:38][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:43:38][Test-DbaLsnChain] Testing LSN Chain
VERBOSE: [13:43:38][Test-DbaLsnChain] Testing LSN Chain - Type Type
VERBOSE: [13:43:38][Test-DbaLsnChain] Passed LSN Chain checks
VERBOSE: [13:43:38][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:43:38][Test-DbaBackupInformation] Marking FootPrints as verified
VERBOSE: [13:43:38][Restore-DbaDatabase] FootPrints passed testing
VERBOSE: [13:43:38][Restore-DbaDatabase] Passing in to restore
VERBOSE: [13:43:38][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:43:38][Invoke-DbaAdvancedRestore] Performing restore action
VERBOSE: [13:45:56][Invoke-DbaAdvancedRestore] Succeeded, Closing Server connection
VERBOSE: [13:45:56][Copy-DbaDatabase] Successfully restored FootPrints to SQLEDTN01.
VERBOSE: [13:45:56][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\FootPrints_202207111341-1-of-3.bak.
VERBOSE: [13:45:56][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\FootPrints_202207111341-2-of-3.bak.
VERBOSE: [13:45:56][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\FootPrints_202207111341-3-of-3.bak.
VERBOSE: [13:45:56][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:56][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:56][Copy-DbaDatabase] Finished: 07/11/2022 13:45:56.
VERBOSE: [13:45:56][Copy-DbaDatabase] Elapsed time: 00:04:05.
VERBOSE: [13:45:56][Copy-DbaDatabase]
######### Database: FPReports #########
VERBOSE: [13:45:57][Copy-DbaDatabase] Checking for accessibility.
VERBOSE: [13:45:57][Copy-DbaDatabase] Checking Availability Group status.
VERBOSE: [13:45:57][Copy-DbaDatabase] Started: 07/11/2022 13:45:57.
VERBOSE: [13:45:57][Backup-DbaDatabase] Setting Default timestampformat
VERBOSE: [13:45:57][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:57][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:45:57][Backup-DbaDatabase] 1 database to backup
VERBOSE: [13:45:57][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:57][Backup-DbaDatabase] Backup database [FPReports]
VERBOSE: [13:45:57][Backup-DbaDatabase] Creating full backup
VERBOSE: [13:45:57][Backup-DbaDatabase] Building file name
VERBOSE: [13:45:57][Backup-DbaDatabase] Setting filename - 202207111345
VERBOSE: [13:45:57][Backup-DbaDatabase] Building backup path
VERBOSE: [13:45:57][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:58][Backup-DbaDatabase] Devices added
VERBOSE: [13:45:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:59][Get-DbaDbBackupHistory] Processing FPReports
VERBOSE: [13:45:59][Get-DbaDbBackupHistory] Executing sql query on [SQLSTG01].
VERBOSE: [13:45:59][Get-DbaDbBackupHistory] Processing as grouped output.
VERBOSE: [13:45:59][Get-DbaDbBackupHistory] 3 result-groups found.
VERBOSE: [13:45:59][Copy-DbaDatabase] Reuse = False.
VERBOSE: [13:45:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:59][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:45:59][Restore-DbaDatabase] Changing statement timeout to infinity
VERBOSE: [13:45:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:59][Restore-DbaDatabase] ParameterSet = Restore
VERBOSE: [13:45:59][Restore-DbaDatabase] Trust Database Backup History Set
VERBOSE: [13:45:59][Restore-DbaDatabase] Processing DatabaseName - FPReports
VERBOSE: [13:45:59][Format-DbaBackupInformation] Starting
VERBOSE: [13:45:59][Format-DbaBackupInformation] String passed in for DB rename
VERBOSE: [13:45:59][Format-DbaBackupInformation] New DbName (String) = FPReports
VERBOSE: [13:45:59][Format-DbaBackupInformation] 1 PhysicalName = E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\FPReports.mdf
VERBOSE: [13:45:59][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\FPReports.mdf
VERBOSE: [13:45:59][Format-DbaBackupInformation] 1 PhysicalName = F:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\FPReports_log.ldf
VERBOSE: [13:45:59][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\FPReports_log.ldf
VERBOSE: [13:45:59][Select-DbaBackupInformation] Filtering by DatabaseName
VERBOSE: [13:45:59][Select-DbaBackupInformation] processing diffs
VERBOSE: [13:45:59][Select-DbaBackupInformation] Found LogBaseLsn: 242000000017700001 and FirstRecoveryForkID:
VERBOSE: [13:45:59][Restore-DbaDatabase] VerifyOnly = False
VERBOSE: [13:45:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:59][Test-DbaBackupInformation] Testing restore for FPReports
VERBOSE: [13:45:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:59][Test-DbaBackupInformation] VerifyOnly = False
VERBOSE: [13:45:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:59][Test-DbaLsnChain] Testing LSN Chain
VERBOSE: [13:45:59][Test-DbaLsnChain] Testing LSN Chain - Type Type
VERBOSE: [13:45:59][Test-DbaLsnChain] Passed LSN Chain checks
VERBOSE: [13:45:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:59][Test-DbaBackupInformation] Marking FPReports as verified
VERBOSE: [13:45:59][Restore-DbaDatabase] FPReports passed testing
VERBOSE: [13:45:59][Restore-DbaDatabase] Passing in to restore
VERBOSE: [13:45:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:45:59][Invoke-DbaAdvancedRestore] Performing restore action
VERBOSE: [13:46:00][Invoke-DbaAdvancedRestore] Succeeded, Closing Server connection
VERBOSE: [13:46:00][Copy-DbaDatabase] Successfully restored FPReports to SQLEDTN01.
VERBOSE: [13:46:00][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\FPReports_202207111345-1-of-3.bak.
VERBOSE: [13:46:00][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\FPReports_202207111345-2-of-3.bak.
VERBOSE: [13:46:00][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\FPReports_202207111345-3-of-3.bak.
VERBOSE: [13:46:00][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:46:00][Copy-DbaDatabase] Finished: 07/11/2022 13:46:00.
VERBOSE: [13:46:00][Copy-DbaDatabase] Elapsed time: 00:00:03.
VERBOSE: [13:46:00][Copy-DbaDatabase]
######### Database: HFWE #########
VERBOSE: [13:46:00][Copy-DbaDatabase] Checking for accessibility.
VERBOSE: [13:46:00][Copy-DbaDatabase] Checking Availability Group status.
VERBOSE: [13:46:00][Copy-DbaDatabase] Started: 07/11/2022 13:46:00.
VERBOSE: [13:46:00][Backup-DbaDatabase] Setting Default timestampformat
VERBOSE: [13:46:00][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:46:00][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:46:00][Backup-DbaDatabase] 1 database to backup
VERBOSE: [13:46:00][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:46:00][Backup-DbaDatabase] Backup database [HFWE]
VERBOSE: [13:46:00][Backup-DbaDatabase] Creating full backup
VERBOSE: [13:46:00][Backup-DbaDatabase] Building file name
VERBOSE: [13:46:00][Backup-DbaDatabase] Setting filename - 202207111346
VERBOSE: [13:46:00][Backup-DbaDatabase] Building backup path
VERBOSE: [13:46:00][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:46:00][Backup-DbaDatabase] Devices added
VERBOSE: [13:46:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:46:49][Get-DbaDbBackupHistory] Processing HFWE
VERBOSE: [13:46:49][Get-DbaDbBackupHistory] Executing sql query on [SQLSTG01].
VERBOSE: [13:46:49][Get-DbaDbBackupHistory] Processing as grouped output.
VERBOSE: [13:46:49][Get-DbaDbBackupHistory] 3 result-groups found.
VERBOSE: [13:46:49][Copy-DbaDatabase] Reuse = False.
VERBOSE: [13:46:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:46:49][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:46:49][Restore-DbaDatabase] Changing statement timeout to infinity
VERBOSE: [13:46:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:46:49][Restore-DbaDatabase] ParameterSet = Restore
VERBOSE: [13:46:49][Restore-DbaDatabase] Trust Database Backup History Set
VERBOSE: [13:46:49][Restore-DbaDatabase] Processing DatabaseName - HFWE
VERBOSE: [13:46:49][Format-DbaBackupInformation] Starting
VERBOSE: [13:46:49][Format-DbaBackupInformation] String passed in for DB rename
VERBOSE: [13:46:49][Format-DbaBackupInformation] New DbName (String) = HFWE
VERBOSE: [13:46:49][Format-DbaBackupInformation] 1 PhysicalName = E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\HFWE.mdf
VERBOSE: [13:46:49][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\HFWE.mdf
VERBOSE: [13:46:49][Format-DbaBackupInformation] 1 PhysicalName = F:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\HFWE.ldf
VERBOSE: [13:46:49][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\HFWE.ldf
VERBOSE: [13:46:49][Select-DbaBackupInformation] Filtering by DatabaseName
VERBOSE: [13:46:49][Select-DbaBackupInformation] processing diffs
VERBOSE: [13:46:49][Select-DbaBackupInformation] Found LogBaseLsn: 318594000000007500001 and FirstRecoveryForkID:
VERBOSE: [13:46:49][Restore-DbaDatabase] VerifyOnly = False
VERBOSE: [13:46:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:46:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:46:49][Test-DbaBackupInformation] Testing restore for HFWE
VERBOSE: [13:46:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:46:49][Test-DbaBackupInformation] VerifyOnly = False
VERBOSE: [13:46:50][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:46:50][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:46:50][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:46:50][Test-DbaLsnChain] Testing LSN Chain
VERBOSE: [13:46:50][Test-DbaLsnChain] Testing LSN Chain - Type Type
VERBOSE: [13:46:50][Test-DbaLsnChain] Passed LSN Chain checks
VERBOSE: [13:46:50][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:46:50][Test-DbaBackupInformation] Marking HFWE as verified
VERBOSE: [13:46:50][Restore-DbaDatabase] HFWE passed testing
VERBOSE: [13:46:50][Restore-DbaDatabase] Passing in to restore
VERBOSE: [13:46:50][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:46:50][Invoke-DbaAdvancedRestore] Performing restore action
VERBOSE: [13:47:55][Invoke-DbaAdvancedRestore] Succeeded, Closing Server connection
VERBOSE: [13:47:55][Copy-DbaDatabase] Successfully restored HFWE to SQLEDTN01.
VERBOSE: [13:47:55][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\HFWE_202207111346-1-of-3.bak.
VERBOSE: [13:47:55][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\HFWE_202207111346-2-of-3.bak.
VERBOSE: [13:47:55][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\HFWE_202207111346-3-of-3.bak.
VERBOSE: [13:47:55][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:55][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:55][Copy-DbaDatabase] Finished: 07/11/2022 13:47:55.
VERBOSE: [13:47:55][Copy-DbaDatabase] Elapsed time: 00:01:54.
VERBOSE: [13:47:55][Copy-DbaDatabase]
######### Database: LOGW #########
VERBOSE: [13:47:55][Copy-DbaDatabase] Checking for accessibility.
VERBOSE: [13:47:55][Copy-DbaDatabase] Checking Availability Group status.
VERBOSE: [13:47:55][Copy-DbaDatabase] Started: 07/11/2022 13:47:55.
VERBOSE: [13:47:55][Backup-DbaDatabase] Setting Default timestampformat
VERBOSE: [13:47:55][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:55][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:47:55][Backup-DbaDatabase] 1 database to backup
VERBOSE: [13:47:56][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:56][Backup-DbaDatabase] Backup database [LOGW]
VERBOSE: [13:47:56][Backup-DbaDatabase] Creating full backup
VERBOSE: [13:47:56][Backup-DbaDatabase] Building file name
VERBOSE: [13:47:56][Backup-DbaDatabase] Setting filename - 202207111347
VERBOSE: [13:47:56][Backup-DbaDatabase] Building backup path
VERBOSE: [13:47:56][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:56][Backup-DbaDatabase] Devices added
VERBOSE: [13:47:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:58][Get-DbaDbBackupHistory] Processing LOGW
VERBOSE: [13:47:58][Get-DbaDbBackupHistory] Executing sql query on [SQLSTG01].
VERBOSE: [13:47:58][Get-DbaDbBackupHistory] Processing as grouped output.
VERBOSE: [13:47:58][Get-DbaDbBackupHistory] 3 result-groups found.
VERBOSE: [13:47:59][Copy-DbaDatabase] Reuse = False.
VERBOSE: [13:47:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:59][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:47:59][Restore-DbaDatabase] Changing statement timeout to infinity
VERBOSE: [13:47:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:59][Restore-DbaDatabase] ParameterSet = Restore
VERBOSE: [13:47:59][Restore-DbaDatabase] Trust Database Backup History Set
VERBOSE: [13:47:59][Restore-DbaDatabase] Processing DatabaseName - LOGW
VERBOSE: [13:47:59][Format-DbaBackupInformation] Starting
VERBOSE: [13:47:59][Format-DbaBackupInformation] String passed in for DB rename
VERBOSE: [13:47:59][Format-DbaBackupInformation] New DbName (String) = LOGW
VERBOSE: [13:47:59][Format-DbaBackupInformation] 1 PhysicalName = E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\LOGW.mdf
VERBOSE: [13:47:59][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\LOGW.mdf
VERBOSE: [13:47:59][Format-DbaBackupInformation] 1 PhysicalName = F:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\LOGW.ldf
VERBOSE: [13:47:59][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\LOGW.ldf
VERBOSE: [13:47:59][Select-DbaBackupInformation] Filtering by DatabaseName
VERBOSE: [13:47:59][Select-DbaBackupInformation] processing diffs
VERBOSE: [13:47:59][Select-DbaBackupInformation] Found LogBaseLsn: 125000000153600001 and FirstRecoveryForkID:
VERBOSE: [13:47:59][Restore-DbaDatabase] VerifyOnly = False
VERBOSE: [13:47:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:59][Test-DbaBackupInformation] Testing restore for LOGW
VERBOSE: [13:47:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:59][Test-DbaBackupInformation] VerifyOnly = False
VERBOSE: [13:47:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:59][Test-DbaLsnChain] Testing LSN Chain
VERBOSE: [13:47:59][Test-DbaLsnChain] Testing LSN Chain - Type Type
VERBOSE: [13:47:59][Test-DbaLsnChain] Passed LSN Chain checks
VERBOSE: [13:47:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:59][Test-DbaBackupInformation] Marking LOGW as verified
VERBOSE: [13:47:59][Restore-DbaDatabase] LOGW passed testing
VERBOSE: [13:47:59][Restore-DbaDatabase] Passing in to restore
VERBOSE: [13:47:59][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:47:59][Invoke-DbaAdvancedRestore] Performing restore action
VERBOSE: [13:48:00][Invoke-DbaAdvancedRestore] Succeeded, Closing Server connection
VERBOSE: [13:48:00][Copy-DbaDatabase] Successfully restored LOGW to SQLEDTN01.
VERBOSE: [13:48:00][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\LOGW_202207111347-1-of-3.bak.
VERBOSE: [13:48:00][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\LOGW_202207111347-2-of-3.bak.
VERBOSE: [13:48:00][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\LOGW_202207111347-3-of-3.bak.
VERBOSE: [13:48:00][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:00][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:00][Copy-DbaDatabase] Finished: 07/11/2022 13:48:00.
VERBOSE: [13:48:00][Copy-DbaDatabase] Elapsed time: 00:00:05.
VERBOSE: [13:48:00][Copy-DbaDatabase]
######### Database: SP_DAC #########
VERBOSE: [13:48:00][Copy-DbaDatabase] Checking for accessibility.
VERBOSE: [13:48:00][Copy-DbaDatabase] Checking Availability Group status.
VERBOSE: [13:48:00][Copy-DbaDatabase] Started: 07/11/2022 13:48:00.
VERBOSE: [13:48:00][Backup-DbaDatabase] Setting Default timestampformat
VERBOSE: [13:48:00][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:00][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:48:01][Backup-DbaDatabase] 1 database to backup
VERBOSE: [13:48:01][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:01][Backup-DbaDatabase] Backup database [SP_DAC]
VERBOSE: [13:48:01][Backup-DbaDatabase] Creating full backup
VERBOSE: [13:48:01][Backup-DbaDatabase] Building file name
VERBOSE: [13:48:01][Backup-DbaDatabase] Setting filename - 202207111348
VERBOSE: [13:48:01][Backup-DbaDatabase] Building backup path
VERBOSE: [13:48:01][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:01][Backup-DbaDatabase] Devices added
VERBOSE: [13:48:02][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:02][Get-DbaDbBackupHistory] Processing SP_DAC
VERBOSE: [13:48:02][Get-DbaDbBackupHistory] Executing sql query on [SQLSTG01].
VERBOSE: [13:48:02][Get-DbaDbBackupHistory] Processing as grouped output.
VERBOSE: [13:48:02][Get-DbaDbBackupHistory] 3 result-groups found.
VERBOSE: [13:48:02][Copy-DbaDatabase] Reuse = False.
VERBOSE: [13:48:02][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:02][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:48:02][Restore-DbaDatabase] Changing statement timeout to infinity
VERBOSE: [13:48:02][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:02][Restore-DbaDatabase] ParameterSet = Restore
VERBOSE: [13:48:02][Restore-DbaDatabase] Trust Database Backup History Set
VERBOSE: [13:48:02][Restore-DbaDatabase] Processing DatabaseName - SP_DAC
VERBOSE: [13:48:02][Format-DbaBackupInformation] Starting
VERBOSE: [13:48:02][Format-DbaBackupInformation] String passed in for DB rename
VERBOSE: [13:48:02][Format-DbaBackupInformation] New DbName (String) = SP_DAC
VERBOSE: [13:48:02][Format-DbaBackupInformation] 1 PhysicalName = E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\SP_DAC.mdf
VERBOSE: [13:48:02][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SP_DAC.mdf
VERBOSE: [13:48:02][Format-DbaBackupInformation] 1 PhysicalName = F:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\SP_DAC_log.ldf
VERBOSE: [13:48:02][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SP_DAC_log.ldf
VERBOSE: [13:48:02][Select-DbaBackupInformation] Filtering by DatabaseName
VERBOSE: [13:48:02][Select-DbaBackupInformation] processing diffs
VERBOSE: [13:48:02][Select-DbaBackupInformation] Found LogBaseLsn: 635000000002300001 and FirstRecoveryForkID:
VERBOSE: [13:48:02][Restore-DbaDatabase] VerifyOnly = False
VERBOSE: [13:48:02][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:02][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:02][Test-DbaBackupInformation] Testing restore for SP_DAC
VERBOSE: [13:48:02][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:02][Test-DbaBackupInformation] VerifyOnly = False
VERBOSE: [13:48:02][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:02][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:02][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:02][Test-DbaLsnChain] Testing LSN Chain
VERBOSE: [13:48:02][Test-DbaLsnChain] Testing LSN Chain - Type Type
VERBOSE: [13:48:02][Test-DbaLsnChain] Passed LSN Chain checks
VERBOSE: [13:48:02][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:03][Test-DbaBackupInformation] Marking SP_DAC as verified
VERBOSE: [13:48:03][Restore-DbaDatabase] SP_DAC passed testing
VERBOSE: [13:48:03][Restore-DbaDatabase] Passing in to restore
VERBOSE: [13:48:03][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:03][Invoke-DbaAdvancedRestore] Performing restore action
VERBOSE: [13:48:03][Invoke-DbaAdvancedRestore] Succeeded, Closing Server connection
VERBOSE: [13:48:03][Copy-DbaDatabase] Successfully restored SP_DAC to SQLEDTN01.
VERBOSE: [13:48:03][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SP_DAC_202207111348-1-of-3.bak.
VERBOSE: [13:48:03][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SP_DAC_202207111348-2-of-3.bak.
VERBOSE: [13:48:03][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SP_DAC_202207111348-3-of-3.bak.
VERBOSE: [13:48:03][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:03][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:03][Copy-DbaDatabase] Finished: 07/11/2022 13:48:03.
VERBOSE: [13:48:03][Copy-DbaDatabase] Elapsed time: 00:00:03.
VERBOSE: [13:48:03][Copy-DbaDatabase]
######### Database: SP_DAEP #########
VERBOSE: [13:48:03][Copy-DbaDatabase] Checking for accessibility.
VERBOSE: [13:48:03][Copy-DbaDatabase] Checking Availability Group status.
VERBOSE: [13:48:03][Copy-DbaDatabase] Started: 07/11/2022 13:48:03.
VERBOSE: [13:48:03][Backup-DbaDatabase] Setting Default timestampformat
VERBOSE: [13:48:03][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:03][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:48:04][Backup-DbaDatabase] 1 database to backup
VERBOSE: [13:48:04][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:04][Backup-DbaDatabase] Backup database [SP_DAEP]
VERBOSE: [13:48:04][Backup-DbaDatabase] Creating full backup
VERBOSE: [13:48:04][Backup-DbaDatabase] Building file name
VERBOSE: [13:48:04][Backup-DbaDatabase] Setting filename - 202207111348
VERBOSE: [13:48:04][Backup-DbaDatabase] Building backup path
VERBOSE: [13:48:04][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:04][Backup-DbaDatabase] Devices added
VERBOSE: [13:48:05][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:06][Get-DbaDbBackupHistory] Processing SP_DAEP
VERBOSE: [13:48:06][Get-DbaDbBackupHistory] Executing sql query on [SQLSTG01].
VERBOSE: [13:48:06][Get-DbaDbBackupHistory] Processing as grouped output.
VERBOSE: [13:48:06][Get-DbaDbBackupHistory] 3 result-groups found.
VERBOSE: [13:48:06][Copy-DbaDatabase] Reuse = False.
VERBOSE: [13:48:06][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:06][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:48:06][Restore-DbaDatabase] Changing statement timeout to infinity
VERBOSE: [13:48:06][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:06][Restore-DbaDatabase] ParameterSet = Restore
VERBOSE: [13:48:06][Restore-DbaDatabase] Trust Database Backup History Set
VERBOSE: [13:48:06][Restore-DbaDatabase] Processing DatabaseName - SP_DAEP
VERBOSE: [13:48:06][Format-DbaBackupInformation] Starting
VERBOSE: [13:48:06][Format-DbaBackupInformation] String passed in for DB rename
VERBOSE: [13:48:06][Format-DbaBackupInformation] New DbName (String) = SP_DAEP
VERBOSE: [13:48:06][Format-DbaBackupInformation] 1 PhysicalName = E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\SP_DAEP.mdf
VERBOSE: [13:48:06][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SP_DAEP.mdf
VERBOSE: [13:48:06][Format-DbaBackupInformation] 1 PhysicalName = F:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\SP_DAEP_log.ldf
VERBOSE: [13:48:06][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SP_DAEP_log.ldf
VERBOSE: [13:48:06][Select-DbaBackupInformation] Filtering by DatabaseName
VERBOSE: [13:48:06][Select-DbaBackupInformation] processing diffs
VERBOSE: [13:48:06][Select-DbaBackupInformation] Found LogBaseLsn: 87000000583400001 and FirstRecoveryForkID:
VERBOSE: [13:48:06][Restore-DbaDatabase] VerifyOnly = False
VERBOSE: [13:48:06][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:06][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:06][Test-DbaBackupInformation] Testing restore for SP_DAEP
VERBOSE: [13:48:06][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:06][Test-DbaBackupInformation] VerifyOnly = False
VERBOSE: [13:48:06][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:06][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:06][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:06][Test-DbaLsnChain] Testing LSN Chain
VERBOSE: [13:48:06][Test-DbaLsnChain] Testing LSN Chain - Type Type
VERBOSE: [13:48:06][Test-DbaLsnChain] Passed LSN Chain checks
VERBOSE: [13:48:06][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:06][Test-DbaBackupInformation] Marking SP_DAEP as verified
VERBOSE: [13:48:06][Restore-DbaDatabase] SP_DAEP passed testing
VERBOSE: [13:48:06][Restore-DbaDatabase] Passing in to restore
VERBOSE: [13:48:06][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:06][Invoke-DbaAdvancedRestore] Performing restore action
VERBOSE: [13:48:07][Invoke-DbaAdvancedRestore] Succeeded, Closing Server connection
VERBOSE: [13:48:07][Copy-DbaDatabase] Successfully restored SP_DAEP to SQLEDTN01.
VERBOSE: [13:48:07][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SP_DAEP_202207111348-1-of-3.bak.
VERBOSE: [13:48:07][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SP_DAEP_202207111348-2-of-3.bak.
VERBOSE: [13:48:07][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SP_DAEP_202207111348-3-of-3.bak.
VERBOSE: [13:48:07][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:07][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:07][Copy-DbaDatabase] Finished: 07/11/2022 13:48:07.
VERBOSE: [13:48:07][Copy-DbaDatabase] Elapsed time: 00:00:04.
VERBOSE: [13:48:07][Copy-DbaDatabase]
######### Database: SP_MAS #########
VERBOSE: [13:48:07][Copy-DbaDatabase] Checking for accessibility.
VERBOSE: [13:48:07][Copy-DbaDatabase] Checking Availability Group status.
VERBOSE: [13:48:07][Copy-DbaDatabase] Started: 07/11/2022 13:48:07.
VERBOSE: [13:48:07][Backup-DbaDatabase] Setting Default timestampformat
VERBOSE: [13:48:07][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:07][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:48:08][Backup-DbaDatabase] 1 database to backup
VERBOSE: [13:48:08][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:08][Backup-DbaDatabase] Backup database [SP_MAS]
VERBOSE: [13:48:08][Backup-DbaDatabase] Creating full backup
VERBOSE: [13:48:08][Backup-DbaDatabase] Building file name
VERBOSE: [13:48:08][Backup-DbaDatabase] Setting filename - 202207111348
VERBOSE: [13:48:08][Backup-DbaDatabase] Building backup path
VERBOSE: [13:48:08][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:08][Backup-DbaDatabase] Devices added
VERBOSE: [13:48:10][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:10][Get-DbaDbBackupHistory] Processing SP_MAS
VERBOSE: [13:48:10][Get-DbaDbBackupHistory] Executing sql query on [SQLSTG01].
VERBOSE: [13:48:10][Get-DbaDbBackupHistory] Processing as grouped output.
VERBOSE: [13:48:10][Get-DbaDbBackupHistory] 3 result-groups found.
VERBOSE: [13:48:11][Copy-DbaDatabase] Reuse = False.
VERBOSE: [13:48:11][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:11][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:48:11][Restore-DbaDatabase] Changing statement timeout to infinity
VERBOSE: [13:48:11][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:11][Restore-DbaDatabase] ParameterSet = Restore
VERBOSE: [13:48:11][Restore-DbaDatabase] Trust Database Backup History Set
VERBOSE: [13:48:11][Restore-DbaDatabase] Processing DatabaseName - SP_MAS
VERBOSE: [13:48:11][Format-DbaBackupInformation] Starting
VERBOSE: [13:48:11][Format-DbaBackupInformation] String passed in for DB rename
VERBOSE: [13:48:11][Format-DbaBackupInformation] New DbName (String) = SP_MAS
VERBOSE: [13:48:11][Format-DbaBackupInformation] 1 PhysicalName = E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\SP_MAS.mdf
VERBOSE: [13:48:11][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SP_MAS.mdf
VERBOSE: [13:48:11][Format-DbaBackupInformation] 1 PhysicalName = F:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\SP_MAS_log.ldf
VERBOSE: [13:48:11][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SP_MAS_log.ldf
VERBOSE: [13:48:11][Select-DbaBackupInformation] Filtering by DatabaseName
VERBOSE: [13:48:11][Select-DbaBackupInformation] processing diffs
VERBOSE: [13:48:11][Select-DbaBackupInformation] Found LogBaseLsn: 615000000016300001 and FirstRecoveryForkID:
VERBOSE: [13:48:11][Restore-DbaDatabase] VerifyOnly = False
VERBOSE: [13:48:11][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:11][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:11][Test-DbaBackupInformation] Testing restore for SP_MAS
VERBOSE: [13:48:11][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:11][Test-DbaBackupInformation] VerifyOnly = False
VERBOSE: [13:48:11][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:11][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:11][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:11][Test-DbaLsnChain] Testing LSN Chain
VERBOSE: [13:48:11][Test-DbaLsnChain] Testing LSN Chain - Type Type
VERBOSE: [13:48:11][Test-DbaLsnChain] Passed LSN Chain checks
VERBOSE: [13:48:11][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:11][Test-DbaBackupInformation] Marking SP_MAS as verified
VERBOSE: [13:48:11][Restore-DbaDatabase] SP_MAS passed testing
VERBOSE: [13:48:11][Restore-DbaDatabase] Passing in to restore
VERBOSE: [13:48:11][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:11][Invoke-DbaAdvancedRestore] Performing restore action
VERBOSE: [13:48:12][Invoke-DbaAdvancedRestore] Succeeded, Closing Server connection
VERBOSE: [13:48:12][Copy-DbaDatabase] Successfully restored SP_MAS to SQLEDTN01.
VERBOSE: [13:48:12][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SP_MAS_202207111348-1-of-3.bak.
VERBOSE: [13:48:12][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SP_MAS_202207111348-2-of-3.bak.
VERBOSE: [13:48:12][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SP_MAS_202207111348-3-of-3.bak.
VERBOSE: [13:48:12][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:12][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:12][Copy-DbaDatabase] Finished: 07/11/2022 13:48:12.
VERBOSE: [13:48:12][Copy-DbaDatabase] Elapsed time: 00:00:04.
VERBOSE: [13:48:12][Copy-DbaDatabase]
######### Database: SP_MSHP #########
VERBOSE: [13:48:12][Copy-DbaDatabase] Checking for accessibility.
VERBOSE: [13:48:12][Copy-DbaDatabase] Checking Availability Group status.
VERBOSE: [13:48:12][Copy-DbaDatabase] Started: 07/11/2022 13:48:12.
VERBOSE: [13:48:12][Backup-DbaDatabase] Setting Default timestampformat
VERBOSE: [13:48:12][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:12][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:48:13][Backup-DbaDatabase] 1 database to backup
VERBOSE: [13:48:13][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:13][Backup-DbaDatabase] Backup database [SP_MSHP]
VERBOSE: [13:48:13][Backup-DbaDatabase] Creating full backup
VERBOSE: [13:48:13][Backup-DbaDatabase] Building file name
VERBOSE: [13:48:13][Backup-DbaDatabase] Setting filename - 202207111348
VERBOSE: [13:48:13][Backup-DbaDatabase] Building backup path
VERBOSE: [13:48:13][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:13][Backup-DbaDatabase] Devices added
VERBOSE: [13:48:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:15][Get-DbaDbBackupHistory] Processing SP_MSHP
VERBOSE: [13:48:15][Get-DbaDbBackupHistory] Executing sql query on [SQLSTG01].
VERBOSE: [13:48:15][Get-DbaDbBackupHistory] Processing as grouped output.
VERBOSE: [13:48:15][Get-DbaDbBackupHistory] 3 result-groups found.
VERBOSE: [13:48:15][Copy-DbaDatabase] Reuse = False.
VERBOSE: [13:48:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:15][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:48:15][Restore-DbaDatabase] Changing statement timeout to infinity
VERBOSE: [13:48:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:15][Restore-DbaDatabase] ParameterSet = Restore
VERBOSE: [13:48:15][Restore-DbaDatabase] Trust Database Backup History Set
VERBOSE: [13:48:15][Restore-DbaDatabase] Processing DatabaseName - SP_MSHP
VERBOSE: [13:48:15][Format-DbaBackupInformation] Starting
VERBOSE: [13:48:15][Format-DbaBackupInformation] String passed in for DB rename
VERBOSE: [13:48:15][Format-DbaBackupInformation] New DbName (String) = SP_MSHP
VERBOSE: [13:48:15][Format-DbaBackupInformation] 1 PhysicalName = E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\SP_MSHP.mdf
VERBOSE: [13:48:15][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SP_MSHP.mdf
VERBOSE: [13:48:15][Format-DbaBackupInformation] 1 PhysicalName = F:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\SP_MSHP_log.ldf
VERBOSE: [13:48:15][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SP_MSHP_log.ldf
VERBOSE: [13:48:15][Select-DbaBackupInformation] Filtering by DatabaseName
VERBOSE: [13:48:15][Select-DbaBackupInformation] processing diffs
VERBOSE: [13:48:15][Select-DbaBackupInformation] Found LogBaseLsn: 351000000017400001 and FirstRecoveryForkID:
VERBOSE: [13:48:15][Restore-DbaDatabase] VerifyOnly = False
VERBOSE: [13:48:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:15][Test-DbaBackupInformation] Testing restore for SP_MSHP
VERBOSE: [13:48:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:15][Test-DbaBackupInformation] VerifyOnly = False
VERBOSE: [13:48:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:15][Test-DbaLsnChain] Testing LSN Chain
VERBOSE: [13:48:15][Test-DbaLsnChain] Testing LSN Chain - Type Type
VERBOSE: [13:48:15][Test-DbaLsnChain] Passed LSN Chain checks
VERBOSE: [13:48:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:15][Test-DbaBackupInformation] Marking SP_MSHP as verified
VERBOSE: [13:48:15][Restore-DbaDatabase] SP_MSHP passed testing
VERBOSE: [13:48:15][Restore-DbaDatabase] Passing in to restore
VERBOSE: [13:48:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:15][Invoke-DbaAdvancedRestore] Performing restore action
VERBOSE: [13:48:16][Invoke-DbaAdvancedRestore] Succeeded, Closing Server connection
VERBOSE: [13:48:16][Copy-DbaDatabase] Successfully restored SP_MSHP to SQLEDTN01.
VERBOSE: [13:48:16][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SP_MSHP_202207111348-1-of-3.bak.
VERBOSE: [13:48:16][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SP_MSHP_202207111348-2-of-3.bak.
VERBOSE: [13:48:16][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SP_MSHP_202207111348-3-of-3.bak.
VERBOSE: [13:48:17][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:17][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:17][Copy-DbaDatabase] Finished: 07/11/2022 13:48:17.
VERBOSE: [13:48:17][Copy-DbaDatabase] Elapsed time: 00:00:04.
VERBOSE: [13:48:17][Copy-DbaDatabase]
######### Database: SP_SWAV #########
VERBOSE: [13:48:17][Copy-DbaDatabase] Checking for accessibility.
VERBOSE: [13:48:17][Copy-DbaDatabase] Checking Availability Group status.
VERBOSE: [13:48:17][Copy-DbaDatabase] Started: 07/11/2022 13:48:17.
VERBOSE: [13:48:17][Backup-DbaDatabase] Setting Default timestampformat
VERBOSE: [13:48:17][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:17][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:48:17][Backup-DbaDatabase] 1 database to backup
VERBOSE: [13:48:17][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:17][Backup-DbaDatabase] Backup database [SP_SWAV]
VERBOSE: [13:48:17][Backup-DbaDatabase] Creating full backup
VERBOSE: [13:48:17][Backup-DbaDatabase] Building file name
VERBOSE: [13:48:17][Backup-DbaDatabase] Setting filename - 202207111348
VERBOSE: [13:48:17][Backup-DbaDatabase] Building backup path
VERBOSE: [13:48:17][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:17][Backup-DbaDatabase] Devices added
VERBOSE: [13:48:18][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:18][Get-DbaDbBackupHistory] Processing SP_SWAV
VERBOSE: [13:48:18][Get-DbaDbBackupHistory] Executing sql query on [SQLSTG01].
VERBOSE: [13:48:18][Get-DbaDbBackupHistory] Processing as grouped output.
VERBOSE: [13:48:18][Get-DbaDbBackupHistory] 3 result-groups found.
VERBOSE: [13:48:18][Copy-DbaDatabase] Reuse = False.
VERBOSE: [13:48:18][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:18][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:48:18][Restore-DbaDatabase] Changing statement timeout to infinity
VERBOSE: [13:48:18][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:18][Restore-DbaDatabase] ParameterSet = Restore
VERBOSE: [13:48:18][Restore-DbaDatabase] Trust Database Backup History Set
VERBOSE: [13:48:18][Restore-DbaDatabase] Processing DatabaseName - SP_SWAV
VERBOSE: [13:48:18][Format-DbaBackupInformation] Starting
VERBOSE: [13:48:18][Format-DbaBackupInformation] String passed in for DB rename
VERBOSE: [13:48:18][Format-DbaBackupInformation] New DbName (String) = SP_SWAV
VERBOSE: [13:48:18][Format-DbaBackupInformation] 1 PhysicalName = E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\SP_SWAV.mdf
VERBOSE: [13:48:18][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SP_SWAV.mdf
VERBOSE: [13:48:18][Format-DbaBackupInformation] 1 PhysicalName = F:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\SP_SWAV_log.ldf
VERBOSE: [13:48:18][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SP_SWAV_log.ldf
VERBOSE: [13:48:18][Select-DbaBackupInformation] Filtering by DatabaseName
VERBOSE: [13:48:18][Select-DbaBackupInformation] processing diffs
VERBOSE: [13:48:18][Select-DbaBackupInformation] Found LogBaseLsn: 431000000020300001 and FirstRecoveryForkID:
VERBOSE: [13:48:18][Restore-DbaDatabase] VerifyOnly = False
VERBOSE: [13:48:18][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:18][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:18][Test-DbaBackupInformation] Testing restore for SP_SWAV
VERBOSE: [13:48:18][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:19][Test-DbaBackupInformation] VerifyOnly = False
VERBOSE: [13:48:19][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:19][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:19][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:19][Test-DbaLsnChain] Testing LSN Chain
VERBOSE: [13:48:19][Test-DbaLsnChain] Testing LSN Chain - Type Type
VERBOSE: [13:48:19][Test-DbaLsnChain] Passed LSN Chain checks
VERBOSE: [13:48:19][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:19][Test-DbaBackupInformation] Marking SP_SWAV as verified
VERBOSE: [13:48:19][Restore-DbaDatabase] SP_SWAV passed testing
VERBOSE: [13:48:19][Restore-DbaDatabase] Passing in to restore
VERBOSE: [13:48:19][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:19][Invoke-DbaAdvancedRestore] Performing restore action
VERBOSE: [13:48:19][Invoke-DbaAdvancedRestore] Succeeded, Closing Server connection
VERBOSE: [13:48:19][Copy-DbaDatabase] Successfully restored SP_SWAV to SQLEDTN01.
VERBOSE: [13:48:19][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SP_SWAV_202207111348-1-of-3.bak.
VERBOSE: [13:48:19][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SP_SWAV_202207111348-2-of-3.bak.
VERBOSE: [13:48:20][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SP_SWAV_202207111348-3-of-3.bak.
VERBOSE: [13:48:20][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:20][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:20][Copy-DbaDatabase] Finished: 07/11/2022 13:48:20.
VERBOSE: [13:48:20][Copy-DbaDatabase] Elapsed time: 00:00:02.
VERBOSE: [13:48:20][Copy-DbaDatabase]
######### Database: SPAT #########
VERBOSE: [13:48:20][Copy-DbaDatabase] Checking for accessibility.
VERBOSE: [13:48:20][Copy-DbaDatabase] Checking Availability Group status.
VERBOSE: [13:48:20][Copy-DbaDatabase] Started: 07/11/2022 13:48:20.
VERBOSE: [13:48:20][Backup-DbaDatabase] Setting Default timestampformat
VERBOSE: [13:48:20][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:20][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:48:20][Backup-DbaDatabase] 1 database to backup
VERBOSE: [13:48:20][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:20][Backup-DbaDatabase] Backup database [SPAT]
VERBOSE: [13:48:20][Backup-DbaDatabase] Creating full backup
VERBOSE: [13:48:20][Backup-DbaDatabase] Building file name
VERBOSE: [13:48:20][Backup-DbaDatabase] Setting filename - 202207111348
VERBOSE: [13:48:20][Backup-DbaDatabase] Building backup path
VERBOSE: [13:48:20][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:20][Backup-DbaDatabase] Devices added
VERBOSE: [13:48:21][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:21][Get-DbaDbBackupHistory] Processing SPAT
VERBOSE: [13:48:21][Get-DbaDbBackupHistory] Executing sql query on [SQLSTG01].
VERBOSE: [13:48:21][Get-DbaDbBackupHistory] Processing as grouped output.
VERBOSE: [13:48:21][Get-DbaDbBackupHistory] 3 result-groups found.
VERBOSE: [13:48:22][Copy-DbaDatabase] Reuse = False.
VERBOSE: [13:48:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:22][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:48:22][Restore-DbaDatabase] Changing statement timeout to infinity
VERBOSE: [13:48:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:22][Restore-DbaDatabase] ParameterSet = Restore
VERBOSE: [13:48:22][Restore-DbaDatabase] Trust Database Backup History Set
VERBOSE: [13:48:22][Restore-DbaDatabase] Processing DatabaseName - SPAT
VERBOSE: [13:48:22][Format-DbaBackupInformation] Starting
VERBOSE: [13:48:22][Format-DbaBackupInformation] String passed in for DB rename
VERBOSE: [13:48:22][Format-DbaBackupInformation] New DbName (String) = SPAT
VERBOSE: [13:48:22][Format-DbaBackupInformation] 1 PhysicalName = E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\SPAT.mdf
VERBOSE: [13:48:22][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SPAT.mdf
VERBOSE: [13:48:22][Format-DbaBackupInformation] 1 PhysicalName = F:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\SPAT.ldf
VERBOSE: [13:48:22][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SPAT.ldf
VERBOSE: [13:48:22][Select-DbaBackupInformation] Filtering by DatabaseName
VERBOSE: [13:48:22][Select-DbaBackupInformation] processing diffs
VERBOSE: [13:48:22][Select-DbaBackupInformation] Found LogBaseLsn: 391000000040500001 and FirstRecoveryForkID:
VERBOSE: [13:48:22][Restore-DbaDatabase] VerifyOnly = False
VERBOSE: [13:48:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:22][Test-DbaBackupInformation] Testing restore for SPAT
VERBOSE: [13:48:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:22][Test-DbaBackupInformation] VerifyOnly = False
VERBOSE: [13:48:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:22][Test-DbaLsnChain] Testing LSN Chain
VERBOSE: [13:48:22][Test-DbaLsnChain] Testing LSN Chain - Type Type
VERBOSE: [13:48:22][Test-DbaLsnChain] Passed LSN Chain checks
VERBOSE: [13:48:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:22][Test-DbaBackupInformation] Marking SPAT as verified
VERBOSE: [13:48:22][Restore-DbaDatabase] SPAT passed testing
VERBOSE: [13:48:22][Restore-DbaDatabase] Passing in to restore
VERBOSE: [13:48:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:22][Invoke-DbaAdvancedRestore] Performing restore action
VERBOSE: [13:48:23][Invoke-DbaAdvancedRestore] Succeeded, Closing Server connection
VERBOSE: [13:48:23][Copy-DbaDatabase] Successfully restored SPAT to SQLEDTN01.
VERBOSE: [13:48:23][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SPAT_202207111348-1-of-3.bak.
VERBOSE: [13:48:23][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SPAT_202207111348-2-of-3.bak.
VERBOSE: [13:48:23][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\SPAT_202207111348-3-of-3.bak.
VERBOSE: [13:48:23][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:23][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:23][Copy-DbaDatabase] Finished: 07/11/2022 13:48:23.
VERBOSE: [13:48:23][Copy-DbaDatabase] Elapsed time: 00:00:03.
VERBOSE: [13:48:23][Copy-DbaDatabase]
######### Database: VISITS #########
VERBOSE: [13:48:23][Copy-DbaDatabase] Checking for accessibility.
VERBOSE: [13:48:23][Copy-DbaDatabase] Checking Availability Group status.
VERBOSE: [13:48:23][Copy-DbaDatabase] Started: 07/11/2022 13:48:23.
VERBOSE: [13:48:23][Backup-DbaDatabase] Setting Default timestampformat
VERBOSE: [13:48:23][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:23][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:48:23][Backup-DbaDatabase] 1 database to backup
VERBOSE: [13:48:23][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:23][Backup-DbaDatabase] Backup database [VISITS]
VERBOSE: [13:48:23][Backup-DbaDatabase] Creating full backup
VERBOSE: [13:48:23][Backup-DbaDatabase] Building file name
VERBOSE: [13:48:23][Backup-DbaDatabase] Setting filename - 202207111348
VERBOSE: [13:48:23][Backup-DbaDatabase] Building backup path
VERBOSE: [13:48:23][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:23][Backup-DbaDatabase] Devices added
VERBOSE: [13:48:29][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:29][Get-DbaDbBackupHistory] Processing VISITS
VERBOSE: [13:48:29][Get-DbaDbBackupHistory] Executing sql query on [SQLSTG01].
VERBOSE: [13:48:29][Get-DbaDbBackupHistory] Processing as grouped output.
VERBOSE: [13:48:29][Get-DbaDbBackupHistory] 3 result-groups found.
VERBOSE: [13:48:30][Copy-DbaDatabase] Reuse = False.
VERBOSE: [13:48:30][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:30][Connect-DbaInstance] Database provided. Does not match ConnectionContext.CurrentDatabase, copying ConnectionContext and setting the CurrentDatabase
VERBOSE: [13:48:30][Restore-DbaDatabase] Changing statement timeout to infinity
VERBOSE: [13:48:30][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:30][Restore-DbaDatabase] ParameterSet = Restore
VERBOSE: [13:48:30][Restore-DbaDatabase] Trust Database Backup History Set
VERBOSE: [13:48:30][Restore-DbaDatabase] Processing DatabaseName - VISITS
VERBOSE: [13:48:30][Format-DbaBackupInformation] Starting
VERBOSE: [13:48:30][Format-DbaBackupInformation] String passed in for DB rename
VERBOSE: [13:48:30][Format-DbaBackupInformation] New DbName (String) = VISITS
VERBOSE: [13:48:30][Format-DbaBackupInformation] 1 PhysicalName = E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\VISITS.mdf
VERBOSE: [13:48:30][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\VISITS.mdf
VERBOSE: [13:48:30][Format-DbaBackupInformation] 1 PhysicalName = F:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\VISITS.ldf
VERBOSE: [13:48:30][Format-DbaBackupInformation] PhysicalName = D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\VISITS.ldf
VERBOSE: [13:48:30][Select-DbaBackupInformation] Filtering by DatabaseName
VERBOSE: [13:48:30][Select-DbaBackupInformation] processing diffs
VERBOSE: [13:48:30][Select-DbaBackupInformation] Found LogBaseLsn: 18692000001099400001 and FirstRecoveryForkID:
VERBOSE: [13:48:30][Restore-DbaDatabase] VerifyOnly = False
VERBOSE: [13:48:30][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:30][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:30][Test-DbaBackupInformation] Testing restore for VISITS
VERBOSE: [13:48:30][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:30][Test-DbaBackupInformation] VerifyOnly = False
VERBOSE: [13:48:30][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:30][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:30][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:30][Test-DbaLsnChain] Testing LSN Chain
VERBOSE: [13:48:30][Test-DbaLsnChain] Testing LSN Chain - Type Type
VERBOSE: [13:48:30][Test-DbaLsnChain] Passed LSN Chain checks
VERBOSE: [13:48:30][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:30][Test-DbaBackupInformation] Marking VISITS as verified
VERBOSE: [13:48:30][Restore-DbaDatabase] VISITS passed testing
VERBOSE: [13:48:30][Restore-DbaDatabase] Passing in to restore
VERBOSE: [13:48:30][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:30][Invoke-DbaAdvancedRestore] Performing restore action
VERBOSE: [13:48:34][Invoke-DbaAdvancedRestore] Succeeded, Closing Server connection
VERBOSE: [13:48:34][Copy-DbaDatabase] Successfully restored VISITS to SQLEDTN01.
VERBOSE: [13:48:34][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\VISITS_202207111348-1-of-3.bak.
VERBOSE: [13:48:34][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\VISITS_202207111348-2-of-3.bak.
VERBOSE: [13:48:34][Copy-DbaDatabase] Deleting \ad.XXXXXX.org\shares\Backup\EA_Archive\Migration\SQLSTG01\VISITS_202207111348-3-of-3.bak.
VERBOSE: [13:48:34][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:34][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:34][Copy-DbaDatabase] Finished: 07/11/2022 13:48:34.
VERBOSE: [13:48:34][Copy-DbaDatabase] Elapsed time: 00:00:11.
VERBOSE: [13:48:34][Copy-DbaDatabase]
Database migration finished
VERBOSE: [13:48:34][Copy-DbaDatabase] Migration started: 07/11/2022 13:01:30
VERBOSE: [13:48:34][Copy-DbaDatabase] Migration completed: 07/11/2022 13:48:34
VERBOSE: [13:48:34][Copy-DbaDatabase] Total Elapsed time: 00:47:03
VERBOSE: [13:48:34][Start-DbaMigration] Migrating logins
VERBOSE: [13:48:34][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:34][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:34][Get-DbaLogin] Processing [##MS_PolicyEventProcessingLogin##] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [##MS_PolicyTsqlExecutionLogin##] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [AD\CESPINOS] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [AD\DBA Admins] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [AD\DBA Admins - IEO] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [AD\DBAGNEW] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [AD\Dot Net Devs] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [AD\GMARKS] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [AD\HFWE_STG_APP_ACCT] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [AD\JKOPPISE] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [AD\KBROWN20] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [AD\RSTONELO] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [AD\WAPPSTGAPP01$] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [AD\WAPPSTGAPP02$] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [AD\WAPPSTGWEB01$] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [AD\WAPPSTGWEB02$] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [ASPNetClient] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [BWDBREMOTE] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [jherna26] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [NT AUTHORITY\SYSTEM] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [NT SERVICE\MSSQLSERVER] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [NT SERVICE\SQLSERVERAGENT] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [NT SERVICE\SQLTELEMETRY] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [NT SERVICE\SQLWriter] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [NT SERVICE\Winmgmt] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [PII_Admin] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [sa] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [SecurityProvider] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [tadsuser] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [u_AS400] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [u_CCCv2] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [u_DAC] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [u_DAEP] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [u_DataServices] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [u_HEALTH] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [u_HFWE] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [u_HSIS] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [u_MAS] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [u_MSHP] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [u_PEIMS] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [u_SPAT] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [u_SWAV] on SQLSTG01
VERBOSE: [13:48:34][Get-DbaLogin] Processing [visits] on SQLSTG01
VERBOSE: [13:48:34][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:34][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:34][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:34][Copy-Login] Skipping ##MS_PolicyEventProcessingLogin##.
VERBOSE: [13:48:34][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:34][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:34][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:34][Copy-Login] Skipping ##MS_PolicyTsqlExecutionLogin##.
VERBOSE: [13:48:34][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:34][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:35][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:35][Copy-Login] Attempting to add AD\CESPINOS to SQLEDTN01.
VERBOSE: [13:48:35][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:35][New-DbaLogin] Setting AD\CESPINOS default database to master
VERBOSE: [13:48:35][New-DbaLogin] Setting AD\CESPINOS language to us_english
VERBOSE: [13:48:35][New-DbaLogin] Setting AD\CESPINOS DenyWindowsLogin to True
VERBOSE: [13:48:35][New-DbaLogin] Adding as login type WindowsUser
VERBOSE: [13:48:35][New-DbaLogin] Failed to create AD\CESPINOS on SQLEDTN01 using SMO, trying T-SQL.
VERBOSE: [13:48:35][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:35][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:35][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:35][Copy-Login] Attempting to add AD\DBA Admins to SQLEDTN01.
VERBOSE: [13:48:35][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:35][New-DbaLogin] Setting AD\DBA Admins default database to master
VERBOSE: [13:48:35][New-DbaLogin] Setting AD\DBA Admins language to us_english
VERBOSE: [13:48:35][New-DbaLogin] Adding as login type WindowsGroup
VERBOSE: [13:48:35][New-DbaLogin] Successfully added AD\DBA Admins to SQLEDTN01.
VERBOSE: [13:48:35][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:35][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:35][Get-DbaLogin] Processing [AD\DBA Admins] on SQLEDTN01
VERBOSE: [13:48:35][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:35][Update-SqlPermission] Adding AD\DBA Admins to sysadmin server role on SQLEDTN01 successfully performed.
VERBOSE: [13:48:35][Update-SqlPermission] Grant CONNECT SQL to AD\DBA Admins on SQLEDTN01 successfully performed.
VERBOSE: [13:48:36][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:36][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:36][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:36][Copy-Login] Attempting to add AD\DBA Admins - IEO to SQLEDTN01.
VERBOSE: [13:48:36][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:36][New-DbaLogin] Setting AD\DBA Admins - IEO default database to master
VERBOSE: [13:48:36][New-DbaLogin] Setting AD\DBA Admins - IEO language to us_english
VERBOSE: [13:48:36][New-DbaLogin] Adding as login type WindowsGroup
VERBOSE: [13:48:36][New-DbaLogin] Successfully added AD\DBA Admins - IEO to SQLEDTN01.
VERBOSE: [13:48:36][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:36][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:36][Get-DbaLogin] Processing [AD\DBA Admins - IEO] on SQLEDTN01
VERBOSE: [13:48:36][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:36][Update-SqlPermission] Adding AD\DBA Admins - IEO to sysadmin server role on SQLEDTN01 successfully performed.
VERBOSE: [13:48:36][Update-SqlPermission] Grant CONNECT SQL to AD\DBA Admins - IEO on SQLEDTN01 successfully performed.
VERBOSE: [13:48:36][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:36][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:36][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:36][Copy-Login] Attempting to add AD\DBAGNEW to SQLEDTN01.
VERBOSE: [13:48:36][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:36][New-DbaLogin] Setting AD\DBAGNEW default database to master
VERBOSE: [13:48:36][New-DbaLogin] Adding as login type WindowsUser
VERBOSE: [13:48:36][New-DbaLogin] Successfully added AD\DBAGNEW to SQLEDTN01.
VERBOSE: [13:48:36][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:36][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:36][Get-DbaLogin] Processing [AD\DBAGNEW] on SQLEDTN01
VERBOSE: [13:48:36][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:36][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:37][Set-DbaDbOwner] Setting database owner for DBA to AD\DBAGNEW on SQLEDTN01.
VERBOSE: [13:48:37][Update-SqlPermission] Changed DBA owner to AD\DBAGNEW.
VERBOSE: [13:48:37][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:37][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:37][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:37][Copy-Login] Attempting to add AD\Dot Net Devs to SQLEDTN01.
VERBOSE: [13:48:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:37][New-DbaLogin] Setting AD\Dot Net Devs default database to master
VERBOSE: [13:48:37][New-DbaLogin] Setting AD\Dot Net Devs language to us_english
VERBOSE: [13:48:37][New-DbaLogin] Adding as login type WindowsGroup
VERBOSE: [13:48:37][New-DbaLogin] Successfully added AD\Dot Net Devs to SQLEDTN01.
VERBOSE: [13:48:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:37][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:37][Get-DbaLogin] Processing [AD\Dot Net Devs] on SQLEDTN01
VERBOSE: [13:48:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:38][Update-SqlPermission] Grant CONNECT SQL to AD\Dot Net Devs on SQLEDTN01 successfully performed.
VERBOSE: [13:48:38][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:38][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:38][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:38][Copy-Login] Attempting to add AD\GMARKS to SQLEDTN01.
WARNING: [13:48:38][Copy-Login] Database DAEP does not exist on [SQLEDTN01], switching DefaultDatabase to 'master' for AD\GMARKS
VERBOSE: [13:48:38][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:38][New-DbaLogin] Setting AD\GMARKS default database to master
VERBOSE: [13:48:38][New-DbaLogin] Setting AD\GMARKS language to us_english
VERBOSE: [13:48:38][New-DbaLogin] Adding as login type WindowsUser
VERBOSE: [13:48:38][New-DbaLogin] Successfully added AD\GMARKS to SQLEDTN01.
VERBOSE: [13:48:38][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:38][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:38][Get-DbaLogin] Processing [AD\GMARKS] on SQLEDTN01
VERBOSE: [13:48:38][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:38][Update-SqlPermission] Grant CONNECT SQL to AD\GMARKS on SQLEDTN01 successfully performed.
VERBOSE: [13:48:38][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:38][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:39][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:39][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:39][Update-SqlPermission] Grant on CONNECT to AD\GMARKS on SP_MAS on SQLEDTN01 successfully performed.
VERBOSE: [13:48:39][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:39][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:39][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:39][Copy-Login] Attempting to add AD\HFWE_STG_APP_ACCT to SQLEDTN01.
VERBOSE: [13:48:39][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:39][New-DbaLogin] Setting AD\HFWE_STG_APP_ACCT default database to HFWE
VERBOSE: [13:48:39][New-DbaLogin] Setting AD\HFWE_STG_APP_ACCT language to us_english
VERBOSE: [13:48:39][New-DbaLogin] Adding as login type WindowsUser
VERBOSE: [13:48:39][New-DbaLogin] Successfully added AD\HFWE_STG_APP_ACCT to SQLEDTN01.
VERBOSE: [13:48:39][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:39][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:39][Get-DbaLogin] Processing [AD\HFWE_STG_APP_ACCT] on SQLEDTN01
VERBOSE: [13:48:39][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:39][Update-SqlPermission] Grant CONNECT SQL to AD\HFWE_STG_APP_ACCT on SQLEDTN01 successfully performed.
VERBOSE: [13:48:39][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:40][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:40][Update-SqlPermission] Grant on CONNECT to AD\HFWE_STG_APP_ACCT on HFWE on SQLEDTN01 successfully performed.
VERBOSE: [13:48:40][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:40][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:40][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:40][Copy-Login] Attempting to add AD\JKOPPISE to SQLEDTN01.
VERBOSE: [13:48:40][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:40][New-DbaLogin] Setting AD\JKOPPISE default database to master
VERBOSE: [13:48:40][New-DbaLogin] Setting AD\JKOPPISE language to us_english
VERBOSE: [13:48:40][New-DbaLogin] Adding as login type WindowsUser
VERBOSE: [13:48:40][New-DbaLogin] Failed to create AD\JKOPPISE on SQLEDTN01 using SMO, trying T-SQL.
VERBOSE: [13:48:40][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:40][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:40][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:40][Copy-Login] Attempting to add AD\KBROWN20 to SQLEDTN01.
VERBOSE: [13:48:40][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:40][New-DbaLogin] Setting AD\KBROWN20 default database to master
VERBOSE: [13:48:40][New-DbaLogin] Setting AD\KBROWN20 language to us_english
VERBOSE: [13:48:40][New-DbaLogin] Setting AD\KBROWN20 DenyWindowsLogin to True
VERBOSE: [13:48:40][New-DbaLogin] Adding as login type WindowsUser
VERBOSE: [13:48:40][New-DbaLogin] Failed to create AD\KBROWN20 on SQLEDTN01 using SMO, trying T-SQL.
VERBOSE: [13:48:40][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:40][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:40][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:40][Copy-Login] Attempting to add AD\RSTONELO to SQLEDTN01.
VERBOSE: [13:48:40][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:40][New-DbaLogin] Setting AD\RSTONELO default database to master
VERBOSE: [13:48:40][New-DbaLogin] Setting AD\RSTONELO language to us_english
VERBOSE: [13:48:40][New-DbaLogin] Adding as login type WindowsUser
VERBOSE: [13:48:40][New-DbaLogin] Failed to create AD\RSTONELO on SQLEDTN01 using SMO, trying T-SQL.
VERBOSE: [13:48:40][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:40][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:40][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:40][Copy-Login] Attempting to add AD\WAPPSTGAPP01$ to SQLEDTN01.
VERBOSE: [13:48:40][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:40][New-DbaLogin] Setting AD\WAPPSTGAPP01$ default database to master
VERBOSE: [13:48:40][New-DbaLogin] Setting AD\WAPPSTGAPP01$ language to us_english
VERBOSE: [13:48:40][New-DbaLogin] Adding as login type WindowsUser
VERBOSE: [13:48:40][New-DbaLogin] Successfully added AD\WAPPSTGAPP01$ to SQLEDTN01.
VERBOSE: [13:48:40][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:40][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:40][Get-DbaLogin] Processing [AD\WAPPSTGAPP01$] on SQLEDTN01
VERBOSE: [13:48:40][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:40][Update-SqlPermission] Grant CONNECT SQL to AD\WAPPSTGAPP01$ on SQLEDTN01 successfully performed.
VERBOSE: [13:48:41][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:41][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:41][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:41][Copy-Login] Attempting to add AD\WAPPSTGAPP02$ to SQLEDTN01.
VERBOSE: [13:48:41][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:41][New-DbaLogin] Setting AD\WAPPSTGAPP02$ default database to master
VERBOSE: [13:48:41][New-DbaLogin] Setting AD\WAPPSTGAPP02$ language to us_english
VERBOSE: [13:48:41][New-DbaLogin] Adding as login type WindowsUser
VERBOSE: [13:48:41][New-DbaLogin] Successfully added AD\WAPPSTGAPP02$ to SQLEDTN01.
VERBOSE: [13:48:41][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:41][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:41][Get-DbaLogin] Processing [AD\WAPPSTGAPP02$] on SQLEDTN01
VERBOSE: [13:48:41][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:41][Update-SqlPermission] Grant CONNECT SQL to AD\WAPPSTGAPP02$ on SQLEDTN01 successfully performed.
VERBOSE: [13:48:42][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:42][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:42][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:42][Copy-Login] Attempting to add AD\WAPPSTGWEB01$ to SQLEDTN01.
VERBOSE: [13:48:42][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:42][New-DbaLogin] Setting AD\WAPPSTGWEB01$ default database to master
VERBOSE: [13:48:42][New-DbaLogin] Setting AD\WAPPSTGWEB01$ language to us_english
VERBOSE: [13:48:42][New-DbaLogin] Adding as login type WindowsUser
VERBOSE: [13:48:42][New-DbaLogin] Successfully added AD\WAPPSTGWEB01$ to SQLEDTN01.
VERBOSE: [13:48:42][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:42][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:42][Get-DbaLogin] Processing [AD\WAPPSTGWEB01$] on SQLEDTN01
VERBOSE: [13:48:42][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:42][Update-SqlPermission] Grant CONNECT SQL to AD\WAPPSTGWEB01$ on SQLEDTN01 successfully performed.
VERBOSE: [13:48:42][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:42][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:42][Update-SqlPermission] Grant on CONNECT to AD\WAPPSTGWEB01$ on HFWE on SQLEDTN01 successfully performed.
VERBOSE: [13:48:42][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:42][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:42][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:42][Copy-Login] Attempting to add AD\WAPPSTGWEB02$ to SQLEDTN01.
VERBOSE: [13:48:42][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:42][New-DbaLogin] Setting AD\WAPPSTGWEB02$ default database to master
VERBOSE: [13:48:42][New-DbaLogin] Setting AD\WAPPSTGWEB02$ language to us_english
VERBOSE: [13:48:42][New-DbaLogin] Adding as login type WindowsUser
VERBOSE: [13:48:42][New-DbaLogin] Successfully added AD\WAPPSTGWEB02$ to SQLEDTN01.
VERBOSE: [13:48:42][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:42][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:42][Get-DbaLogin] Processing [AD\WAPPSTGWEB02$] on SQLEDTN01
VERBOSE: [13:48:42][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:43][Update-SqlPermission] Grant CONNECT SQL to AD\WAPPSTGWEB02$ on SQLEDTN01 successfully performed.
VERBOSE: [13:48:43][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:43][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:43][Update-SqlPermission] Grant on CONNECT to AD\WAPPSTGWEB02$ on HFWE on SQLEDTN01 successfully performed.
VERBOSE: [13:48:43][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:43][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:43][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:43][Copy-Login] Attempting to add ASPNetClient to SQLEDTN01.
WARNING: [13:48:43][Copy-Login] Database ASPState does not exist on [SQLEDTN01], switching DefaultDatabase to 'master' for ASPNetClient
VERBOSE: [13:48:43][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:43][New-DbaLogin] Setting ASPNetClient SID
VERBOSE: [13:48:43][New-DbaLogin] Setting ASPNetClient default database to master
VERBOSE: [13:48:43][New-DbaLogin] Setting ASPNetClient language to us_english
VERBOSE: [13:48:43][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:43][New-DbaLogin] Successfully added ASPNetClient to SQLEDTN01.
VERBOSE: [13:48:43][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:43][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:43][Get-DbaLogin] Processing [ASPNetClient] on SQLEDTN01
VERBOSE: [13:48:43][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:43][Update-SqlPermission] Grant CONNECT SQL to ASPNetClient on SQLEDTN01 successfully performed.
VERBOSE: [13:48:43][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:43][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:43][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:43][Copy-Login] Attempting to add BWDBREMOTE to SQLEDTN01.
VERBOSE: [13:48:43][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:43][New-DbaLogin] Setting BWDBREMOTE SID
VERBOSE: [13:48:43][New-DbaLogin] Setting BWDBREMOTE default database to master
VERBOSE: [13:48:43][New-DbaLogin] Setting BWDBREMOTE language to us_english
VERBOSE: [13:48:43][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:43][New-DbaLogin] Successfully added BWDBREMOTE to SQLEDTN01.
VERBOSE: [13:48:43][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:43][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:43][Get-DbaLogin] Processing [BWDBREMOTE] on SQLEDTN01
VERBOSE: [13:48:43][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:44][Update-SqlPermission] Grant CONNECT SQL to BWDBREMOTE on SQLEDTN01 successfully performed.
VERBOSE: [13:48:44][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:44][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:44][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:44][Update-SqlPermission] Grant on CONNECT to BWDBREMOTE on FootPrints on SQLEDTN01 successfully performed.
VERBOSE: [13:48:44][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:45][Update-SqlPermission] Grant on CONNECT to BWDBREMOTE on FPReports on SQLEDTN01 successfully performed.
VERBOSE: [13:48:45][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:45][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:45][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:45][Copy-Login] Attempting to add jherna26 to SQLEDTN01.
VERBOSE: [13:48:45][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:45][New-DbaLogin] Setting jherna26 SID
VERBOSE: [13:48:45][New-DbaLogin] Setting jherna26 default database to master
VERBOSE: [13:48:45][New-DbaLogin] Setting jherna26 language to us_english
VERBOSE: [13:48:45][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:45][New-DbaLogin] Successfully added jherna26 to SQLEDTN01.
VERBOSE: [13:48:45][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:45][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:45][Get-DbaLogin] Processing [jherna26] on SQLEDTN01
VERBOSE: [13:48:45][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:45][Update-SqlPermission] Adding jherna26 to sysadmin server role on SQLEDTN01 successfully performed.
VERBOSE: [13:48:45][Update-SqlPermission] Grant CONNECT SQL to jherna26 on SQLEDTN01 successfully performed.
VERBOSE: [13:48:45][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:45][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:45][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:45][Copy-Login] NT AUTHORITY\SYSTEM was skipped because it is a local machine name.
VERBOSE: [13:48:45][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:45][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:45][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:45][Copy-Login] NT SERVICE\MSSQLSERVER was skipped because it is a local machine name.
VERBOSE: [13:48:45][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:45][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:45][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:45][Copy-Login] NT SERVICE\SQLSERVERAGENT was skipped because it is a local machine name.
VERBOSE: [13:48:45][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:45][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:45][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:45][Copy-Login] NT SERVICE\SQLTELEMETRY was skipped because it is a local machine name.
VERBOSE: [13:48:45][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:45][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:45][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:45][Copy-Login] NT SERVICE\SQLWriter was skipped because it is a local machine name.
VERBOSE: [13:48:45][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:45][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:45][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:45][Copy-Login] NT SERVICE\Winmgmt was skipped because it is a local machine name.
VERBOSE: [13:48:45][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:45][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:45][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:45][Copy-Login] Attempting to add PII_Admin to SQLEDTN01.
VERBOSE: [13:48:46][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:46][New-DbaLogin] Setting PII_Admin SID
VERBOSE: [13:48:46][New-DbaLogin] Setting PII_Admin default database to master
VERBOSE: [13:48:46][New-DbaLogin] Setting PII_Admin language to us_english
VERBOSE: [13:48:46][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:46][New-DbaLogin] Successfully added PII_Admin to SQLEDTN01.
VERBOSE: [13:48:46][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:46][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:46][Get-DbaLogin] Processing [PII_Admin] on SQLEDTN01
VERBOSE: [13:48:46][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:46][Update-SqlPermission] Grant CONNECT SQL to PII_Admin on SQLEDTN01 successfully performed.
VERBOSE: [13:48:46][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:46][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:46][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:46][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:46][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:46][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:46][Copy-Login] Attempting to add SecurityProvider to SQLEDTN01.
WARNING: [13:48:46][Copy-Login] Database SecurityProvider does not exist on [SQLEDTN01], switching DefaultDatabase to 'master' for SecurityProvider
VERBOSE: [13:48:46][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:46][New-DbaLogin] Setting SecurityProvider SID
VERBOSE: [13:48:46][New-DbaLogin] Setting SecurityProvider default database to master
VERBOSE: [13:48:46][New-DbaLogin] Setting SecurityProvider language to us_english
VERBOSE: [13:48:46][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:46][New-DbaLogin] Successfully added SecurityProvider to SQLEDTN01.
VERBOSE: [13:48:46][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:46][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:46][Get-DbaLogin] Processing [SecurityProvider] on SQLEDTN01
VERBOSE: [13:48:46][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:46][Update-SqlPermission] Grant CONNECT SQL to SecurityProvider on SQLEDTN01 successfully performed.
VERBOSE: [13:48:46][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:46][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:46][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:46][Copy-Login] Attempting to add tadsuser to SQLEDTN01.
VERBOSE: [13:48:46][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:46][New-DbaLogin] Setting tadsuser SID
VERBOSE: [13:48:46][New-DbaLogin] Setting tadsuser default database to COI
VERBOSE: [13:48:46][New-DbaLogin] Setting tadsuser language to us_english
VERBOSE: [13:48:46][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:46][New-DbaLogin] Successfully added tadsuser to SQLEDTN01.
VERBOSE: [13:48:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:47][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:47][Get-DbaLogin] Processing [tadsuser] on SQLEDTN01
VERBOSE: [13:48:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:47][Update-SqlPermission] Grant CONNECT SQL to tadsuser on SQLEDTN01 successfully performed.
VERBOSE: [13:48:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:47][Update-SqlPermission] Grant on CONNECT to tadsuser on COI on SQLEDTN01 successfully performed.
VERBOSE: [13:48:47][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:47][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:47][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:47][Copy-Login] Attempting to add u_AS400 to SQLEDTN01.
VERBOSE: [13:48:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:47][New-DbaLogin] Setting u_AS400 SID
VERBOSE: [13:48:47][New-DbaLogin] Setting u_AS400 default database to master
VERBOSE: [13:48:47][New-DbaLogin] Setting u_AS400 language to us_english
VERBOSE: [13:48:47][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:47][New-DbaLogin] Successfully added u_AS400 to SQLEDTN01.
VERBOSE: [13:48:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:47][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:47][Get-DbaLogin] Processing [u_AS400] on SQLEDTN01
VERBOSE: [13:48:47][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:47][Update-SqlPermission] Grant CONNECT SQL to u_AS400 on SQLEDTN01 successfully performed.
VERBOSE: [13:48:48][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:48][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:48][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:48][Copy-Login] Attempting to add u_CCCv2 to SQLEDTN01.
VERBOSE: [13:48:48][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:48][New-DbaLogin] Setting u_CCCv2 SID
VERBOSE: [13:48:48][New-DbaLogin] Setting u_CCCv2 default database to CCCv2
VERBOSE: [13:48:48][New-DbaLogin] Setting u_CCCv2 language to us_english
VERBOSE: [13:48:48][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:48][New-DbaLogin] Successfully added u_CCCv2 to SQLEDTN01.
VERBOSE: [13:48:48][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:48][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:48][Get-DbaLogin] Processing [u_CCCv2] on SQLEDTN01
VERBOSE: [13:48:48][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:48][Update-SqlPermission] Grant CONNECT SQL to u_CCCv2 on SQLEDTN01 successfully performed.
VERBOSE: [13:48:48][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:48][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:48][Update-SqlPermission] Grant on CONNECT to u_CCCv2 on CCCv2 on SQLEDTN01 successfully performed.
VERBOSE: [13:48:48][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:48][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:48][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:48][Copy-Login] Attempting to add u_DAC to SQLEDTN01.
VERBOSE: [13:48:48][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:49][New-DbaLogin] Setting u_DAC SID
VERBOSE: [13:48:49][New-DbaLogin] Setting u_DAC default database to master
VERBOSE: [13:48:49][New-DbaLogin] Setting u_DAC language to us_english
VERBOSE: [13:48:49][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:49][New-DbaLogin] Successfully added u_DAC to SQLEDTN01.
VERBOSE: [13:48:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:49][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:49][Get-DbaLogin] Processing [u_DAC] on SQLEDTN01
VERBOSE: [13:48:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:49][Update-SqlPermission] Grant CONNECT SQL to u_DAC on SQLEDTN01 successfully performed.
VERBOSE: [13:48:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:49][Set-DbaDbOwner] Setting database owner for SP_DAC to u_DAC on SQLEDTN01.
VERBOSE: [13:48:49][Update-SqlPermission] Changed SP_DAC owner to u_DAC.
VERBOSE: [13:48:49][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:49][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:49][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:49][Copy-Login] Attempting to add u_DAEP to SQLEDTN01.
WARNING: [13:48:49][Copy-Login] Database DAEP does not exist on [SQLEDTN01], switching DefaultDatabase to 'master' for u_DAEP
VERBOSE: [13:48:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:49][New-DbaLogin] Setting u_DAEP SID
VERBOSE: [13:48:49][New-DbaLogin] Setting u_DAEP default database to master
VERBOSE: [13:48:49][New-DbaLogin] Setting u_DAEP language to us_english
VERBOSE: [13:48:49][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:49][New-DbaLogin] Successfully added u_DAEP to SQLEDTN01.
VERBOSE: [13:48:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:49][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:49][Get-DbaLogin] Processing [u_DAEP] on SQLEDTN01
VERBOSE: [13:48:49][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:50][Update-SqlPermission] Grant CONNECT SQL to u_DAEP on SQLEDTN01 successfully performed.
VERBOSE: [13:48:50][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:50][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:50][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:50][Set-DbaDbOwner] Setting database owner for SP_DAEP to u_DAEP on SQLEDTN01.
VERBOSE: [13:48:50][Update-SqlPermission] Changed SP_DAEP owner to u_DAEP.
VERBOSE: [13:48:50][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:50][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:50][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:50][Copy-Login] Attempting to add u_DataServices to SQLEDTN01.
VERBOSE: [13:48:50][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:50][New-DbaLogin] Setting u_DataServices SID
VERBOSE: [13:48:50][New-DbaLogin] Setting u_DataServices default database to master
VERBOSE: [13:48:50][New-DbaLogin] Setting u_DataServices language to us_english
VERBOSE: [13:48:50][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:50][New-DbaLogin] Successfully added u_DataServices to SQLEDTN01.
VERBOSE: [13:48:50][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:50][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:50][Get-DbaLogin] Processing [u_DataServices] on SQLEDTN01
VERBOSE: [13:48:50][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:50][Update-SqlPermission] Grant CONNECT SQL to u_DataServices on SQLEDTN01 successfully performed.
VERBOSE: [13:48:51][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:51][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:51][Update-SqlPermission] Grant on CONNECT to u_DataServices on LOGW on SQLEDTN01 successfully performed.
VERBOSE: [13:48:51][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:51][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:51][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:51][Copy-Login] Attempting to add u_HEALTH to SQLEDTN01.
VERBOSE: [13:48:51][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:51][New-DbaLogin] Setting u_HEALTH SID
VERBOSE: [13:48:51][New-DbaLogin] Setting u_HEALTH default database to master
VERBOSE: [13:48:51][New-DbaLogin] Setting u_HEALTH language to us_english
VERBOSE: [13:48:51][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:51][New-DbaLogin] Successfully added u_HEALTH to SQLEDTN01.
VERBOSE: [13:48:51][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:51][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:51][Get-DbaLogin] Processing [u_HEALTH] on SQLEDTN01
VERBOSE: [13:48:51][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:52][Update-SqlPermission] Grant CONNECT SQL to u_HEALTH on SQLEDTN01 successfully performed.
VERBOSE: [13:48:52][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:52][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:52][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:52][Copy-Login] Attempting to add u_HFWE to SQLEDTN01.
VERBOSE: [13:48:52][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:52][New-DbaLogin] Setting u_HFWE SID
VERBOSE: [13:48:52][New-DbaLogin] Setting u_HFWE default database to master
VERBOSE: [13:48:52][New-DbaLogin] Setting u_HFWE language to us_english
VERBOSE: [13:48:52][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:52][New-DbaLogin] Successfully added u_HFWE to SQLEDTN01.
VERBOSE: [13:48:52][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:52][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:52][Get-DbaLogin] Processing [u_HFWE] on SQLEDTN01
VERBOSE: [13:48:52][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:52][Update-SqlPermission] Grant CONNECT SQL to u_HFWE on SQLEDTN01 successfully performed.
VERBOSE: [13:48:52][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:52][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:52][Update-SqlPermission] Grant on CONNECT to u_HFWE on HFWE on SQLEDTN01 successfully performed.
VERBOSE: [13:48:52][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:52][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:52][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:52][Copy-Login] Attempting to add u_HSIS to SQLEDTN01.
VERBOSE: [13:48:52][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:52][New-DbaLogin] Setting u_HSIS SID
VERBOSE: [13:48:52][New-DbaLogin] Setting u_HSIS default database to master
VERBOSE: [13:48:52][New-DbaLogin] Setting u_HSIS language to us_english
VERBOSE: [13:48:52][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:52][New-DbaLogin] Successfully added u_HSIS to SQLEDTN01.
VERBOSE: [13:48:52][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:52][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:53][Get-DbaLogin] Processing [u_HSIS] on SQLEDTN01
VERBOSE: [13:48:53][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:53][Update-SqlPermission] Grant CONNECT SQL to u_HSIS on SQLEDTN01 successfully performed.
VERBOSE: [13:48:53][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:53][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:53][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:53][Copy-Login] Attempting to add u_MAS to SQLEDTN01.
WARNING: [13:48:53][Copy-Login] Database MAS does not exist on [SQLEDTN01], switching DefaultDatabase to 'master' for u_MAS
VERBOSE: [13:48:53][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:53][New-DbaLogin] Setting u_MAS SID
VERBOSE: [13:48:53][New-DbaLogin] Setting u_MAS default database to master
VERBOSE: [13:48:53][New-DbaLogin] Setting u_MAS language to us_english
VERBOSE: [13:48:53][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:53][New-DbaLogin] Successfully added u_MAS to SQLEDTN01.
VERBOSE: [13:48:53][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:53][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:53][Get-DbaLogin] Processing [u_MAS] on SQLEDTN01
VERBOSE: [13:48:53][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:53][Update-SqlPermission] Grant CONNECT SQL to u_MAS on SQLEDTN01 successfully performed.
VERBOSE: [13:48:53][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:53][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:53][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:53][Set-DbaDbOwner] Setting database owner for SP_MAS to u_MAS on SQLEDTN01.
VERBOSE: [13:48:53][Update-SqlPermission] Changed SP_MAS owner to u_MAS.
VERBOSE: [13:48:53][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:53][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:54][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:54][Copy-Login] Attempting to add u_MSHP to SQLEDTN01.
WARNING: [13:48:54][Copy-Login] Database MSHP does not exist on [SQLEDTN01], switching DefaultDatabase to 'master' for u_MSHP
VERBOSE: [13:48:54][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:54][New-DbaLogin] Setting u_MSHP SID
VERBOSE: [13:48:54][New-DbaLogin] Setting u_MSHP default database to master
VERBOSE: [13:48:54][New-DbaLogin] Setting u_MSHP language to us_english
VERBOSE: [13:48:54][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:54][New-DbaLogin] Successfully added u_MSHP to SQLEDTN01.
VERBOSE: [13:48:54][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:54][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:54][Get-DbaLogin] Processing [u_MSHP] on SQLEDTN01
VERBOSE: [13:48:54][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:54][Update-SqlPermission] Grant CONNECT SQL to u_MSHP on SQLEDTN01 successfully performed.
VERBOSE: [13:48:54][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:54][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:54][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:54][Set-DbaDbOwner] Setting database owner for SP_MSHP to u_MSHP on SQLEDTN01.
VERBOSE: [13:48:54][Update-SqlPermission] Changed SP_MSHP owner to u_MSHP.
VERBOSE: [13:48:54][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:54][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:54][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:54][Copy-Login] Attempting to add u_PEIMS to SQLEDTN01.
VERBOSE: [13:48:54][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:54][New-DbaLogin] Setting u_PEIMS SID
VERBOSE: [13:48:54][New-DbaLogin] Setting u_PEIMS default database to master
VERBOSE: [13:48:54][New-DbaLogin] Setting u_PEIMS language to us_english
VERBOSE: [13:48:54][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:54][New-DbaLogin] Successfully added u_PEIMS to SQLEDTN01.
VERBOSE: [13:48:54][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:55][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:55][Get-DbaLogin] Processing [u_PEIMS] on SQLEDTN01
VERBOSE: [13:48:55][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:55][Update-SqlPermission] Grant CONNECT SQL to u_PEIMS on SQLEDTN01 successfully performed.
VERBOSE: [13:48:55][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:55][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:55][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:55][Copy-Login] Attempting to add u_SPAT to SQLEDTN01.
VERBOSE: [13:48:55][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:55][New-DbaLogin] Setting u_SPAT SID
VERBOSE: [13:48:55][New-DbaLogin] Setting u_SPAT default database to master
VERBOSE: [13:48:55][New-DbaLogin] Setting u_SPAT language to us_english
VERBOSE: [13:48:55][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:55][New-DbaLogin] Successfully added u_SPAT to SQLEDTN01.
VERBOSE: [13:48:55][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:55][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:55][Get-DbaLogin] Processing [u_SPAT] on SQLEDTN01
VERBOSE: [13:48:55][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:55][Update-SqlPermission] Grant CONNECT SQL to u_SPAT on SQLEDTN01 successfully performed.
VERBOSE: [13:48:55][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:55][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:56][Update-SqlPermission] Grant on CONNECT to u_SPAT on SPAT on SQLEDTN01 successfully performed.
VERBOSE: [13:48:56][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:56][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:56][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:56][Copy-Login] Attempting to add u_SWAV to SQLEDTN01.
VERBOSE: [13:48:56][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:56][New-DbaLogin] Setting u_SWAV SID
VERBOSE: [13:48:56][New-DbaLogin] Setting u_SWAV default database to master
VERBOSE: [13:48:56][New-DbaLogin] Setting u_SWAV language to us_english
VERBOSE: [13:48:56][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:56][New-DbaLogin] Successfully added u_SWAV to SQLEDTN01.
VERBOSE: [13:48:56][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:56][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:56][Get-DbaLogin] Processing [u_SWAV] on SQLEDTN01
VERBOSE: [13:48:56][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:56][Update-SqlPermission] Grant CONNECT SQL to u_SWAV on SQLEDTN01 successfully performed.
VERBOSE: [13:48:56][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:56][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:56][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:56][Set-DbaDbOwner] Setting database owner for SP_SWAV to u_SWAV on SQLEDTN01.
VERBOSE: [13:48:56][Update-SqlPermission] Changed SP_SWAV owner to u_SWAV.
VERBOSE: [13:48:57][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:57][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:57][Copy-DbaLogin] Attempting Login Migration.
VERBOSE: [13:48:57][Copy-Login] Attempting to add visits to SQLEDTN01.
VERBOSE: [13:48:57][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:57][New-DbaLogin] Setting visits SID
VERBOSE: [13:48:57][New-DbaLogin] Setting visits default database to VISITS
VERBOSE: [13:48:57][New-DbaLogin] Setting visits language to us_english
VERBOSE: [13:48:57][New-DbaLogin] Adding as login type SqlLogin
VERBOSE: [13:48:57][New-DbaLogin] Successfully added visits to SQLEDTN01.
VERBOSE: [13:48:57][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:57][Get-DbaLogin] Getting last login times
VERBOSE: [13:48:57][Get-DbaLogin] Processing [visits] on SQLEDTN01
VERBOSE: [13:48:57][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:57][Update-SqlPermission] Grant CONNECT SQL to visits on SQLEDTN01 successfully performed.
VERBOSE: [13:48:57][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:57][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:58][Update-SqlPermission] Grant on CONNECT to visits on VISITS on SQLEDTN01 successfully performed.
VERBOSE: [13:48:58][Start-DbaMigration] Updating database owners to match newly migrated logins
VERBOSE: [13:48:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:58][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:58][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:58][Update-SqlDbOwner] Proper owner already set on DBA
VERBOSE: [13:48:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:58][Update-SqlDbOwner] Proper owner already set on SP_DAC
VERBOSE: [13:48:58][Update-SqlDbOwner] Proper owner already set on SP_DAEP
VERBOSE: [13:48:58][Update-SqlDbOwner] Proper owner already set on SP_MAS
VERBOSE: [13:48:58][Update-SqlDbOwner] Proper owner already set on SP_MSHP
VERBOSE: [13:48:58][Update-SqlDbOwner] Proper owner already set on SP_SWAV
VERBOSE: [13:48:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:58][Start-DbaMigration] Migrating linked servers
VERBOSE: [13:48:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:48:58][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:48:58][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:48:58][Copy-DbaLinkedServers] Collecting Linked Server logins and passwords on SQLSTG01.
VERBOSE: [13:48:58][Get-DecryptedObject] Querying service master key
VERBOSE: [13:48:58][Resolve-DbaNetworkName] Resolving SQLSTG01 using .NET.Dns GetHostEntry
VERBOSE: [13:48:58][Resolve-DbaNetworkName] Resolving 10.255.27.184 using .NET.Dns GetHostByAddress
VERBOSE: [13:48:58][Get-DbaCmObject] Configuration loaded | Cache disabled: False
VERBOSE: [13:48:58][Get-DbaCmObject] [sqlstg01] Retrieving Management Information
VERBOSE: [13:48:58][Get-DbaCmObject] [sqlstg01] Accessing computer using Cim over WinRM
VERBOSE: [13:48:58][Get-DbaCmObject] [sqlstg01] Accessing computer using Cim over WinRM - Success
VERBOSE: [13:48:58][Resolve-DbaNetworkName] Resolving SQLSTG01.AD.XXXXXX.ORG using .NET.Dns GetHostEntry
VERBOSE: [13:48:58][Resolve-DbaComputerName] Resolved 'SQLSTG01' to 'SQLSTG01.AD.XXXXXX.ORG'
VERBOSE: [13:48:58][Get-DecryptedObject] Decrypt the service master key
VERBOSE: [13:48:59][Get-DecryptedObject] Choose the encryption algorithm based on the SMK length - 3DES for 2008, AES for 2012
VERBOSE: [13:48:59][Get-DecryptedObject] Query password information from the Db.
WARNING: [13:49:13][Get-DecryptedObject] Can't establish local DAC connection on SQLSTG01. | Exception calling "Open" with "0" argument(s): "A network-related or instance-specific error occurred while establishing a connection to SQL
Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 43 - An error occurred while obt
aining the dedicated administrator connection (DAC) port. Make sure that SQL Browser is running, or check the error log for the port number)"
VERBOSE: [13:49:13][Get-DecryptedObject] Go through each row in results
VERBOSE: [13:49:14][Copy-DbaLinkedServers] Attempting to migrate: DAEP.
VERBOSE: [13:49:14][Copy-DbaLinkedServers] DAEP successfully copied.
VERBOSE: [13:49:14][Copy-DbaLinkedServers] Attempting to migrate: MENTOR_ACTIVITY.
VERBOSE: [13:49:14][Copy-DbaLinkedServers] MENTOR_ACTIVITY successfully copied.
VERBOSE: [13:49:14][Copy-DbaLinkedServers] Attempting to migrate: MENTOR_INFO.
VERBOSE: [13:49:14][Copy-DbaLinkedServers] MENTOR_INFO successfully copied.
VERBOSE: [13:49:14][Copy-DbaLinkedServers] Attempting to migrate: PEIMSREPORT_UPLOAD.
VERBOSE: [13:49:14][Copy-DbaLinkedServers] PEIMSREPORT_UPLOAD successfully copied.
VERBOSE: [13:49:14][Copy-DbaLinkedServers] Attempting to migrate: PERSONNEL_INFO.
VERBOSE: [13:49:14][Copy-DbaLinkedServers] PERSONNEL_INFO successfully copied.
VERBOSE: [13:49:14][Copy-DbaLinkedServers] Attempting to migrate: SQLDEV01.
VERBOSE: [13:49:14][Copy-DbaLinkedServers] SQLDEV01 successfully copied.
VERBOSE: [13:49:14][Copy-DbaLinkedServers] Attempting to migrate: SQLINT01.
VERBOSE: [13:49:14][Copy-DbaLinkedServers] SQLINT01 successfully copied.
VERBOSE: [13:49:14][Start-DbaMigration] Migrating Data Collector collection sets
VERBOSE: [13:49:14][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:14][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:14][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:14][Copy-DbaDataCollector] Server reconfiguration not yet supported. Only Collection Set migration will be migrated at this time.
VERBOSE: [13:49:14][Copy-DbaDataCollector] The Data Collector must be setup initially for Collection Sets to be migrated. Setup the Data Collector and try again.
VERBOSE: [13:49:14][Start-DbaMigration] Migrating Audits
VERBOSE: [13:49:14][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:14][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:14][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:15][Start-DbaMigration] Migrating Server Audit Specifications
VERBOSE: [13:49:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:15][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:15][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:15][Start-DbaMigration] Migrating Endpoints
VERBOSE: [13:49:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:15][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:15][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:15][Start-DbaMigration] Migrating Policy Management
VERBOSE: [13:49:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:15][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:15][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:15][Copy-DbaPolicyManagement] Migrating categories
VERBOSE: [13:49:15][Copy-DbaPolicyManagement] Migrating conditions
VERBOSE: [13:49:15][Copy-DbaPolicyManagement] Migrating policies
VERBOSE: [13:49:15][Start-DbaMigration] Migrating Resource Governor
VERBOSE: [13:49:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:15][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:15][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:15][Copy-DbaResourceGovernor] Managing classifier function.
VERBOSE: [13:49:15][Copy-DbaResourceGovernor] Migrating pools.
VERBOSE: [13:49:15][Copy-DbaResourceGovernor] Reconfiguring Resource Governor.
VERBOSE: [13:49:15][Copy-DbaResourceGovernor] Reconfiguring Resource Governor.
VERBOSE: [13:49:15][Start-DbaMigration] Migrating user objects in system databases (this can take a second).
VERBOSE: Performing the operation "Copying user objects." on target "SQLEDTN01".
VERBOSE: [13:49:15][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:15][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:15][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:16][Get-DbaModule] Creating InputObject from SQLSTG01
VERBOSE: [13:49:16][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:16][Get-DbaModule] Processing [master] on SQLSTG01
VERBOSE: [13:49:16][Copy-DbaSysDbUserObject] Copying from master
VERBOSE: [13:49:16][Copy-DbaSysDbUserObject] Searching for [dbo].[ASPState_Startup] in master on SQLEDTN01
VERBOSE: [13:49:16][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:16][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:16][Get-DbaModule] Processing [master] on SQLEDTN01
VERBOSE: [13:49:16][Copy-DbaSysDbUserObject] Searching for [dbo].[sp_WhoIsActive] in master on SQLEDTN01
VERBOSE: [13:49:16][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:16][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:16][Get-DbaModule] Processing [master] on SQLEDTN01
VERBOSE: [13:49:16][Get-DbaModule] Creating InputObject from SQLSTG01
VERBOSE: [13:49:16][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:16][Get-DbaModule] Processing [model] on SQLSTG01
VERBOSE: [13:49:16][Copy-DbaSysDbUserObject] Copying from model
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Force specified. Dropping [DatabaseMailUserRole] in [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Force specified. Dropping [db_ssisadmin] in [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Force specified. Dropping [db_ssisltduser] in [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Force specified. Dropping [db_ssisoperator] in [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Force specified. Dropping [managed_backup] in [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Force specified. Dropping [smart_admin] in [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Force specified. Dropping [SQLAgentOperatorRole] in [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Force specified. Dropping [SQLAgentReaderRole] in [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Force specified. Dropping [SQLAgentUserRole] in [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Force specified. Dropping [TargetServersRole] in [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Get-DbaModule] Creating InputObject from SQLSTG01
VERBOSE: [13:49:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:22][Get-DbaModule] Processing [msdb] on SQLSTG01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Copying from msdb
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Searching for [dbo].[fn_sysutility_ucp_get_policy_violations] in msdb on SQLEDTN01
VERBOSE: [13:49:22][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:22][Get-DbaModule] Processing [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Searching for [managed_backup].[fn_backup_db_config] in msdb on SQLEDTN01
VERBOSE: [13:49:22][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:22][Get-DbaModule] Processing [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Searching for [managed_backup].[fn_backup_instance_config] in msdb on SQLEDTN01
VERBOSE: [13:49:22][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:22][Get-DbaModule] Processing [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Searching for [managed_backup].[fn_get_parameter] in msdb on SQLEDTN01
VERBOSE: [13:49:22][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:22][Get-DbaModule] Processing [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Searching for [managed_backup].[fn_get_current_xevent_settings] in msdb on SQLEDTN01
VERBOSE: [13:49:22][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:22][Get-DbaModule] Processing [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Searching for [managed_backup].[fn_get_health_status] in msdb on SQLEDTN01
VERBOSE: [13:49:22][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:22][Get-DbaModule] Processing [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Searching for [smart_admin].[fn_backup_db_config] in msdb on SQLEDTN01
VERBOSE: [13:49:22][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:22][Get-DbaModule] Processing [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Searching for [smart_admin].[fn_backup_instance_config] in msdb on SQLEDTN01
VERBOSE: [13:49:22][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:22][Get-DbaModule] Processing [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Searching for [smart_admin].[fn_get_parameter] in msdb on SQLEDTN01
VERBOSE: [13:49:22][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:22][Get-DbaModule] Processing [msdb] on SQLEDTN01
VERBOSE: [13:49:22][Copy-DbaSysDbUserObject] Searching for [smart_admin].[fn_get_current_xevent_settings] in msdb on SQLEDTN01
VERBOSE: [13:49:22][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:22][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:23][Get-DbaModule] Processing [msdb] on SQLEDTN01
VERBOSE: [13:49:23][Copy-DbaSysDbUserObject] Searching for [smart_admin].[fn_get_health_status] in msdb on SQLEDTN01
VERBOSE: [13:49:23][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:23][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:23][Get-DbaModule] Processing [msdb] on SQLEDTN01
VERBOSE: [13:49:23][Copy-DbaSysDbUserObject] Searching for [managed_backup].[fn_available_backups] in msdb on SQLEDTN01
VERBOSE: [13:49:23][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:23][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:23][Get-DbaModule] Processing [msdb] on SQLEDTN01
VERBOSE: [13:49:23][Copy-DbaSysDbUserObject] Searching for [smart_admin].[fn_available_backups] in msdb on SQLEDTN01
VERBOSE: [13:49:23][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:23][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:23][Get-DbaModule] Processing [msdb] on SQLEDTN01
VERBOSE: [13:49:23][Copy-DbaSysDbUserObject] Searching for [dbo].[sysdtslog90] in msdb on SQLEDTN01
VERBOSE: [13:49:23][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:23][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:23][Get-DbaModule] Processing [msdb] on SQLEDTN01
VERBOSE: [13:49:23][Start-DbaMigration] Migrating Extended Events
VERBOSE: [13:49:23][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:23][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:23][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:23][Copy-DbaXESession] Migrating sessions.
VERBOSE: [13:49:25][Copy-DbaXESession] Migrating session DB_ACCESS_MONITORING_AS400StuData.
WARNING: [13:49:25][Copy-DbaXESession] Unable to create session. | The target, "5B2DA06D-898A-43C8-9309-39BBBE93EBBD.package0.event_file", encountered a configuration error during initialization. Object cannot be added to the event se
ssion. The operating system returned error 3: 'The system cannot find the path specified.
' while creating the file 'E:\XE\DB_ACCESS_MONITORING_AS400StuData_0_133020389650990000.xel'.
VERBOSE: [13:49:25][Copy-DbaXESession] Migrating session DB_ACCESS_MONITORING_CCCv2.
WARNING: [13:49:25][Copy-DbaXESession] Unable to create session. | The target, "5B2DA06D-898A-43C8-9309-39BBBE93EBBD.package0.event_file", encountered a configuration error during initialization. Object cannot be added to the event se
ssion. The operating system returned error 3: 'The system cannot find the path specified.
' while creating the file 'E:\XE\DB_ACCESS_MONITORING_CCCv2_0_133020389657240000.xel'.
VERBOSE: [13:49:26][Copy-DbaXESession] Migrating session DB_ACCESS_MONITORING_HFWE.
WARNING: [13:49:26][Copy-DbaXESession] Unable to create session. | The target, "5B2DA06D-898A-43C8-9309-39BBBE93EBBD.package0.event_file", encountered a configuration error during initialization. Object cannot be added to the event se
ssion. The operating system returned error 3: 'The system cannot find the path specified.
' while creating the file 'E:\XE\DB_ACCESS_MONITORING_HFWE_0_133020389663570000.xel'.
VERBOSE: [13:49:27][Copy-DbaXESession] Migrating session DB_ACCESS_MONITORING_SPAT.
WARNING: [13:49:27][Copy-DbaXESession] Unable to create session. | The target, "5B2DA06D-898A-43C8-9309-39BBBE93EBBD.package0.event_file", encountered a configuration error during initialization. Object cannot be added to the event se
ssion. The operating system returned error 3: 'The system cannot find the path specified.
' while creating the file 'E:\XE\DB_ACCESS_MONITORING_SPAT_0_133020389669880000.xel'.
VERBOSE: [13:49:27][Copy-DbaXESession] Migrating session DB_ACCESS_MONITORING_VISITS.
WARNING: [13:49:27][Copy-DbaXESession] Unable to create session. | The target, "5B2DA06D-898A-43C8-9309-39BBBE93EBBD.package0.event_file", encountered a configuration error during initialization. Object cannot be added to the event se
ssion. The operating system returned error 3: 'The system cannot find the path specified.
' while creating the file 'E:\XE\DB_ACCESS_MONITORING_VISITS_0_133020389675980000.xel'.
VERBOSE: [13:49:27][Copy-DbaXESession] Extended Event Session 'telemetry_xevents' exists on SQLEDTN01.
VERBOSE: [13:49:27][Copy-DbaXESession] Force specified. Dropping telemetry_xevents.
VERBOSE: [13:49:33][Copy-DbaXESession] Migrating session telemetry_xevents.
WARNING: [13:49:33][Copy-DbaXESession] Unable to create session. | The event name, "sqlserver.tsql_scalar_udf_inlining_threshold", is invalid, or the object could not be found
VERBOSE: [13:49:33][Copy-DbaXESession] Migrating session TrackLogins.
VERBOSE: [13:49:33][Start-DbaMigration] Migrating job server
VERBOSE: [13:49:33][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:33][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:33][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:34][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:34][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:34][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:34][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:34][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:34][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:34][Copy-DbaAgentOperator] Copying Operator dba
VERBOSE: [13:49:34][Copy-DbaAgentOperator] Copying Operator SQLAlerts
VERBOSE: [13:49:34][Copy-DbaAgentOperator] Copying Operator SQLSupport
VERBOSE: [13:49:34][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:34][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:34][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:34][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:34][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:34][Copy-DbaAgentAlert] Creating Alert Defaults
VERBOSE: [13:49:34][Copy-DbaAgentAlert] Copying Alert SQLSTG01 Alert - Error 823: The operating system returned an error
VERBOSE: [13:49:35][Copy-DbaAgentAlert] Adding email
VERBOSE: [13:49:35][Copy-DbaAgentAlert] Copying Alert SQLSTG01 Alert - Error 824: Logical consistency-based I/O error
VERBOSE: [13:49:35][Copy-DbaAgentAlert] Adding email
VERBOSE: [13:49:35][Copy-DbaAgentAlert] Copying Alert SQLSTG01 Alert - Error 825: Read-Retry Required
VERBOSE: [13:49:35][Copy-DbaAgentAlert] Adding email
VERBOSE: [13:49:35][Copy-DbaAgentAlert] Copying Alert SQLSTG01 Alert - Error 832: Constant page has changed
VERBOSE: [13:49:35][Copy-DbaAgentAlert] Adding email
VERBOSE: [13:49:35][Copy-DbaAgentAlert] Copying Alert SQLSTG01 Alert - Error 855: Uncorrectable hardware memory corruption detected
VERBOSE: [13:49:35][Copy-DbaAgentAlert] Adding email
VERBOSE: [13:49:35][Copy-DbaAgentAlert] Copying Alert SQLSTG01 Alert - Error 856: SQL Server has detected hardware memory corruption, but has recovered the page
VERBOSE: [13:49:35][Copy-DbaAgentAlert] Adding email
VERBOSE: [13:49:35][Copy-DbaAgentAlert] Copying Alert SQLSTG01 Alert - Severity 14420: Log Shipping Primary Server Alert
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Adding email
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Copying Alert SQLSTG01 Alert - Severity 14421: Log Shipping Secondary Server Alert
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Adding email
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Copying Alert SQLSTG01 Alert - Severity 19 Error: Fatal Error in Resource
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Adding email
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Copying Alert SQLSTG01 Alert - Severity 20 Error: Fatal Error in Current Process
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Adding email
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Copying Alert SQLSTG01 Alert - Severity 21 Error: Fatal Error in Database Process
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Adding email
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Copying Alert SQLSTG01 Alert - Severity 22 Error: Fatal Error: Table Integrity Suspect
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Adding email
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Copying Alert SQLSTG01 Alert - Severity 23 Error: Fatal Error Database Integrity Suspect
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Adding email
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Copying Alert SQLSTG01 Alert - Severity 24 Error: Fatal Hardware Error
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Adding email
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Copying Alert SQLSTG01 Alert - Severity 25 Error: Fatal Error
VERBOSE: [13:49:36][Copy-DbaAgentAlert] Adding email
VERBOSE: [13:49:36][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:36][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:36][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:37][Copy-DbaAgentProxy] Associated credential account, DAEP_SIS_IMPORT, does not exist on SQLEDTN01
VERBOSE: [13:49:37][Copy-DbaAgentProxy] Associated credential account, DAEP_SIS_IMPORT, does not exist on SQLEDTN01
VERBOSE: [13:49:37][Copy-DbaAgentProxy] Associated credential account, jherna26, does not exist on SQLEDTN01
VERBOSE: [13:49:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:37][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:37][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule ASPState_JobSchedule_DeleteExpiredSessions
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule BackupMaintenancePlan.Subplan_1
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule CollectorSchedule_Every_10min
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule CollectorSchedule_Every_15min
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule CollectorSchedule_Every_30min
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule CollectorSchedule_Every_5min
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule CollectorSchedule_Every_60min
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule CollectorSchedule_Every_6h
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule Daily
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule Daily@7AM
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule Daily@7am
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule Daily@EveryHour
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule Daily_Every_10_Seconds
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule Daily_Every_15_Minutes
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule Every_2_min
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule First Of Month 3AM
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule MAINT - check_system_dbs
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Copying schedule RunAsSQLAgentServiceStartSchedule
VERBOSE: [13:49:37][Copy-DbaAgentSchedule] Schedule [syspolicy_purge_history_schedule] has associated jobs. Skipping.
VERBOSE: [13:49:37][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:37][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:37][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:37][Copy-DbaAgentJob] Working on job: ASPState_Job_DeleteExpiredSessions
VERBOSE: [13:49:37][Copy-DbaAgentJob] Database(s) ASPState doesn't exist on destination. Skipping job [ASPState_Job_DeleteExpiredSessions].
VERBOSE: [13:49:37][Copy-DbaAgentJob] Working on job: BackupMaintenancePlan.Subplan_1
VERBOSE: [13:49:37][Copy-DbaAgentJob] Job [BackupMaintenancePlan.Subplan_1] is associated with Maintenance Plan: BackupMaintenancePlan
VERBOSE: [13:49:37][Copy-DbaAgentJob] Working on job: DBA | ChangeRecoveryModel
VERBOSE: [13:49:38][Copy-DbaAgentJob] Copying Job DBA | ChangeRecoveryModel
VERBOSE: [13:49:38][Copy-DbaAgentJob] Working on job: DBA | ShrinkLog
VERBOSE: [13:49:38][Copy-DbaAgentJob] Copying Job DBA | ShrinkLog
VERBOSE: [13:49:38][Copy-DbaAgentJob] Working on job: ImportFSRegionalSupportByTechnician
VERBOSE: [13:49:38][Copy-DbaAgentJob] Proxy Account(s) DAEP_SIS_IMPORT doesn't exist on destination. Skipping job [ImportFSRegionalSupportByTechnician].
VERBOSE: [13:49:38][Copy-DbaAgentJob] Working on job: MAINT - check_system_dbs
VERBOSE: [13:49:38][Copy-DbaAgentJob] Copying Job MAINT - check_system_dbs
VERBOSE: [13:49:38][Copy-DbaAgentJob] Working on job: MAINT - cycle_agent_error_logs
VERBOSE: [13:49:38][Copy-DbaAgentJob] Copying Job MAINT - cycle_agent_error_logs
VERBOSE: [13:49:38][Copy-DbaAgentJob] Working on job: MAINT - cycle_error_logs
VERBOSE: [13:49:38][Copy-DbaAgentJob] Copying Job MAINT - cycle_error_logs
VERBOSE: [13:49:38][Copy-DbaAgentJob] Working on job: MAINT - purge_jobhistory
VERBOSE: [13:49:38][Copy-DbaAgentJob] Copying Job MAINT - purge_jobhistory
VERBOSE: [13:49:39][Copy-DbaAgentJob] Working on job: MAINT - purge_sysmail_history
VERBOSE: [13:49:39][Copy-DbaAgentJob] Copying Job MAINT - purge_sysmail_history
VERBOSE: [13:49:39][Copy-DbaAgentJob] Working on job: MAINT - purge_syspolicy_history
VERBOSE: [13:49:39][Copy-DbaAgentJob] Copying Job MAINT - purge_syspolicy_history
VERBOSE: [13:49:39][Copy-DbaAgentJob] Working on job: MAS Mentor Agreement Approval
VERBOSE: [13:49:39][Copy-DbaAgentJob] Copying Job MAS Mentor Agreement Approval
VERBOSE: [13:49:39][Copy-DbaAgentJob] Working on job: Run_DAEP_SIS_Import_Batch
VERBOSE: [13:49:39][Copy-DbaAgentJob] Proxy Account(s) DAEP_SIS_IMPORT, DAEP_SIS_IMPORT2 doesn't exist on destination. Skipping job [Run_DAEP_SIS_Import_Batch].
VERBOSE: [13:49:39][Copy-DbaAgentJob] Working on job: sp_BlitzFirst
VERBOSE: [13:49:39][Copy-DbaAgentJob] Copying Job sp_BlitzFirst
VERBOSE: [13:49:39][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:39][Copy-DbaAgentJob] Working on job: sp_WhoIsActive_Capture
VERBOSE: [13:49:39][Copy-DbaAgentJob] Copying Job sp_WhoIsActive_Capture
VERBOSE: [13:49:45][Copy-DbaAgentJob] Working on job: sp_WhoIsActive_Cleanup
VERBOSE: [13:49:46][Copy-DbaAgentJob] Copying Job sp_WhoIsActive_Cleanup
VERBOSE: [13:49:46][Copy-DbaAgentJob] Working on job: Test
VERBOSE: [13:49:46][Copy-DbaAgentJob] Copying Job Test
VERBOSE: [13:49:46][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:46][Copy-DbaAgentJob] Working on job: VISITS_BackgroundCheck_Job
VERBOSE: [13:49:46][Copy-DbaAgentJob] Proxy Account(s) VISITS_BC doesn't exist on destination. Skipping job [VISITS_BackgroundCheck_Job].
VERBOSE: [13:49:46][Copy-DbaAgentServer] Copying SQL Agent Properties
VERBOSE: [13:49:46][Start-DbaMigration] Migrating startup procedures
VERBOSE: [13:49:46][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:46][Get-DbaModule] Creating InputObject from SQLSTG01
VERBOSE: [13:49:46][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:46][Get-DbaModule] Processing [master] on SQLSTG01
VERBOSE: [13:49:46][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [13:49:46][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [13:49:46][Get-DbaModule] Creating InputObject from SQLEDTN01
VERBOSE: [13:49:46][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [13:49:46][Get-DbaModule] Processing [master] on SQLEDTN01
VERBOSE: [13:49:46][Copy-DbaStartupProcedure] Startup procedure dbo.ASPState_Startup exists at destination. Use -Force to drop and migrate.
VERBOSE: [13:49:46][Start-DbaMigration] SQL Server migration complete.
VERBOSE: [13:49:46][Start-DbaMigration] Migration started: 07/11/2022 13:00:50
VERBOSE: [13:49:46][Start-DbaMigration] Migration completed: 07/11/2022 13:49:46
VERBOSE: [13:49:46][Start-DbaMigration] Total Elapsed time: 00:48:56
Type Name Status Notes

Configuration Value RecoveryInterval Successful
Configuration Value AllowUpdates Successful
Configuration Value UserConnections Successful Requires restart
Configuration Value Locks Successful Requires restart
Configuration Value OpenObjects Successful Requires restart
Configuration Value FillFactor Successful Requires restart
Configuration Value DisallowResultsFromTriggers Successful
Configuration Value NestedTriggers Successful
Configuration Value ServerTriggerRecursionEnabled Successful
Configuration Value RemoteAccess Successful Requires restart
Configuration Value DefaultLanguage Successful
Configuration Value CrossDBOwnershipChaining Successful
Configuration Value MaxWorkerThreads Successful
Configuration Value NetworkPacketSize Successful
Configuration Value ShowAdvancedOptions Successful
Configuration Value RemoteProcTrans Successful
Configuration Value C2AuditMode Successful Requires restart
Configuration Value DefaultFullTextLanguage Successful
Configuration Value TwoDigitYearCutoff Successful
Configuration Value IndexCreateMemory Successful
Configuration Value PriorityBoost Successful Requires restart
Configuration Value RemoteLoginTimeout Successful
Configuration Value RemoteQueryTimeout Successful
Configuration Value CursorThreshold Successful
Configuration Value SetWorkingSetSize Successful Requires restart
Configuration Value UserOptions Successful
Configuration Value AffinityMask Successful
Configuration Value ReplicationMaxTextSize Successful
Configuration Value MediaRetention Successful
Configuration Value CostThresholdForParallelism Successful
Configuration Value MaxDegreeOfParallelism Successful
Configuration Value MinMemoryPerQuery Successful
Configuration Value QueryWait Successful
Configuration Value MinServerMemory Successful
Configuration Value MaxServerMemory Successful
Configuration Value QueryGovernorCostLimit Successful
Configuration Value LightweightPooling Successful Requires restart
Configuration Value ScanForStartupProcedures Successful Requires restart
Configuration Value Affinity64Mask Successful
Configuration Value AffinityIOMask Successful Requires restart
Configuration Value Affinity64IOMask Successful Requires restart
Configuration Value TransformNoiseWords Successful
Configuration Value PrecomputeRank Successful
Configuration Value ProtocolHandlerTimeout Successful
Configuration Value IsSqlClrEnabled Successful
Configuration Value FullTextCrawlRangeMax Successful
Configuration Value FullTextNotifyBandwidthMin Successful
Configuration Value FullTextNotifyBandwidthMax Successful
Configuration Value FullTextCrawlBandwidthMin Successful
Configuration Value FullTextCrawlBandwidthMax Successful
Configuration Value DefaultTraceEnabled Successful
Configuration Value BlockedProcessThreshold Successful
Configuration Value InDoubtTransactionResolution Successful
Configuration Value RemoteDacConnectionsEnabled Successful
Configuration Value CommonCriteriaComplianceEnabled Successful Requires restart
Configuration Value ExtensibleKeyManagementEnabled Successful
Configuration Value DefaultBackupCompression Successful
Configuration Value FilestreamAccessLevel Successful
Configuration Value OptimizeAdhocWorkloads Successful
Configuration Value AccessCheckCacheBucketCount Successful
Configuration Value AccessCheckCacheQuota Successful
Configuration Value BackupChecksumDefault Successful
Configuration Value AutomaticSoftnumaDisabled Successful Requires restart
Configuration Value ExternalScriptsEnabled Successful
Configuration Value ClrStrictSecurity Successful
Configuration Value ColumnEncryptionEnclaveType Successful Requires restart
Configuration Value TempdbMetadataMemoryOptimized Successful Requires restart
Configuration Value AdrCleanerRetryTimeout Successful
Configuration Value AdrPreallcationFactor Successful
Configuration Value AgentXPsEnabled Successful
Configuration Value DatabaseMailEnabled Successful
Configuration Value SmoAndDmoXPsEnabled Successful
Configuration Value OleAutomationProceduresEnabled Successful
Configuration Value XPCmdShellEnabled Successful
Configuration Value AdHocDistributedQueriesEnabled Successful
Configuration Value ReplicationXPsEnabled Successful
Configuration Value ContainmentEnabled Successful
Configuration Value HadoopConnectivity Successful Requires restart
Configuration Value PolybaseNetworkEncryption Successful
Configuration Value RemoteDataArchiveEnabled Successful
Configuration Value AllowPolybaseExport Successful
Configuration Value AllowFilesystemEnumeration Successful
Configuration Value PolybaseEnabled Successful
Mail Configuration Server Configuration Successful
Mail Account SQL Alerts Successful
Mail Profile SQL Alerts Successful
Mail Server mail.XXXXXX.org Successful
Database CCCv2 Successful
Database COI Successful
Database DBA Successful
Database FootPrints Successful
Database FPReports Successful
Database HFWE Successful
Database LOGW Successful
Database SP_DAC Successful
Database SP_DAEP Successful
Database SP_MAS Successful
Database SP_MSHP Successful
Database SP_SWAV Successful
Database SPAT Successful
Database VISITS Successful
Login - WindowsUser AD\CESPINOS Failed
Login - WindowsGroup AD\DBA Admins Successful
Login - WindowsGroup AD\DBA Admins - IEO Successful
Login - WindowsUser AD\DBAGNEW Successful
Login - WindowsGroup AD\Dot Net Devs Successful
Login - WindowsUser AD\GMARKS Successful Database DAEP does not exist on [SQLEDTN01], switching DefaultDatabase to 'm...
Login - WindowsUser AD\HFWE_STG_APP_ACCT Successful
Login - WindowsUser AD\JKOPPISE Failed
Login - WindowsUser AD\KBROWN20 Failed
Login - WindowsUser AD\RSTONELO Failed
Login - WindowsUser AD\WAPPSTGAPP01$ Successful
Login - WindowsUser AD\WAPPSTGAPP02$ Successful
Login - WindowsUser AD\WAPPSTGWEB01$ Successful
Login - WindowsUser AD\WAPPSTGWEB02$ Successful
Login - SqlLogin ASPNetClient Successful Database ASPState does not exist on [SQLEDTN01], switching DefaultDatabase t...
Login - SqlLogin BWDBREMOTE Successful
Login - SqlLogin jherna26 Successful
Login - WindowsUser NT AUTHORITY\SYSTEM Skipped Local machine name
Login - WindowsUser NT SERVICE\MSSQLSERVER Skipped Local machine name
Login - WindowsUser NT SERVICE\SQLSERVERAGENT Skipped Local machine name
Login - WindowsUser NT SERVICE\SQLTELEMETRY Skipped Local machine name
Login - WindowsUser NT SERVICE\SQLWriter Skipped Local machine name
Login - WindowsUser NT SERVICE\Winmgmt Skipped Local machine name
Login - SqlLogin PII_Admin Successful
Login - SqlLogin SecurityProvider Successful Database SecurityProvider does not exist on [SQLEDTN01], switching DefaultDa...
Login - SqlLogin tadsuser Successful
Login - SqlLogin u_AS400 Successful
Login - SqlLogin u_CCCv2 Successful
Login - SqlLogin u_DAC Successful
Login - SqlLogin u_DAEP Successful Database DAEP does not exist on [SQLEDTN01], switching DefaultDatabase to 'm...
Login - SqlLogin u_DataServices Successful
Login - SqlLogin u_HEALTH Successful
Login - SqlLogin u_HFWE Successful
Login - SqlLogin u_HSIS Successful
Login - SqlLogin u_MAS Successful Database MAS does not exist on [SQLEDTN01], switching DefaultDatabase to 'ma...
Login - SqlLogin u_MSHP Successful Database MSHP does not exist on [SQLEDTN01], switching DefaultDatabase to 'm...
Login - SqlLogin u_PEIMS Successful
Login - SqlLogin u_SPAT Successful
Login - SqlLogin u_SWAV Successful
Login - SqlLogin visits Successful
Linked Server DAEP Successful SQLNCLI
Linked Server MENTOR_ACTIVITY Successful SQLNCLI11
Linked Server MENTOR_INFO Successful SQLNCLI
Linked Server PEIMSREPORT_UPLOAD Successful SQLNCLI
Linked Server PERSONNEL_INFO Successful SQLNCLI
Linked Server SQLDEV01 Successful SQLNCLI
Linked Server SQLINT01 Successful SQLNCLI
Data Collection Server Config Skipped Not supported at this time
Resource Governor Settings Classifier Function Skipped
Reconfigure Resource Governor Reconfigure Resource Governor Successful
User stored procedure in master [dbo].[ASPState_Startup] Successful
User stored procedure in master [dbo].[sp_WhoIsActive] Successful
User schema in msdb [AD\sqlman] Successful May have also created dependencies
User schema in msdb [DatabaseMailUserRole] Successful May have also created dependencies
User schema in msdb [db_ssisadmin] Successful May have also created dependencies
User schema in msdb [db_ssisltduser] Successful May have also created dependencies
User schema in msdb [db_ssisoperator] Successful May have also created dependencies
User schema in msdb [managed_backup] Failed Cannot drop schema 'managed_backup' because it is being referenced by object...
User schema in msdb [smart_admin] Failed Cannot drop schema 'smart_admin' because it is being referenced by object 'f...
User schema in msdb [SQLAgentOperatorRole] Successful May have also created dependencies
User schema in msdb [SQLAgentReaderRole] Successful May have also created dependencies
User schema in msdb [SQLAgentUserRole] Successful May have also created dependencies
User schema in msdb [TargetServersRole] Successful May have also created dependencies
User table valued fsunction in msdb [dbo].[fn_sysutility_ucp_get_policy_violations] Failed There is already an object named 'fn_sysutility_ucp_get_policy_violations' i...
User table valued fsunction in msdb [managed_backup].[fn_backup_db_config] Failed There is already an object named 'fn_backup_db_config' in the database.
User table valued fsunction in msdb [managed_backup].[fn_backup_instance_config] Failed There is already an object named 'fn_backup_instance_config' in the database.
User table valued fsunction in msdb [managed_backup].[fn_get_parameter] Failed There is already an object named 'fn_get_parameter' in the database.
User table valued fsunction in msdb [managed_backup].[fn_get_current_xevent_settings] Failed There is already an object named 'fn_get_current_xevent_settings' in the dat...
User table valued fsunction in msdb [managed_backup].[fn_get_health_status] Failed There is already an object named 'fn_get_health_status' in the database.
User table valued fsunction in msdb [smart_admin].[fn_backup_db_config] Failed There is already an object named 'fn_backup_db_config' in the database.
User table valued fsunction in msdb [smart_admin].[fn_backup_instance_config] Failed There is already an object named 'fn_backup_instance_config' in the database.
User table valued fsunction in msdb [smart_admin].[fn_get_parameter] Failed There is already an object named 'fn_get_parameter' in the database.
User table valued fsunction in msdb [smart_admin].[fn_get_current_xevent_settings] Failed There is already an object named 'fn_get_current_xevent_settings' in the dat...
User table valued fsunction in msdb [smart_admin].[fn_get_health_status] Failed There is already an object named 'fn_get_health_status' in the database.
User table valued fsunction in msdb [managed_backup].[fn_available_backups] Failed There is already an object named 'fn_available_backups' in the database.
User table valued fsunction in msdb [smart_admin].[fn_available_backups] Failed There is already an object named 'fn_available_backups' in the database.
view in msdb [dbo].[sysdtslog90] Successful
Extended Event DB_ACCESS_MONITORING_AS400StuData Failed
Extended Event DB_ACCESS_MONITORING_CCCv2 Failed
Extended Event DB_ACCESS_MONITORING_HFWE Failed
Extended Event DB_ACCESS_MONITORING_SPAT Failed
Extended Event DB_ACCESS_MONITORING_VISITS Failed
Extended Event telemetry_xevents Failed
Extended Event TrackLogins Successful
Agent Operator dba Successful
Agent Operator SQLAlerts Successful
Agent Operator SQLSupport Successful
Alert Defaults Alert Defaults Successful
Agent Alert SQLSTG01 Alert - Error 823: The operating system returned an error Successful
Agent Alert Notification SQLSTG01 Alert - Error 823: The operating system returned an error Successful
Agent Alert SQLSTG01 Alert - Error 824: Logical consistency-based I/O error Successful
Agent Alert Notification SQLSTG01 Alert - Error 824: Logical consistency-based I/O error Successful
Agent Alert SQLSTG01 Alert - Error 825: Read-Retry Required Successful
Agent Alert Notification SQLSTG01 Alert - Error 825: Read-Retry Required Successful
Agent Alert SQLSTG01 Alert - Error 832: Constant page has changed Successful
Agent Alert Notification SQLSTG01 Alert - Error 832: Constant page has changed Successful
Agent Alert SQLSTG01 Alert - Error 855: Uncorrectable hardware memory corruption detected Successful
Agent Alert Notification SQLSTG01 Alert - Error 855: Uncorrectable hardware memory corruption detected Successful
Agent Alert SQLSTG01 Alert - Error 856: SQL Server has detected hardware memory corruption, but has recovered the page Successful
Agent Alert Notification SQLSTG01 Alert - Error 856: SQL Server has detected hardware memory corruption, but has recovered the page Successful
Agent Alert SQLSTG01 Alert - Severity 14420: Log Shipping Primary Server Alert Successful
Agent Alert Notification SQLSTG01 Alert - Severity 14420: Log Shipping Primary Server Alert Successful
Agent Alert SQLSTG01 Alert - Severity 14421: Log Shipping Secondary Server Alert Successful
Agent Alert Notification SQLSTG01 Alert - Severity 14421: Log Shipping Secondary Server Alert Successful
Agent Alert SQLSTG01 Alert - Severity 19 Error: Fatal Error in Resource Successful
Agent Alert Notification SQLSTG01 Alert - Severity 19 Error: Fatal Error in Resource Successful
Agent Alert SQLSTG01 Alert - Severity 20 Error: Fatal Error in Current Process Successful
Agent Alert Notification SQLSTG01 Alert - Severity 20 Error: Fatal Error in Current Process Successful
Agent Alert SQLSTG01 Alert - Severity 21 Error: Fatal Error in Database Process Successful
Agent Alert Notification SQLSTG01 Alert - Severity 21 Error: Fatal Error in Database Process Successful
Agent Alert SQLSTG01 Alert - Severity 22 Error: Fatal Error: Table Integrity Suspect Successful
Agent Alert Notification SQLSTG01 Alert - Severity 22 Error: Fatal Error: Table Integrity Suspect Successful
Agent Alert SQLSTG01 Alert - Severity 23 Error: Fatal Error Database Integrity Suspect Successful
Agent Alert Notification SQLSTG01 Alert - Severity 23 Error: Fatal Error Database Integrity Suspect Successful
Agent Alert SQLSTG01 Alert - Severity 24 Error: Fatal Hardware Error Successful
Agent Alert Notification SQLSTG01 Alert - Severity 24 Error: Fatal Hardware Error Successful
Agent Alert SQLSTG01 Alert - Severity 25 Error: Fatal Error Successful
Agent Alert Notification SQLSTG01 Alert - Severity 25 Error: Fatal Error Successful
Credential DAEP_SIS_IMPORT Skipped Associated credential account, DAEP_SIS_IMPORT, does not exist on SQLEDTN01
Credential DAEP_SIS_IMPORT2 Skipped Associated credential account, DAEP_SIS_IMPORT, does not exist on SQLEDTN01
Credential VISITS_BC Skipped Associated credential account, jherna26, does not exist on SQLEDTN01
Agent Schedule ASPState_JobSchedule_DeleteExpiredSessions Successful
Agent Schedule BackupMaintenancePlan.Subplan_1 Successful
Agent Schedule CollectorSchedule_Every_10min Successful
Agent Schedule CollectorSchedule_Every_15min Successful
Agent Schedule CollectorSchedule_Every_30min Successful
Agent Schedule CollectorSchedule_Every_5min Successful
Agent Schedule CollectorSchedule_Every_60min Successful
Agent Schedule CollectorSchedule_Every_6h Successful
Agent Schedule Daily Successful
Agent Schedule Daily@7AM Successful
Agent Schedule Daily@7am Successful
Agent Schedule Daily@EveryHour Successful
Agent Schedule Daily_Every_10_Seconds Successful
Agent Schedule Daily_Every_15_Minutes Successful
Agent Schedule Every_2_min Successful
Agent Schedule First Of Month 3AM Successful
Agent Schedule MAINT - check_system_dbs Successful
Agent Schedule RunAsSQLAgentServiceStartSchedule Successful
Agent Schedule syspolicy_purge_history_schedule Skipped Schedule has associated jobs
Agent Job ASPState_Job_DeleteExpiredSessions Skipped Job is dependent on database: ASPState
Agent Job BackupMaintenancePlan.Subplan_1 Skipped Job is associated with maintenance plan
Agent Job DBA | ChangeRecoveryModel Successful
Agent Job DBA | ShrinkLog Successful
Agent Job ImportFSRegionalSupportByTechnician Skipped Job is dependent on proxy DAEP_SIS_IMPORT
Agent Job MAINT - check_system_dbs Successful
Agent Job MAINT - cycle_agent_error_logs Successful
Agent Job MAINT - cycle_error_logs Successful
Agent Job MAINT - purge_jobhistory Successful
Agent Job MAINT - purge_sysmail_history Successful
Agent Job MAINT - purge_syspolicy_history Successful
Agent Job MAS Mentor Agreement Approval Successful
Agent Job Run_DAEP_SIS_Import_Batch Skipped Job is dependent on proxy DAEP_SIS_IMPORT, DAEP_SIS_IMPORT2
Agent Job sp_BlitzFirst Successful
Agent Job sp_WhoIsActive_Capture Successful
Agent Job sp_WhoIsActive_Cleanup Successful
Agent Job Test Successful
Agent Job VISITS_BackgroundCheck_Job Skipped Job is dependent on proxy VISITS_BC
Agent Properties Server level properties Successful
Startup Stored Procedure ASPState_Startup Skipped Already exists on destination

Answered by potatoqualitee

Aug 18, 2022

Hello,
These two objects are not supported yet. We have no plans to migrate Maintenance plans (it was too complicated) and custom roles we have not gotten around to.

View full answer

potatoqualitee · 2022-08-18T15:03:28Z

potatoqualitee
Aug 18, 2022
Maintainer

Hello,
These two objects are not supported yet. We have no plans to migrate Maintenance plans (it was too complicated) and custom roles we have not gotten around to.

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Uh oh!

Help - dbatools.io - Start-DbaMigration - Maintenance Plans and Custom Server roles not migrated #8445

Uh oh!

{{title}}

Uh oh!

Replies: 1 comment

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

Uh oh!

Help - dbatools.io - Start-DbaMigration - Maintenance Plans and Custom Server roles not migrated #8445

Uh oh!

DBAgnew Jul 12, 2022

Replies: 1 comment

Uh oh!

potatoqualitee Aug 18, 2022 Maintainer

DBAgnew
Jul 12, 2022

potatoqualitee
Aug 18, 2022
Maintainer