Jaa

BackupRestoreBase Members

  • Artikkeli

The BackupRestoreBase class is a base class that represents functionality that is common to both backup and restore operations.

The following tables list the members exposed by the BackupRestoreBase type.

Public Constructors

  Name Description
BackupRestoreBase Initializes a new instance of the BackupRestoreBase class.

Top

Protected Fields

  Name Description
ms219128.protfield(en-US,SQL.90).gif currentAsyncOperation  
ms219128.protfield(en-US,SQL.90).gif m_BackupAction  
ms219128.protfield(en-US,SQL.90).gif m_LogTruncation  
ms219128.protfield(en-US,SQL.90).gif m_RestoreAction  

Top

Public Properties

  Name Description
ms219128.pubproperty(en-US,SQL.90).gif AsyncStatus Gets the asynchronous status of a backup or restore process.
ms219128.pubproperty(en-US,SQL.90).gif Checksum Gets or sets a Boolean property value that determines whether a checksum value is calculated during backup or restore operations.
ms219128.pubproperty(en-US,SQL.90).gif ContinueAfterError Gets or sets a Boolean property value that determines whether the backup or restore continues after a checksum error occurs.
ms219128.pubproperty(en-US,SQL.90).gif Database Gets or sets the database on which the backup or restore operation runs.
ms219128.pubproperty(en-US,SQL.90).gif DatabaseFileGroups Gets the Microsoft SQL Server file groups targeted by the backup or restore operation.
ms219128.pubproperty(en-US,SQL.90).gif DatabaseFiles Gets the operating system files targeted by the backup or restore operation.
ms219128.pubproperty(en-US,SQL.90).gif Devices Gets the backup devices specified for the backup or restore operation. This property is not CLS-compliant.
ms219128.pubproperty(en-US,SQL.90).gif MediaName Gets or sets the name used to identify a particular media set.
ms219128.pubproperty(en-US,SQL.90).gif NoRecovery Gets or sets a Boolean property value that determines whether the tail of the log is backed up and whether the database is restored into the Restoring state.
ms219128.pubproperty(en-US,SQL.90).gif NoRewind Gets or sets a Boolean property value that determines whether Microsoft SQL Server will keep the tape open after the backup or restore operation.
ms219128.pubproperty(en-US,SQL.90).gif PercentCompleteNotification Gets or sets the percentage interval for PercentCompleteEventHandler event handler calls.
ms219128.pubproperty(en-US,SQL.90).gif Restart Gets or sets a Boolean property value that determines whether the backup or restore operation will restart if it is interrupted.
ms219128.pubproperty(en-US,SQL.90).gif UnloadTapeAfter Gets or sets a Boolean property value that determines whether tape media are rewound and unloaded after the backup or restore operation completes.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms219128.pubmethod(en-US,SQL.90).gif Abort Terminates a running backup or restore operation.
ms219128.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms219128.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms219128.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms219128.pubmethod(en-US,SQL.90).gifms219128.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219128.pubmethod(en-US,SQL.90).gif SetMediaPassword Overloaded. Sets the password for a media set.
ms219128.pubmethod(en-US,SQL.90).gif SetPassword Overloaded. Sets the password for a backup set.
ms219128.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )
ms219128.pubmethod(en-US,SQL.90).gif Wait Waits for the current backup or restore operation to complete before moving on to the next process.

Top

Protected Methods

  Name Description
ms219128.protmethod(en-US,SQL.90).gif ExecuteSql Executes a batch of Transact-SQL statements that does not expect a returned results set on the specified instance of Microsoft SQL Server.
ms219128.protmethod(en-US,SQL.90).gif ExecuteSqlAsync Executes a batch of Transact-SQL statements asynchronously that does not expect a returned results set on the specified instance of Microsoft SQL Server.
ms219128.protmethod(en-US,SQL.90).gif ExecuteSqlWithResults Executes a batch of Transact-SQL statements that expects one or more returned results sets on the specified instance of SQL Server.
ms219128.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms219128.protmethod(en-US,SQL.90).gif GetDevicesScript  
ms219128.protmethod(en-US,SQL.90).gif IsStringValid Verifies whether the specified string is valid.
ms219128.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

Public Events

  Name Description
ms219128.pubevent(en-US,SQL.90).gif Complete Occurs when the backup or restore operation completes.
ms219128.pubevent(en-US,SQL.90).gif Information Occurs when any informational message is issued by Microsoft SQL Server that cannot be handled by the CompleteNextMedia or PercentComplete events.
ms219128.pubevent(en-US,SQL.90).gif NextMedia Occurs when the backup or restore operation exhausts the medium in a target device.
ms219128.pubevent(en-US,SQL.90).gif PercentComplete Occurs when a backup or restore operation reaches a completion unit.

Top

See Also

Reference

BackupRestoreBase Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

BACKUP (Transact-SQL)
RESTORE (Transact-SQL)
Backing Up and Restoring Databases in SQL Server