SQL Server Instance Migration Transcript from Start-SqlMigration (dbatools.io)

dbatools-startmigration-transcript.txt

**********************
Windows PowerShell transcript start
Start time: 20160516223036
Username: BASE\ctrlb
RunAs User: BASE\ctrlb
Machine: NIMY (Microsoft Windows NT 10.0.14328.0)
Host Application: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
Process ID: 6208
PSVersion: 5.1.14328.1000
PSEdition: Desktop
PSCompatibleVersions: 1.0, 2.0, 3.0, 4.0, 5.0, 5.1.14328.1000
CLRVersion: 4.0.30319.42000
BuildVersion: 10.0.14328.1000
WSManStackVersion: 3.0
PSRemotingProtocolVersion: 2.3
SerializationVersion: 1.1.0.1
**********************
Transcript started, output file is .\dbatools-startmigration-transcript.txt


Migrating SQL Server Configuration
Updated recovery interval (min) to 0
Updated allow updates to 0
Updated user connections to 0
Updated locks to 0
Updated open objects to 0
Updated fill factor (%) to 0
Updated disallow results from triggers to 0
Updated nested triggers to 1
Updated server trigger recursion to 1
Updated remote access to 1
Updated default language to 0
Updated cross db ownership chaining to 0
Updated max worker threads to 0
Updated network packet size (B) to 4096
Updated show advanced options to 1
Updated remote proc trans to 0
Updated c2 audit mode to 0
Updated default full-text language to 1033
Updated two digit year cutoff to 2049
Updated index create memory (KB) to 0
Updated priority boost to 0
Updated remote login timeout (s) to 10
Updated remote query timeout (s) to 600
Updated cursor threshold to -1
Updated set working set size to 0
Updated user options to 0
Updated affinity mask to 0
Updated max text repl size (B) to 65536
Updated media retention to 0
Updated cost threshold for parallelism to 5
Updated max degree of parallelism to 0
Updated min memory per query (KB) to 1024
Updated query wait (s) to -1
Updated min server memory (MB) to 0
Updated max server memory (MB) to 2147483647
Updated query governor cost limit to 0
Updated lightweight pooling to 0
Updated scan for startup procs to 1
Updated affinity64 mask to 0
Updated affinity I/O mask to 0
Updated affinity64 I/O mask to 0
Updated transform noise words to 0
Updated precompute rank to 0
Updated PH timeout (s) to 60
Updated clr enabled to 1
Updated max full-text crawl range to 4
Updated ft notify bandwidth (min) to 0
Updated ft notify bandwidth (max) to 100
Updated ft crawl bandwidth (min) to 0
Updated ft crawl bandwidth (max) to 100
Updated default trace enabled to 1
Updated blocked process threshold (s) to 0
Updated in-doubt xact resolution to 0
Updated remote admin connections to 0
Updated common criteria compliance enabled to 0
Updated EKM provider enabled to 0
Updated backup compression default to 0
Updated filestream access level to 2
Updated optimize for ad hoc workloads to 0
Updated access check cache bucket count to 0
Updated access check cache quota to 0
Updated Agent XPs to 1
Updated Database Mail XPs to 1
Updated SMO and DMO XPs to 1
Updated Ole Automation Procedures to 0
Updated xp_cmdshell to 0
Updated Ad Hoc Distributed Queries to 0
Updated Replication XPs to 0
Updated contained database authentication to 0
Configuration option has been updated.
Server configuration update finished


Migrating custom errors (user defined messages)
Copying custom error 60000 us_english
Copying custom error 60000 Français
Custom error migration finished


Migrating SQL credentials
Performing SMO version check
Getting NetBios name
Checking if remote access is enabled
Checking if Remote Registry is enabled
Collecting Credential logins and passwords on sql2012
Starting migration
Attempting to migrate PowerShell Proxy Account
PowerShell Proxy Account successfully copied
Credential migration finished


