Get-SqlBackupHistory

Синтаксис

ByPath (по умолчанию)

Get-SqlBackupHistory
    [[-Path] <String[]>]
    [-Since <SinceType>]
    [-StartTime <DateTime>]
    [-EndTime <DateTime>]
    [-BackupType <BackupSetType>]
    [-IncludeSnapshotBackups]
    [-TimeSpan <TimeSpan>]
    [-IgnoreProviderContext]
    [-SuppressProviderContextWarning]
    [-AccessToken <PSObject>]
    [-TrustServerCertificate]
    [-HostNameInCertificate <String>]
    [-Encrypt <String>]
    [-DatabaseName <System.Collections.Generic.List`1[System.String]>]
    [<CommonParameters>]

ByName

Get-SqlBackupHistory
    [[-ServerInstance] <String[]>]
    [-Since <SinceType>]
    [-StartTime <DateTime>]
    [-EndTime <DateTime>]
    [-BackupType <BackupSetType>]
    [-IncludeSnapshotBackups]
    [-TimeSpan <TimeSpan>]
    [-IgnoreProviderContext]
    [-SuppressProviderContextWarning]
    [-Credential <PSCredential>]
    [-ConnectionTimeout <Int32>]
    [-AccessToken <PSObject>]
    [-TrustServerCertificate]
    [-HostNameInCertificate <String>]
    [-Encrypt <String>]
    [-DatabaseName <System.Collections.Generic.List`1[System.String]>]
    [<CommonParameters>]

ByObject

Get-SqlBackupHistory
    [-InputObject] <Server[]>
    [-Since <SinceType>]
    [-StartTime <DateTime>]
    [-EndTime <DateTime>]
    [-BackupType <BackupSetType>]
    [-IncludeSnapshotBackups]
    [-TimeSpan <TimeSpan>]
    [-IgnoreProviderContext]
    [-SuppressProviderContextWarning]
    [-AccessToken <PSObject>]
    [-TrustServerCertificate]
    [-HostNameInCertificate <String>]
    [-Encrypt <String>]
    [-DatabaseName <System.Collections.Generic.List`1[System.String]>]
    [<CommonParameters>]

Описание

Примеры

Example 1

PS C:\> Get-SqlBackupHistory -ServerInstance test-server -DatabaseName AdventureWorks2014

Name                                     Type               Backup Start Date         Backup Finish Date
----                                     ----               -----------------         ------------------
AdventureWorks2014-Full Database Backup  Database           2/21/2017 7:52:39 PM      2/21/2017 7:52:40 PM
AdventureWorks2014-Full Database Backup  Database           3/20/2017 2:41:39 PM      3/20/2017 2:41:39 PM
AdventureWorks2014-Full-2017-07-24T22:22 Database           7/24/2017 3:23:11 PM      7/24/2017 3:23:11 PM

Параметры

-AccessToken

The access token used to authenticate to SQL Server, as an alternative to user/password or Windows Authentication.

This can be used, for example, to connect to SQL Azure DB and SQL Azure Managed Instance using a Service Principal or a Managed Identity.

The parameter to use can be either a string representing the token or a PSAccessToken object as returned by running Get-AzAccessToken -ResourceUrl https://database.windows.net.

This parameter is new in v22 of the module.

Свойства параметра

Наборы параметров

-BackupType

The type of backup to filter on. If not specified then gets all backup types. Accepted values are defined below.

Свойства параметра

Наборы параметров

-ConnectionTimeout

The time to wait in seconds for a connection to be established and the dynamically generated -DatabaseName parameter to be populated.

Свойства параметра

Наборы параметров

-Credential

The PSCredential object whose username and password fields are used to connect to the SQL instance.

Свойства параметра

Наборы параметров

-DatabaseName

The names of the databases whose backup records are to be retrieved. This is a dynamically populated field and so provides auto-complete suggestions on database names.

Свойства параметра

Наборы параметров

-Encrypt

The encryption type to use when connecting to SQL Server.

This value maps to the Encrypt property SqlConnectionEncryptOption on the SqlConnection object of the Microsoft.Data.SqlClient driver.

In v22 of the module, the default is Optional (for compatibility with v21). In v23+ of the module, the default value will be 'Mandatory', which may create a breaking change for existing scripts.

This parameter is new in v22 of the module.

Свойства параметра

Наборы параметров

-EndTime

The time before which all backup records to be retrieved should have completed.

Свойства параметра

Наборы параметров

-HostNameInCertificate

The host name to be used in validating the SQL Server TLS/SSL certificate. You must pass this parameter if your SQL Server instance is enabled for Force Encryption and you want to connect to an instance using hostname/shortname. If this parameter is omitted then passing the Fully Qualified Domain Name (FQDN) to -ServerInstance is necessary to connect to a SQL Server instance enabled for Force Encryption.

This parameter is new in v22 of the module.

Свойства параметра

Наборы параметров

-IgnoreProviderContext

Indicates that this cmdlet does not use the current context to override the values of the ServerInstance, DatabaseName parameters. If you do not specify this parameter, the cmdlet ignores the values of these parameters, if possible, in favor of the context in which you run the cmdlet.

Свойства параметра

Наборы параметров

-IncludeSnapshotBackups

This switch will make the cmdlet obtain records for snapshot backups as well. By default such backups are not retrieved.

Свойства параметра

Наборы параметров

-InputObject

Specifies SMO Server objects to get the backup records for.

Свойства параметра

Наборы параметров

-Path

Specifies the SQL provider path to either a server instance or a database for this cmdlet to use to obtain BackupSets for. If not specified uses the current working location.

Свойства параметра

Наборы параметров

-ServerInstance

The name of the server instances which this cmdlet will target.

Свойства параметра

Наборы параметров

-Since

Specifies an abbreviation that you can instead of the StartTime parameter.

It can be specified with the EndTime parameter.

You cannot use the StartTime parameter, if you use this parameter.

The acceptable values for this parameter are:

• Midnight (gets all the job history information generated after midnight)
• Yesterday (gets all the job history information generated in the last 24 hours)
• LastWeek (gets all the job history information generated in the last week)
• LastMonth (gets all the job history information generated in the last month)

Свойства параметра

Наборы параметров

-StartTime

Gets the backup records which started after this specified time.

Свойства параметра

Наборы параметров

-SuppressProviderContextWarning

Suppresses the warning when the cmdlet is using the provider context.

Свойства параметра

Наборы параметров

-TimeSpan

If specified, it causes the cmdlet to filter records generated more than 'Timespan' ago.

Свойства параметра

Наборы параметров

-TrustServerCertificate

Indicates whether the channel will be encrypted while bypassing walking the certificate chain to validate trust.

In v22 of the module, the default is $true (for compatibility with v21). In v23+ of the module, the default value will be '$false', which may create a breaking change for existing scripts.

This parameter is new in v22 of the module.

Свойства параметра

Наборы параметров

CommonParameters

Входные данные

System.String

Microsoft.SqlServer.Management.Smo.Server

Выходные данные

System.Object

Связанные ссылки

• Backup-SqlDatabase