functions/Export-DbaInstance.ps1
|
function Export-DbaInstance { <# .SYNOPSIS Exports SQL Server *ALL* database restore scripts, logins, database mail profiles/accounts, credentials, SQL Agent objects, linked servers, Central Management Server objects, server configuration settings (sp_configure), user objects in systems databases, system triggers and backup devices from one SQL Server to another. For more granular control, please use one of the -Exclude parameters and use the other functions available within the dbatools module. .DESCRIPTION Export-DbaInstance consolidates most of the export scripts in dbatools into one command. This is useful when you're looking to Export entire instances. It less flexible than using the underlying functions. Think of it as an easy button. Unless an -Exclude is specified, it exports: All database restore scripts. All logins. All database mail objects. All credentials. All objects within the Job Server (SQL Agent). All linked servers. All groups and servers within Central Management Server. All SQL Server configuration objects (everything in sp_configure). All user objects in system databases. All system triggers. All system backup devices. All Audits. All Endpoints. All Extended Events. All Policy Management objects. All Resource Governor objects. All Server Audit Specifications. All Custom Errors (User Defined Messages). All Server Roles. All Availability Groups. .PARAMETER SqlInstance The target SQL Server instances .PARAMETER SqlCredential Login to the target instance using alternative credentials. Accepts PowerShell credentials (Get-Credential). Windows Authentication, SQL Server Authentication, Active Directory - Password, and Active Directory - Integrated are all supported. For MFA support, please use Connect-DbaInstance. .PARAMETER Credential Alternative Windows credentials for exporting Linked Servers and Credentials. Accepts credential objects (Get-Credential) .PARAMETER Path Specifies the directory where the file or files will be exported. .PARAMETER WithReplace If this switch is used, databases are restored from backup using WITH REPLACE. This is useful if you want to stage some complex file paths. .PARAMETER NoRecovery If this switch is used, databases will be left in the No Recovery state to enable further backups to be added. .PARAMETER IncludeDbMasterKey Exports the db master key then logs into the server to copy it to the $Path .PARAMETER Exclude Exclude one or more objects to export Databases Logins AgentServer Credentials LinkedServers SpConfigure CentralManagementServer DatabaseMail SysDbUserObjects SystemTriggers BackupDevices Audits Endpoints ExtendedEvents PolicyManagement ResourceGovernor ServerAuditSpecifications CustomErrors ServerRoles AvailabilityGroups ReplicationSettings .PARAMETER BatchSeparator Batch separator for scripting output. "GO" by default. .PARAMETER NoPrefix If this switch is used, the scripts will not include prefix information containing creator and datetime. .PARAMETER ExcludePassword If this switch is used, the scripts will not include passwords for Credentials, LinkedServers or Logins. .PARAMETER ScriptingOption Add scripting options to scripting output for all objects except Registered Servers and Extended Events. .PARAMETER Append Append to the target file instead of overwriting. .PARAMETER EnableException By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message. This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting. Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch. .NOTES Tags: Export Author: Chrissy LeMaire (@cl), netnerds.net Website: https://dbatools.io Copyright: (c) 2018 by dbatools, licensed under MIT License: MIT https://opensource.org/licenses/MIT .LINK https://dbatools.io/Export-DbaInstance .EXAMPLE PS C:\> Export-DbaInstance -SqlInstance sqlserver\instance All databases, logins, job objects and sp_configure options will be exported from sqlserver\instance to an automatically generated folder name in Documents. .EXAMPLE PS C:\> Export-DbaInstance -SqlInstance sqlcluster -Exclude Databases, Logins -Path C:\dr\sqlcluster Exports everything but logins and database restore scripts to C:\dr\sqlcluster .EXAMPLE PS C:\> Export-DbaInstance -SqlInstance sqlcluster -Path C:\servers\ -NoPrefix Exports everything to C:\servers but scripts do not include prefix information. #> [CmdletBinding()] param ( [parameter(Mandatory, ValueFromPipeline)] [DbaInstanceParameter[]]$SqlInstance, [PSCredential]$SqlCredential, [PSCredential]$Credential, [Alias("FilePath")] [string]$Path = (Get-DbatoolsConfigValue -FullName 'Path.DbatoolsExport'), [switch]$NoRecovery, [switch]$IncludeDbMasterKey, [ValidateSet('Databases', 'Logins', 'AgentServer', 'Credentials', 'LinkedServers', 'SpConfigure', 'CentralManagementServer', 'DatabaseMail', 'SysDbUserObjects', 'SystemTriggers', 'BackupDevices', 'Audits', 'Endpoints', 'ExtendedEvents', 'PolicyManagement', 'ResourceGovernor', 'ServerAuditSpecifications', 'CustomErrors', 'ServerRoles', 'AvailabilityGroups', 'ReplicationSettings')] [string[]]$Exclude, [string]$BatchSeparator = 'GO', [switch]$Append, [Microsoft.SqlServer.Management.Smo.ScriptingOptions]$ScriptingOption, [switch]$NoPrefix = $false, [switch]$ExcludePassword, [switch]$EnableException ) begin { $null = Test-ExportDirectory -Path $Path if (-not $ScriptingOption) { $ScriptingOption = New-DbaScriptingOption } $elapsed = [System.Diagnostics.Stopwatch]::StartNew() $started = Get-Date $ScriptingOptions = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions $ScriptingOptions.ScriptBatchTerminator = $true } process { if (Test-FunctionInterrupt) { return } foreach ($instance in $SqlInstance) { $stepCounter = $fileCounter = 0 try { $server = Connect-SqlInstance -SqlInstance $instance -SqlCredential $SqlCredential -MinimumVersion 10 } catch { Stop-Function -Message "Error occurred while establishing connection to $instance" -Category ConnectionError -ErrorRecord $_ -Target $instance -Continue } $timeNow = (Get-Date -uformat "%m%d%Y%H%M%S") $exportPath = Join-DbaPath -Path $Path -Child "$($server.name.replace('\', '$'))-$timeNow" if (-not (Test-Path $exportPath)) { try { $null = New-Item -ItemType Directory -Path $exportPath -ErrorAction Stop } catch { Stop-Function -Message "Failure" -ErrorRecord $_ return } } if ($Exclude -notcontains 'SpConfigure') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting SQL Server Configuration" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting SQL Server Configuration" Export-DbaSpConfigure -SqlInstance $server -FilePath "$exportPath\$fileCounter-sp_configure.sql" if (-not (Test-Path "$exportPath\$fileCounter-sp_configure.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'CustomErrors') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting custom errors (user defined messages)" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting custom errors (user defined messages)" $null = Get-DbaCustomError -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-customererrors.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-customererrors.sql" if (-not (Test-Path "$exportPath\$fileCounter-customererrors.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'ServerRoles') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting server roles" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting server roles" $null = Get-DbaServerRole -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-serverroles.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-serverroles.sql" if (-not (Test-Path "$exportPath\$fileCounter-serverroles.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'Credentials') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting SQL credentials" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting SQL credentials" $null = Export-DbaCredential -SqlInstance $server -Credential $Credential -FilePath "$exportPath\$fileCounter-credentials.sql" -Append:$Append -ExcludePassword:$ExcludePassword Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-credentials.sql" if (-not (Test-Path "$exportPath\$fileCounter-credentials.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'DatabaseMail') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting database mail" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting database mail" $null = Get-DbaDbMailConfig -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-dbmail.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix $null = Get-DbaDbMailAccount -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-dbmail.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix $null = Get-DbaDbMailProfile -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-dbmail.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix $null = Get-DbaDbMailServer -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-dbmail.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix $null = Get-DbaDbMail -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-dbmail.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-dbmail.sql" if (-not (Test-Path "$exportPath\$fileCounter-dbmail.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'CentralManagementServer') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting Central Management Server" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting Central Management Server" $null = Get-DbaRegServerGroup -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-regserver.sql" -Append:$Append -BatchSeparator 'GO' -NoPrefix:$NoPrefix $null = Get-DbaRegServer -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-regserver.sql" -Append:$Append -BatchSeparator 'GO' -NoPrefix:$NoPrefix Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-regserver.sql" if (-not (Test-Path "$exportPath\$fileCounter-regserver.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'BackupDevices') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting Backup Devices" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting Backup Devices" $null = Get-DbaBackupDevice -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-backupdevices.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-backupdevices.sql" if (-not (Test-Path "$exportPath\$fileCounter-backupdevices.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'LinkedServers') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting linked servers" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting linked servers" Export-DbaLinkedServer -SqlInstance $server -FilePath "$exportPath\$fileCounter-linkedservers.sql" -Credential $Credential -Append:$Append -ExcludePassword:$ExcludePassword if (-not (Test-Path "$exportPath\$fileCounter-linkedservers.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'SystemTriggers') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting System Triggers" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting System Triggers" $null = Get-DbaInstanceTrigger -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-servertriggers.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix $triggers = Get-Content -Path "$exportPath\$fileCounter-servertriggers.sql" -Raw -ErrorAction Ignore if ($triggers) { $triggers = $triggers.ToString() -replace 'CREATE TRIGGER', "GO`r`nCREATE TRIGGER" $triggers = $triggers.ToString() -replace 'ENABLE TRIGGER', "GO`r`nENABLE TRIGGER" $null = $triggers | Set-Content -Path "$exportPath\$fileCounter-servertriggers.sql" -Force Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-servertriggers.sql" } if (-not (Test-Path "$exportPath\$fileCounter-servertriggers.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'Databases') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting database restores" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting database restores" Get-DbaDbBackupHistory -SqlInstance $server -Last | Restore-DbaDatabase -SqlInstance $server -NoRecovery:$NoRecovery -WithReplace -OutputScriptOnly -WarningAction SilentlyContinue | Out-File -FilePath "$exportPath\$fileCounter-databases.sql" -Append:$Append Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-databases.sql" if (-not (Test-Path "$exportPath\$fileCounter-databases.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'Logins') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting logins" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting logins" Export-DbaLogin -SqlInstance $server -FilePath "$exportPath\$fileCounter-logins.sql" -Append:$Append -ExcludePassword:$ExcludePassword -NoPrefix:$NoPrefix -WarningAction SilentlyContinue if (-not (Test-Path "$exportPath\$fileCounter-logins.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'Audits') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting Audits" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting Audits" $null = Get-DbaInstanceAudit -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-audits.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-audits.sql" if (-not (Test-Path "$exportPath\$fileCounter-audits.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'ServerAuditSpecifications') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting Server Audit Specifications" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting Server Audit Specifications" $null = Get-DbaInstanceAuditSpecification -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-auditspecs.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-auditspecs.sql" if (-not (Test-Path "$exportPath\$fileCounter-auditspecs.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'Endpoints') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting Endpoints" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting Endpoints" $null = Get-DbaEndpoint -SqlInstance $server | Where-Object IsSystemObject -eq $false | Export-DbaScript -FilePath "$exportPath\$fileCounter-endpoints.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-endpoints.sql" if (-not (Test-Path "$exportPath\$fileCounter-endpoints.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'PolicyManagement') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting Policy Management" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting Policy Management" $null = Get-DbaPbmCondition -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-policymanagement.sql" -Append:$Append -BatchSeparator $BatchSeparator -NoPrefix:$NoPrefix $null = Get-DbaPbmObjectSet -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-policymanagement.sql" -Append:$Append -BatchSeparator $BatchSeparator -NoPrefix:$NoPrefix $null = Get-DbaPbmPolicy -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-policymanagement.sql" -Append:$Append -BatchSeparator $BatchSeparator -NoPrefix:$NoPrefix Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-policymanagement.sql" if (-not (Test-Path "$exportPath\$fileCounter-policymanagement.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'ResourceGovernor') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting Resource Governor" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting Resource Governor" $null = Get-DbaResourceGovernor -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-resourcegov.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix $null = Get-DbaRgClassifierFunction -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-resourcegov.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix $null = Get-DbaRgResourcePool -SqlInstance $server | Where-Object Name -notin 'default', 'internal' | Export-DbaScript -FilePath "$exportPath\$fileCounter-resourcegov.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix $null = Get-DbaRgWorkloadGroup -SqlInstance $server | Where-Object Name -notin 'default', 'internal' | Export-DbaScript -FilePath "$exportPath\$fileCounter-resourcegov.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix $null = Add-Content -Value "ALTER RESOURCE GOVERNOR RECONFIGURE" -Path "$exportPath\$fileCounter-resourcegov.sql" Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-resourcegov.sql" if (-not (Test-Path "$exportPath\$fileCounter-resourcegov.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'ExtendedEvents') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting Extended Events" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting Extended Events" $null = Get-DbaXESession -SqlInstance $server | Export-DbaXeSession -FilePath "$exportPath\$fileCounter-extendedevents.sql" -Append:$Append -BatchSeparator 'GO' -NoPrefix:$NoPrefix Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-extendedevents.sql" if (-not (Test-Path "$exportPath\$fileCounter-extendedevents.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'AgentServer') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting job server" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting job server" $null = Get-DbaAgentJobCategory -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-sqlagent.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix $null = Get-DbaAgentOperator -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-sqlagent.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix $null = Get-DbaAgentAlert -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-sqlagent.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix $null = Get-DbaAgentProxy -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-sqlagent.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix $null = Get-DbaAgentSchedule -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-sqlagent.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix $null = Get-DbaAgentJob -SqlInstance $server | Export-DbaScript -FilePath "$exportPath\$fileCounter-sqlagent.sql" -Append:$Append -BatchSeparator $BatchSeparator -ScriptingOptionsObject $ScriptingOption -NoPrefix:$NoPrefix Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-sqlagent.sql" if (-not (Test-Path "$exportPath\$fileCounter-sqlagent.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'ReplicationSettings') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting replication settings" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting replication settings" $null = Export-DbaRepServerSetting -SqlInstance $instance -SqlCredential $SqlCredential -FilePath "$exportPath\$fileCounter-replication.sql" Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-replication.sql" if (-not (Test-Path "$exportPath\$fileCounter-replication.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'SysDbUserObjects') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting user objects in system databases (this can take a minute)." Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting user objects in system databases (this can take a minute)." $null = Export-DbaSysDbUserObject -SqlInstance $server -FilePath "$exportPath\$fileCounter-userobjectsinsysdbs.sql" -BatchSeparator $BatchSeparator -NoPrefix:$NoPrefix -ScriptingOptionsObject $ScriptingOption Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-userobjectsinsysdbs.sql" if (-not (Test-Path "$exportPath\$fileCounter-userobjectsinsysdbs.sql")) { $fileCounter-- } } if ($Exclude -notcontains 'AvailabilityGroups') { $fileCounter++ Write-Message -Level Verbose -Message "Exporting availability group" Write-ProgressHelper -StepNumber ($stepCounter++) -Message "Exporting availability groups" $null = Get-DbaAvailabilityGroup -SqlInstance $server -WarningAction SilentlyContinue | Export-DbaScript -FilePath "$exportPath\$fileCounter-DbaAvailabilityGroups.sql" -Append:$Append -BatchSeparator $BatchSeparator -NoPrefix:$NoPrefix #-ScriptingOptionsObject $ScriptingOption Get-ChildItem -ErrorAction Ignore -Path "$exportPath\$fileCounter-DbaAvailabilityGroups.sql" if (-not (Test-Path "$exportPath\$fileCounter-DbaAvailabilityGroups.sql")) { $fileCounter-- } } Write-Progress -Activity "Performing Instance Export for $instance" -Completed } } end { $totalTime = ($elapsed.Elapsed.toString().Split(".")[0]) Write-Message -Level Verbose -Message "SQL Server export complete." Write-Message -Level Verbose -Message "Export started: $started" Write-Message -Level Verbose -Message "Export completed: $(Get-Date)" Write-Message -Level Verbose -Message "Total Elapsed time: $totalTime" } } |