Migrating database mail
Migrating mail server configuration values
Migrating accounts
Copying mail account The DBA Team
Migrating mail profiles
Copying mail profile The DBA Team
Migrating mail servers
Copying mail server smtp.ad.local
Mail migration finished


Migrating user objects in system databases (this can take a second)
Copying from master
Copying from model
Copying from msdb
Migrating user objects in system databases finished


Migrating Central Management Server
Connecting to Central Management Servers
Creating group Accounting
Added Server sqlserver2014a as acct1sql to Accounting
Creating group Accounting Cluster
Added Server sqlserver2014a as acctsqlcluster to Accounting Cluster
Creating group HR
Added Server sqlserver2014a as hr1sql to HR
Added Server sqlserver2014a as hr2sql to HR
Central Management Server migration finished


Migrating Backup Devices
Resolving NetBios name
Scripting out SQL for Old School
Preparing to copy actual backup file
Checking if directory \\sqlbackups\sql exists
Adding backup device Old School on SQL2016
Backup device Old School successfully copied
backup device migration finished


Migrating linked servers
Getting NetBios name
Checking if remote access is enabled
Checking if Remote Registry is enabled
Collecting Linked Server logins and passwords on sql2012
Starting migration
Attempting to migrate: localhost
localhost successfully copied
Finished migrating logins for localhost
Attempting to migrate: repl_distributor
repl_distributor successfully copied
Finished migrating logins for repl_distributor
Linked Server migration finished


Migrating System Triggers
Copying server trigger Logon_Trigger
Server trigger migration finished

Migrating databases
Attempting to connect to Sql Servers..
WARNING: FILESTREAM enabled on SQL2012 but not SQL2016. Databases that use FILESTREAM will be skipped.
Checking access to remote directories...
Resolving NetBIOS name for SQL2012...
Resolving NetBIOS name for SQL2016...

######### Database: db1 #########
Started: 05/16/2016 22:30:55
Successfully restored db1
Successfully updated BrokerEnabled to True for db1 on SQL2016
Finished: 05/16/2016 22:30:59
Elapsed time: 00:00:03

######### Database: db4 #########
Started: 05/16/2016 22:30:59
Successfully restored db4
Successfully updated BrokerEnabled to True for db4 on SQL2016
Finished: 05/16/2016 22:31:00
Elapsed time: 00:00:01

######### Database: dbclrassembly #########
Started: 05/16/2016 22:31:00
Successfully restored dbclrassembly
Successfully updated Trustworthy to True for dbclrassembly on SQL2016
Successfully updated BrokerEnabled to True for dbclrassembly on SQL2016
Finished: 05/16/2016 22:31:01
Elapsed time: 00:00:01

######### Database: dbdatacollection #########
Started: 05/16/2016 22:31:02
Successfully restored dbdatacollection
Successfully updated BrokerEnabled to True for dbdatacollection on SQL2016
Finished: 05/16/2016 22:32:14
Elapsed time: 00:01:12

######### Database: dbfilestream #########
WARNING: Skipping dbfilestream (contains FILESTREAM)

######### Database: dbfulltext #########
Started: 05/16/2016 22:32:14
Successfully restored dbfulltext
Successfully updated BrokerEnabled to True for dbfulltext on SQL2016
Finished: 05/16/2016 22:32:15
Elapsed time: 00:00:00

######### Database: dboffline #########
WARNING: Skipping dboffline. Database is inaccessible.

######### Database: dbreadonly #########
Started: 05/16/2016 22:32:15
Successfully restored dbreadonly
Finished: 05/16/2016 22:32:16
Elapsed time: 00:00:01

Database migration finished
Migration started: 05/16/2016 22:30:55
Migration completed: 05/16/2016 22:32:17
Total Elapsed time: 00:01:21
WARNING: This script does not delete backup files. Backups still exist at \\nas\share\sql\migration.


