DatabaseRestorePlanner Class

Definition

Namespace:

Microsoft.SqlServer.Management.Smo

Assembly:

Microsoft.SqlServer.SmoExtended.dll

Package:

Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Database Restore Planner.

public sealed class DatabaseRestorePlanner

type DatabaseRestorePlanner = class

Public NotInheritable Class DatabaseRestorePlanner

Inheritance

Object

DatabaseRestorePlanner

Constructors

DatabaseRestorePlanner(Server)	Initializes a new instance of the DatabaseRestorePlanner class.
DatabaseRestorePlanner(Server, String)	Initializes a new instance of the DatabaseRestorePlanner class.
DatabaseRestorePlanner(Server, String, DateTime, String)	Initializes a new instance of the DatabaseRestorePlanner class. For point in time recovery.

Fields

IncludeSnapshotBackups

Whether to include snapshot backups in the enumeration. Must be set before retrieving BackupSets property.

Properties

BackupMediaList	Gets the backup device item list.
BackupSets	Gets the backup sets.
BackupTailLog	Gets or sets a value indicating whether to [backup tail log].
DatabaseName	Gets or sets the name of the database.
ReadHeaderFromMedia	Gets or sets a value indicating whether [read header from devices].
RestoreToLastBackup	Gets or sets a value indicating whether [restore to last backup].
RestoreToPointInTime	Gets or sets the restore to point in time.
Server	Gets or sets the server.
TailLogBackupFile	Gets or sets the tail log backup file.
TailLogWithNoRecovery	Gets or sets a value indicating whether to backup tail log with NoRecovery.

Methods

CreateRestorePlan()	Creates the restore plan.
CreateRestorePlan(RestoreOptions)	Creates the restore plan.
GetBackupDeviceReadErrors()	Gets the error that occurred while reading the bachup devices
IsTailLogBackupPossible(String)	Determines whether it's possible to do a tail-log backup before restoring the database.
IsTailLogBackupWithNoRecoveryPossible(String)	Determines whether it's possible to do a tail-log backup with NORECOVERY before restoring the database.
RefreshBackupSets()	Refreshes the backup sets.
TailLogStartTime()	Gives the Tail-log start time coverage.

Events

CreateRestorePlanUpdates

Create restore plan status update event handler