$Query = $Query + " AND Backup Master backs up your SQL Server databases to any number of popular cloud storage services such as Dropbox, OneDrive, Amazon S3, Microsoft Azure, Box, and Google Drive. _device_name,ĭATEDIFF(MI, _finish_date, GETDATE()) AS last_backup_minutes,ĭATEDIFF(MI, _start_date, _finish_date) AS last_backup_duration_min $SqlConnection = Open-IcingaMSSQLConnection -Username $SqlUsername -Password $SqlPassword -Address $SqlHost -IntegratedSecurity: $IntegratedSecurity -Port $SqlPort By default the entireįunction Get-IcingaMSSQLBackupOverallStatus Large and if there is no maintenance task in place to shrink it, this script could time out. Over time, the history table can get quite Specifies the number of days to read the backup history from MSSQL. Running with can access to the MSSQL database you will not require to provide username If this is set and the user the PowerShell is
The port of the MSSQL server/instance to connect to with the provided credentialsĪllows this plugin to use the credentials of the current PowerShell session inherited by The IP address or FQDN to the MSSQL server to connect to The password for connecting to the MSSQL database as secure string The username for connecting to the MSSQL database Specifies the database or databases which will be checked. Otherwise leave it empty and use theĪuthentication by username/password or integrate security Use an already existing and established SQL object for query handling. PS>Get-IcingaMSSQLBackupOverallStatus -IntegratedSecurity -SqlHost '' -IncludeDatabase 'ExampleDatabase','AnotherDatabase' Get-IcingaMSSQLBackupOverallStatus -SqlUsername 'username' -SqlPassword (ConvertTo-IcingaSecureString 'password') -SqlHost ''
0 kommentar(er)