Migrating logins
Attempting to connect to SQL Servers..
Migration started: 05/16/2016 22:32:17
Attempting Login Migration
Skipping ##MS_PolicyEventProcessingLogin##
Skipping ##MS_PolicyTsqlExecutionLogin##
BASE\ctrlb already exists in destination. Use -force to drop and recreate.
Attempting to add base\powershell to SQL2016
Setting base\powershell SID to source username SID
Setting login language to us_english
Set base\powershell defaultdb to master
Adding as login type WindowsUser
Setting language as us_english
Successfully added base\powershell to SQL2016
Added base\powershell tosysadmin server role.
Successfully performed Grant ADMINISTER BULK OPERATIONS to base\powershell
Successfully performed Grant CONNECT SQL to base\powershell
Successfully performed Grant CONNECT to base\powershell on msdb
Successfully performed Grant CONNECT to base\powershell on dbdatacollection
BASE\sqlserver already exists in destination. Use -force to drop and recreate.
Attempting to add dbcollectionlogin to SQL2016
Setting dbcollectionlogin SID to source username SID
Setting login language to us_english
Set dbcollectionlogin defaultdb to master
Successfully added dbcollectionlogin to SQL2016
Successfully performed Grant CONNECT SQL to dbcollectionlogin
Attempting to add distributor_admin to SQL2016
Setting distributor_admin SID to source username SID
Setting login language to us_english
Set distributor_admin defaultdb to master
Successfully added distributor_admin to SQL2016
Added distributor_admin tosysadmin server role.
Successfully performed Grant CONNECT SQL to distributor_admin
Stating NT AUTHORITY\SYSTEM is skipped because it is a local machine name.
Stating NT SERVICE\MSSQLSERVER is skipped because it is a local machine name.
Stating NT SERVICE\SQLSERVERAGENT is skipped because it is a local machine name.
Stating NT SERVICE\SQLWriter is skipped because it is a local machine name.
Stating NT SERVICE\Winmgmt is skipped because it is a local machine name.
Skipping sa
Attempting to add testuser1 to SQL2016
Setting testuser1 SID to source username SID
Setting login language to Dansk
WARNING: db5 does not exist on destination. Setting defaultdb to master.
Set testuser1 defaultdb to master
Successfully added testuser1 to SQL2016
Added testuser1 tobulkadmin server role.
Added testuser1 todbcreator server role.
Added testuser1 todiskadmin server role.
Added testuser1 tosysadmin server role.
Successfully performed Grant CONNECT SQL to testuser1
Added user testuser1 (login: testuser1) to msdb
Successfully performed Grant CONNECT to testuser1 on msdb
Successfully performed Grant CONNECT to testuser1 on db1
Attempting to add testuser2 to SQL2016
Setting testuser2 SID to source username SID
Setting login language to us_english
Set testuser2 defaultdb to master
Successfully added testuser2 to SQL2016
Added testuser2 tosetupadmin server role.
Successfully performed Deny CONNECT SQL to testuser2
Attempting to add testuserkey to SQL2016
Setting testuserkey SID to source username SID
Setting login language to slovenčina
WARNING: dbmultifilegroup does not exist on destination. Setting defaultdb to master.
Set testuserkey defaultdb to master
Successfully added testuserkey to SQL2016
Added testuserkey tobulkadmin server role.
Added testuserkey todbcreator server role.
Added testuserkey todiskadmin server role.
Added testuserkey toprocessadmin server role.
Added testuserkey tosecurityadmin server role.
Added testuserkey toserveradmin server role.
Added testuserkey tosetupadmin server role.
Added testuserkey tosysadmin server role.
Successfully performed Grant CONNECT SQL to testuserkey
Added user testuserkey (login: testuserkey) to msdb
Successfully performed Grant CONNECT to testuserkey on msdb
Successfully performed Grant CONNECT to testuserkey on db1
Login migration completed: 05/16/2016 22:32:20
Total elapsed time: 00:00:03


