Aracılığıyla paylaş

  • Makale

Restore Members

The Restore object provides programmatic access to restore operations.

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

Public Constructors

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

Top

Public Fields

(see also Protected Fields )

  Name Description
ms220122.pubfield(tr-tr,SQL.100).gif VerifyComplete Specifies the VerifyCompleteEventHandler.

Top

Protected Fields

  Name Description
ms220122.protfield(tr-tr,SQL.100).gif currentAsyncOperation  (inherited from BackupRestoreBase )
ms220122.protfield(tr-tr,SQL.100).gif m_BackupAction  (inherited from BackupRestoreBase )
ms220122.protfield(tr-tr,SQL.100).gif m_LogTruncation  (inherited from BackupRestoreBase )
ms220122.protfield(tr-tr,SQL.100).gif m_RestoreAction  (inherited from BackupRestoreBase )

Top

Public Properties

  Name Description
ms220122.pubproperty(tr-tr,SQL.100).gif Action Gets or sets the type of restore to be performed.
ms220122.pubproperty(tr-tr,SQL.100).gif AsyncStatus  Gets the asynchronous status of a backup or restore process. (inherited from BackupRestoreBase)
ms220122.pubproperty(tr-tr,SQL.100).gif BlockSize  Gets or sets the physical block size of the backup or restore, in bytes. (inherited from BackupRestoreBase)
ms220122.pubproperty(tr-tr,SQL.100).gif BufferCount  Gets or sets the total number of I/O buffers to be used for the backup or restore operation. (inherited from BackupRestoreBase)
ms220122.pubproperty(tr-tr,SQL.100).gif Checksum  Gets or sets a Boolean property value that determines whether a checksum value is calculated during backup or restore operations. (inherited from BackupRestoreBase)
ms220122.pubproperty(tr-tr,SQL.100).gif ClearSuspectPageTableAfterRestore Gets or sets a Boolean value that determines whether entries in the suspect page table will be deleted following the restore operation.
ms220122.pubproperty(tr-tr,SQL.100).gif ContinueAfterError  Gets or sets a Boolean property value that determines whether the backup or restore continues after a checksum error occurs. (inherited from BackupRestoreBase)
ms220122.pubproperty(tr-tr,SQL.100).gif Database  Gets or sets the database on which the backup or restore operation runs. (inherited from BackupRestoreBase)
ms220122.pubproperty(tr-tr,SQL.100).gif DatabaseFileGroups  Gets the SQL Server file groups targeted by the backup or restore operation. (inherited from BackupRestoreBase)
ms220122.pubproperty(tr-tr,SQL.100).gif DatabaseFiles  Gets the operating system files targeted by the backup or restore operation. (inherited from BackupRestoreBase)
ms220122.pubproperty(tr-tr,SQL.100).gif Devices  Gets the backup devices specified for the backup or restore operation. This property is not CLS-compliant. (inherited from BackupRestoreBase)
ms220122.pubproperty(tr-tr,SQL.100).gif FileNumber Gets or sets the index number used to identify the targeted backup set on the backup medium.
ms220122.pubproperty(tr-tr,SQL.100).gif KeepReplication Gets or sets a Boolean property value that specifies whether to maintain a replication configuration during a restore operation.
ms220122.pubproperty(tr-tr,SQL.100).gif MaxTransferSize  Gets or sets the maximum number of bytes to be transferred between the backup media and the instance of SQL Server. (inherited from BackupRestoreBase)
ms220122.pubproperty(tr-tr,SQL.100).gif MediaName  Gets or sets the name used to identify a particular media set. (inherited from BackupRestoreBase)
ms220122.pubproperty(tr-tr,SQL.100).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. (inherited from BackupRestoreBase)
ms220122.pubproperty(tr-tr,SQL.100).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. (inherited from BackupRestoreBase)
ms220122.pubproperty(tr-tr,SQL.100).gif Offset Gets or sets the array of page addresses to be restored.
ms220122.pubproperty(tr-tr,SQL.100).gif Partial Gets or sets a Boolean property value that specifies whether a partial or full restore operation will be performed.
ms220122.pubproperty(tr-tr,SQL.100).gif PercentCompleteNotification  Gets or sets the percentage interval for PercentCompleteEventHandler event handler calls. (inherited from BackupRestoreBase)
ms220122.pubproperty(tr-tr,SQL.100).gif RelocateFiles Gets or sets the array of database logical file names and operating system physical file names used to redirect database storage when a database is restored to a new physical location.
ms220122.pubproperty(tr-tr,SQL.100).gif ReplaceDatabase Gets or sets a Boolean value that specifies whether a restore operation creates a new image of the restored database.
ms220122.pubproperty(tr-tr,SQL.100).gif Restart  Gets or sets a Boolean property value that determines whether the backup or restore operation will restart if it is interrupted. (inherited from BackupRestoreBase)
ms220122.pubproperty(tr-tr,SQL.100).gif RestrictedUser Gets or sets a Boolean property value that specifies whether access to the restored database is restricted to members of the db_owner fixed database role and the dbcreator and sysadmin fixed server roles.
ms220122.pubproperty(tr-tr,SQL.100).gif StandbyFile Gets or sets the name of an undo file that is used as part of the imaging strategy for an instance of SQL Server.
ms220122.pubproperty(tr-tr,SQL.100).gif StopAtMarkAfterDate Gets or sets the date to be used in conjunction with the mark name specified by StopAtMarkName to determine the stopping point of the recovery operation.
ms220122.pubproperty(tr-tr,SQL.100).gif StopAtMarkName Gets or sets the mark name to be used in conjunction with the date specified by StopAtMarkAfterDate to determine the stopping point of the recovery operation.
ms220122.pubproperty(tr-tr,SQL.100).gif StopBeforeMarkAfterDate Gets or sets the date to be used in conjunction with the mark name specified by StopBeforeMarkName to determine the stopping point of the recovery operation.
ms220122.pubproperty(tr-tr,SQL.100).gif StopBeforeMarkName Gets or sets the mark name to be used in conjunction with the date specified by StopBeforeMarkAfterDate to determine the stopping point of the recovery operation.
ms220122.pubproperty(tr-tr,SQL.100).gif ToPointInTime Gets or sets the endpoint for database log restoration.
ms220122.pubproperty(tr-tr,SQL.100).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. (inherited from BackupRestoreBase)