Updating database owners to match newly migrated logins
Proper owner already set on db1
Proper owner already set on db4
Proper owner already set on dbclrassembly
Proper owner already set on dbdatacollection
Proper owner already set on dbfulltext
Proper owner already set on dbreadonly
Proper owner already set on ReportServer
Proper owner already set on ReportServerTempDB


Migrating Data Collector collection sets
WARNING: Server reconfiguration not yet supported. Only Collection Set migration will be migrated at this time.
Migrating collection sets
Migrating collection set DMV Test
Starting collection set DMV Test
WARNING: Collection Set 'Stored Procedure Usage Analysis' was skipped because it already exists on SQL2016
WARNING: Use -Force to drop and recreate
WARNING: Collection Set 'Table Usage Analysis' was skipped because it already exists on SQL2016
WARNING: Use -Force to drop and recreate
Data Collector migration finished


Migrating Audits
File path C:\Audits\ exists on SQL2016.
Copying server audit Audit-20160502-100608
Server audit migration finished


Migrating Server Audit Specifications
Copying server audit ServerAuditSpecification-20160502-100608
Server audit migration finished


Migrating Endpoints
Copying server endpoint endpoint_mirroring
Server endpoint migration finished


Migrating Policy Management
Migrating conditions
Copying condition aaa
Copying condition goodcondition
Migrating policies
Copying policy xp_cmdshell must be disabled
Policy Management migration finished


Migrating Resource Governor
Updating Resource Governor settings
Migrating pools
Copying pool Mega-Memory
Copying Low
Reconfiguring Resource Governor
Resource Governor migration finished


Migrating Extended Events
Migrating sessions
Migrating session TrackTempdbFileWrites
Extended Event migration finished