Top

Public Methods

(see also Protected Methods )

  Name Description
ms220122.pubmethod(tr-tr,SQL.100).gif Abort  Terminates a running backup or restore operation. (inherited from BackupRestoreBase)
ms220122.pubmethod(tr-tr,SQL.100).gif ClearSuspectPageTable Deletes entries in the suspect page table.
ms220122.pubmethod(tr-tr,SQL.100).gif Equals  Overloaded. (inherited from Object )
ms220122.pubmethod(tr-tr,SQL.100).gif GetHashCode  (inherited from Object )
ms220122.pubmethod(tr-tr,SQL.100).gif GetType  (inherited from Object )
ms220122.pubmethod(tr-tr,SQL.100).gif ReadBackupHeader Reads the backup header and returns information about the media contents.
ms220122.pubmethod(tr-tr,SQL.100).gif ReadFileList Returns the list of database files on the targeted media.
ms220122.pubmethod(tr-tr,SQL.100).gif ReadMediaHeader Reads the media header and returns the media header values.
ms220122.pubmethod(tr-tr,SQL.100).gif ReadSuspectPageTable Returns the suspect page table for the targeted instance of SQL Server.
ms220122.pubmethod(tr-tr,SQL.100).gifms220122.static(tr-tr,SQL.100).gif ReferenceEquals  (inherited from Object )
ms220122.pubmethod(tr-tr,SQL.100).gif Script Generates a Transact-SQL script that can be used to re-create the restore operation.
ms220122.pubmethod(tr-tr,SQL.100).gif SetMediaPassword  Overloaded. (inherited from BackupRestoreBase )
ms220122.pubmethod(tr-tr,SQL.100).gif SetPassword  Overloaded. (inherited from BackupRestoreBase )
ms220122.pubmethod(tr-tr,SQL.100).gif SqlRestore Performs a restore operation.
ms220122.pubmethod(tr-tr,SQL.100).gif SqlRestoreAsync Performs a restore operation asynchronously.
ms220122.pubmethod(tr-tr,SQL.100).gif SqlVerify Overloaded. Checks the media on the instance of SQL Server that is represented by the specified Server object.
ms220122.pubmethod(tr-tr,SQL.100).gif SqlVerifyAsync Overloaded. Checks the media on the instance of SQL Server that is represented by the specified Server object asynchronously.
ms220122.pubmethod(tr-tr,SQL.100).gif SqlVerifyLatest Overloaded. Verifies the most recent backup but does not restore it, and checks to see that the backup set is complete and the entire backup is readable.
ms220122.pubmethod(tr-tr,SQL.100).gif ToString  (inherited from Object )
ms220122.pubmethod(tr-tr,SQL.100).gif Wait  Waits for the current backup or restore operation to complete before moving on to the next process. (inherited from BackupRestoreBase)

Top

Protected Methods

  Name Description
ms220122.protmethod(tr-tr,SQL.100).gif ExecuteSql  (inherited from BackupRestoreBase )
ms220122.protmethod(tr-tr,SQL.100).gif ExecuteSqlAsync  (inherited from BackupRestoreBase )
ms220122.protmethod(tr-tr,SQL.100).gif ExecuteSqlWithResults  (inherited from BackupRestoreBase )
ms220122.protmethod(tr-tr,SQL.100).gif Finalize  (inherited from Object )
ms220122.protmethod(tr-tr,SQL.100).gif GetDevicesScript  (inherited from BackupRestoreBase )
ms220122.protmethod(tr-tr,SQL.100).gif IsStringValid  (inherited from BackupRestoreBase )
ms220122.protmethod(tr-tr,SQL.100).gif MemberwiseClone  (inherited from Object )

Top

Public Events

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

Top