Migrating job server
Copying Operator category New Operator Category for Migration
Operator category migration finished
Copying Alert category New Alert Category for Migration
Alert category migration finished
Copying Job category New Job Category for Migration
Job category migration finished
Agent category migration finished
Copying Alert Defaults
Copying Alert Error Number 823
Copying Alert Error Number 824
Copying Alert Error Number 825
Copying Alert Peer-to-peer conflict detection alert
Copying Alert Replication Warning: Long merge over dialup connection (Threshold: mergeslowrunduration)
Copying Alert Replication Warning: Long merge over LAN connection (Threshold: mergefastrunduration)
Copying Alert Replication Warning: Slow merge over dialup connection (Threshold: mergeslowrunspeed)
Copying Alert Replication Warning: Slow merge over LAN connection (Threshold: mergefastrunspeed)
Copying Alert Replication Warning: Subscription expiration (Threshold: expiration)
Copying Alert Replication Warning: Transactional replication latency (Threshold: latency)
Copying Alert Replication: agent custom shutdown
Copying Alert Replication: agent failure
Copying Alert Replication: agent retry
Copying Alert Replication: agent success
Copying Alert Replication: expired subscription dropped
Copying Alert Replication: Subscriber has failed data validation
Copying Alert Replication: Subscriber has passed data validation
Copying Alert Replication: Subscription reinitialized after validation failure
Copying Alert Severity 016
Copying Alert Severity 017
Copying Alert Severity 018
Copying Alert Severity 019
Copying Alert Severity 020
Copying Alert Severity 021
Copying Alert Severity 022
Copying Alert Severity 023
Copying Alert Severity 024
Copying Alert Severity 025
Alert migration finished
Copying Operator The DBA Team
Operator migration finished
Copying server proxy account PowerShell Proxy
WARNING: One or more subsystems do not exist on the destination server. Skipping that part.
Server proxy account migration finished
WARNING: Shared job schedule CollectorSchedule_Every_10min exists at destination. Use -Force to drop and migrate.
WARNING: Shared job schedule CollectorSchedule_Every_15min exists at destination. Use -Force to drop and migrate.
WARNING: Shared job schedule CollectorSchedule_Every_30min exists at destination. Use -Force to drop and migrate.
WARNING: Shared job schedule CollectorSchedule_Every_5min exists at destination. Use -Force to drop and migrate.
WARNING: Shared job schedule CollectorSchedule_Every_60min exists at destination. Use -Force to drop and migrate.
WARNING: Shared job schedule CollectorSchedule_Every_6h exists at destination. Use -Force to drop and migrate.
Copying schedule Daily
Copying schedule Hourly
WARNING: Shared job schedule mdw_purge_data_schedule exists at destination. Use -Force to drop and migrate.
WARNING: Shared job schedule OccursEvery15Minutes exists at destination. Use -Force to drop and migrate.
WARNING: Shared job schedule OccursEveryOneHour exists at destination. Use -Force to drop and migrate.
WARNING: Shared job schedule OccursOnceADayAt12:01AM exists at destination. Use -Force to drop and migrate.
Copying schedule Replication agent schedule.
Copying schedule Replication agent schedule.
Copying schedule Replication agent schedule.
Copying schedule Replication agent schedule.
Copying schedule Replication agent schedule.
Copying schedule Replication agent schedule.
Copying schedule Replication agent schedule.
Copying schedule Replication agent schedule.
WARNING: Shared job schedule RunAsSQLAgentServiceStartSchedule exists at destination. Use -Force to drop and migrate.
WARNING: Shared job schedule syspolicy_purge_history_schedule exists at destination. Use -Force to drop and migrate.
Job schedule migration finished
WARNING: Database(s) distribution doesn't exist on destination. Skipping.
WARNING: Job collection_set_1_noncached_collect_and_upload exists at destination. Use -Force to drop and migrate.
Copying Job collection_set_10_collection
Copying Job collection_set_10_upload
WARNING: Job collection_set_2_collection exists at destination. Use -Force to drop and migrate.
WARNING: Job collection_set_2_upload exists at destination. Use -Force to drop and migrate.
WARNING: Job collection_set_3_collection exists at destination. Use -Force to drop and migrate.
WARNING: Job collection_set_3_upload exists at destination. Use -Force to drop and migrate.
WARNING: Job collection_set_6_collection exists at destination. Use -Force to drop and migrate.
WARNING: Job collection_set_6_upload exists at destination. Use -Force to drop and migrate.
WARNING: Job collection_set_7_collection exists at destination. Use -Force to drop and migrate.
WARNING: Job collection_set_7_upload exists at destination. Use -Force to drop and migrate.
Copying Job DatabaseBackup - SYSTEM_DATABASES - FULL
Copying Job DatabaseBackup - USER_DATABASES - FULL
Copying Job DatabaseBackup - USER_DATABASES - LOG
WARNING: Database(s) distribution doesn't exist on destination. Skipping.
Copying Job Expired subscription clean up
Copying Job mdw_purge_data_[dbdatacollection]
Copying Job Reinitialize subscriptions having data validation failures
Copying Job Replication agents checkup
WARNING: Database(s) distribution doesn't exist on destination. Skipping.
WARNING: Database(s) distribution doesn't exist on destination. Skipping.
WARNING: Database(s) distribution doesn't exist on destination. Skipping.
WARNING: Database(s) distribution doesn't exist on destination. Skipping.
WARNING: Job syspolicy_purge_history exists at destination. Use -Force to drop and migrate.
WARNING: Job sysutility_get_cache_tables_data_into_aggregate_tables_daily exists at destination. Use -Force to drop and migrate.
WARNING: Job sysutility_get_cache_tables_data_into_aggregate_tables_hourly exists at destination. Use -Force to drop and migrate.
WARNING: Job sysutility_get_views_data_into_cache_tables exists at destination. Use -Force to drop and migrate.
Job migration finished
Job server migration finished


SQL Server migration complete
Migration started: 05/16/2016 22:30:36
Migration completed: 05/16/2016 22:32:30
Total Elapsed time: 00:01:53
**********************
Windows PowerShell transcript end
End time: 20160516223230
**********************