FILE: C:\Program Files\Microsoft SQL Server\120\SDK\Assemblies\en\Microsoft.SqlServer.SmoExtended.xml
--
Microsoft.SqlServer.SmoExtended
The object represents the status of an asynchronous process.
Gets the execution status of the asynchronous process.
An object value that specifies the execution status of the asynchronous process.
Gets the most recent exception generated by the asynchronous process.
An system object that specifies the most recent exception generated by the asynchronous process.
The object provides programmatic access to Microsoft SQL Server backup operations.
Initializes a new instance of the class.
Gets or sets the type of backup to be performed.
A object representing the type of backup to be performed. By default the value is set to .
Gets or sets a textual description for a particular backup set.
A value that contains a textual description of the backup set. By default, the value is an empty string.
Gets or sets the name used to identify a particular backup set.
A value that specifies the backup set name. By default, the value is set to an empty string.
Gets or sets the backup compression option.
The backup compression option.
Gets or sets a property value that specifies the backup is a copy-only backup. This does not affect the sequence of backups in the usual backup schedule.
A value that specifies whether the backup is a copy-only backup.If True, the backup is a copy-only backup.If False (default), the backup is not a copy-only backup, and is part of the usual sequence of backups.
Gets or sets the date and time when the backup set expires and the backup data is no longer considered relevant.
A object value that specifies the expiration date. By default, the value is unspecified.
Gets or sets a property value that determines whether a tape is formatted as the first step of the backup operation.
A value that specifies whether the tape will be formatted.If True, the Microsoft SQL Server backup operation attempts to format the tape as the initial step.If False (default), the SQL Server backup operation does not attempt to format the tape.
Gets or sets a property value that determines whether to perform a differential backup.
A value that specifies whether a differential backup will be performed.If True, only changes since the most recent full or differential backup will be included in the backup operation.If False (default), a full backup will be performed.
Gets or sets a property value that determines whether the devices associated with a backup operation are initialized as part of the backup operation.
A value that specifies whether the backup devices will be initialized.If True, the backup specified becomes the first backup set on the media, overwriting any existing backup sets on the media. The backup media is not overwritten if either of the following conditions is met: All backup sets on the media have not yet expired. The optionally specified backup set name does not match the name on the backup media. Specify the backup set name with the property. If False (default), the backup specified creates a new backup set appended as the last backup set on the medium.
Gets or sets the method used to truncate the database log as part of the backup operation.
A object value that specifies the log truncation option that has been selected. By default, the value is set to .
Gets or sets a textual description of the medium that contains a backup set.
A value that contains a textual description of the medium.
Gets or sets the list of backup devices used by the mirrored backup.
An array of BackupDeviceList objects that specifies the backup devices used by the mirrored backup.
Gets or sets the number of days that must elapse before a backup set can be overwritten.
An value that specifies the retention period in days. By default, the value is set to zero.
Returns a containing the Transact-SQL statement that can be used to execute the referenced backup.
A containing theTransact-SQL statement that can be used to execute the referenced backup.
The object that represents the Microsoft SQL Server instance that is the source of the backup operation.
Gets or sets property that determines whether the tape header is read.
A value that specifies whether the tape header is read.If True, a media name recorded on the medium is not selected. The backup set is appended to the medium.If False (default), a recorded media name is selected.
Performs the database backup operation as specified by the properties of the object used.
The object that represents the Microsoft SQL Server instance that is the source of the backup operation.
Performs the database backup operation asynchronously as specified by the properties of the object used.
The object that represents the Microsoft SQL Server instance that is the source of the backup operation.
Gets or sets the name of the undo file used to store uncommitted transactions that are rolled back during recovery.
A value that specifies the undo file name.
The enumeration contains values that are used to specify the type of backup.
Backs up all the data files in the database.
Backs up specified data files. This option is recommended only when the transactions that have occurred since the last backup are isolated to the file or group of files that are being backed up.
Backs up the transaction log.
The BackupCompressionOptions enumeration contains values that are used to specify the backup compression option.
Value = 0. Use the default backup compression server configuration.
Value = 2. Disable the backup compression.
Value = 1. Enable the backup compression.
The object provides programmatic access to named SQL Server backup devices.
Initializes a new instance of the class.
Initializes a new instance of the class that has the specified name and kind of device.
A value that specifies the name of the backup device item.
A object value that specifies the kind of backup device.
Verifies whether the specified object shares the same name as the referenced object.
An value that specifies the lexical relationship between the two strings.ValueDescriptionThe referenced object name is less than the object name that is specified by the parameter.The referenced object name is equal to the object name that is specified by the parameter.The referenced object name is greater than the object name that is specified by the parameter.
A object value that specifies the object that is compared with the referenced object.
Gets the kind of device for the object.
A object value that specifies the kind of backup device.
Determines whether the current object is the same as the specified object.
A that is true if the objects are the same. Otherwise, false.
A that specifies the object to compate with the current backup device item.
Gets the hash code for the object.
A value that specifies the hash code.
Gets the name of device for the object.
A object value that specifies the name of backup device.
Determines whether two objects are equal by performing an equality operation on two objects.
A value that specifies the outcome of the equality operation.If True, the two objects are equal. Otherwise, False.
A object that is used in the equality operation.
A object that is used in the equality operation.
Determines whether one object is greater than another by performing an operation on two objects.
A value that specifies the outcome of the operation to determine whether one object is greater than the other.If True, the first object is greater than the second. Otherwise, False.
The first object that is used in the operation.
The second object that is used in the greater than operation.
Determines whether two objects are unequal by performing an inequality operation on two objects.
A value that specifies the outcome of the inequality operation.If True, the two objects are unequal. Otherwise, False.
A object that is used in the inequality operation.
A object that is used in the inequality operation.
Determines whether one object is less than another by performing an operation on two objects.
A value that specifies the outcome of the operation to determine whether one object is less than the other.If True, the first object is less than the second. Otherwise, False.
The first object that is used in the operation.
The second object that is used in the greater than operation.
The object provides programmatic access to a list backup devices.
Initializes a new instance of the class.
Initializes a new instance of the class based on the specified object.
object value that specifies the backup devices.
Initializes a new instance of the class with the specified capacity.
An value that specifies the capacity of the object.
Adds device type with the specified name to the list.
value that is used to specify the name of the device that is being added to the object.
object value that specifies the type of device to add to the object.
The class is a base class that represents functionality that is common to both backup and restore operations.
Initializes a new instance of the class.
Terminates a running backup or restore operation.
Gets the asynchronous status of a backup or restore process.
An object value that specifies the asynchronous status of the process.
Gets or sets the physical block size of the backup or restore, in bytes.
An value that specifies the block size in bytes.
Gets or sets the total number of I/O buffers to be used for the backup or restore operation.
An value that specifies the total number of I/O buffers to be used for the backup operation.
Gets or sets a property value that determines whether a checksum value is calculated during backup or restore operations.
A value that specifies whether the checksum value is calculated.If True, the checksum value is calculated. Otherwise, False (default).
Occurs when the backup or restore operation completes.
Gets or sets a property value that determines whether the backup or restore continues after a checksum error occurs.
A value that specifies whether the operation will continue after a checksum error.If True, the operation will continue when a checksum error occurs. Otherwise, False (default).
Gets or sets the Credential property value, which is used to authenticate to the Windows Azure storage account.
The credential name.
Specifies the current asynchronous operation, such as backup, restore, or none.
Gets or sets the database on which the backup or restore operation runs.
A value that contains the database name. By default, the value is an empty string.
Gets the SQL Server file groups targeted by the backup or restore operation.
A system object value that lists the names of the targeted file groups. By default, the value is unspecified.
Gets the operating system files targeted by the backup or restore operation.
A system object value that lists the names of the targeted files. By default, the value is unspecified.
Gets the backup devices specified for the backup or restore operation.
A object array value that lists the names of the required backup devices. By default, the value is unspecified.
Executes a batch of Transact-SQL statements that does not expect a returned results set on the specified instance of SQL Server.
A object that specifies the instance of SQL Server on which to execute the batch of Transact-SQL statements.
A system object that contains the batch of Transact-SQL statements to be executed.
Executes a batch of Transact-SQL statements asynchronously that does not expect a returned results set on the specified instance of SQL Server.
A object that specifies the instance of SQL Server on which to execute the batch of Transact-SQL statements.
A system object that contains the batch of Transact-SQL statements to be executed.
Executes a batch of Transact-SQL statements that expects one or more returned results sets on the specified instance of SQL Server.
A system object that contains the results sets returned by the executed Transact-SQL command batch.
A object that specifies the instance of SQL Server on which to execute the batch of Transact-SQL statements.
A system object that contains the batch of Transact-SQL statements to be executed.
Gets the script that is used to create devices.
A value that specifies the Transact-SQL query.
A object value that specifies the devices associated with the backup or restore operation.
A object that specifies the version of the instance of SQL Server on which the devices are to be re-created.
Occurs when any informational message is issued by Microsoft SQL Server that cannot be handled by the or events.
Verifies whether the specified string is valid.
A that indicates whether the string is valid.
A value that specifies the string to be validated.
Specifies the backup action type, such as database or log.
Specifies whether to truncate the log.
Specifies the restore action type, such as database or log.
Gets or sets the maximum number of bytes to be transferred between the backup media and the instance of SQL Server.
An value that specifies the maximum number of bytes to be transferred in the backup and restore operation.
Gets or sets the name used to identify a particular media set.
A system value that specifies the media name. By default, the value is an empty string.
Occurs when the backup or restore operation exhausts the medium in a target device.
Gets or sets a property value that determines whether the tail of the log is backed up and whether the database is restored into the Restoring state.
A value that specifies whether the tape is rewound at the end of the operation.If True, the tail end of the log is not backed up. When restored, the database is in the Restoring state.If False (default), the tail end of the log is backed up.
Gets or sets a property value that determines whether Microsoft SQL Server will keep the tape open after the backup or restore operation.
A value that specifies whether the tape is rewound at the end of the operation or not.If True, the tape drive is open and positioned.If False (default), the tape is rewound
Occurs when a backup or restore operation reaches a completion unit.
Gets or sets the percentage interval for event handler calls.
An that specifies the percentage interval for the event handler calls. The default value is 10.
Gets or sets a property value that determines whether the backup or restore operation will restart if it is interrupted.
A value that specifies whether the operation will restart after an interruption. If True, SQL Server tries to continue processing on a partial backup or restore operation.If False (default), SQL Server restarts an interrupted backup or restore operation at the beginning of the backup set.
Sets the password for a media set.
A value that specifies the password for the media set.
Sets the password for a media set.
A value that specifies the password for the media set.
Sets the password for a backup set.
A value that specifies the password for the backup set.
Sets the password for a backup set.
A value that specifies the password for the backup set.
Gets or sets a property value that determines whether tape media are rewound and unloaded after the backup or restore operation completes.
A value that specifies whether tape media are rewound and unloaded after the backup or restore operation completes. If True, the tape medium in the tape device is rewound and unloaded when the operation completes.If False (default), no attempt is made to rewind and unload the tape medium.
Waits for the current backup or restore operation to complete before moving on to the next process.
The enumeration contains values that are used to specify which backup components are running asynchronously.
The backup process is the asynchronous operation.
There is no asynchronous operation.
The restore process is the asynchronous operation.
The enumeration contains values that are used to specify the truncate action taken on the log.
The log is not truncated. All transactions remain in the log.
The log is truncated. All completed transactions will be removed from the log.
Truncates the log without performing a backup.
Specifies the state of the database restore operation.
Instructs the restore operation to not rollback any uncommitted transactions for another transaction log backup to be restored later. The database remains in the restoring state after the restore operation.
Leaves the database ready to use by rolling back uncommitted transactions. Additional transaction logs cannot be restored.
Rollbacks uncommitted transactions, but saves the rollback actions in a standby file that allows the recovery effects to be reversed.
Represents the Database Restore Planner.
Initializes a new instance of the class with specified server.
The server.
Initializes a new instance of the class with specified server and database name.
The server
The name of the database.
Initializes a new instance of the class with specified server, database name, point in time and recovery file.
The server.
Name of the database.
The point in time to restore.
The tail log backup device item.
Gets the backup device item list.
The collection of backup device item list.
Gets or sets a value indicating whether to backup tail log.
True if backup tail log; otherwise, false.
Creates the restore plan.
The created restore plan.
Creates the restore plan with restore options.
The restore plan.
The restore options.
Gets or sets the database name.
The name of the database.
Gets or sets a value indicating whether read header from devices.
True if read header from media; otherwise, false.
Gets or sets a value indicating whether restore to last backup.
True if restore to last backup; otherwise, false.
Gets or sets the restore to point in time.
The restore to point in time.
Gets or sets the server.
The server.
Gets or sets the tail log backup file.
The new tail log backup file.
Gets or sets whether the database restore planner tails log without using recovery.
True if the database restore planner tails log without using recovery; otherwise, false.
Represents the data transfer base.
Initializes a new instance of the class using default values.
Initializes a new instance of the class with specified database.
The database.
Exception thrown on trying to execute or verify an invalid Restore plan.
Represents the next restore event arguments.
Initializes a new instance of the class.
Name of the backup set.
The backup set description.
Name of the device.
The count.
Gets or sets the backup set description.
The backup set description.
Gets or sets the name of the backup set.
The name of the backup set.
Gets or sets a value indicating whether to continue next Restore Operation.
True if continue; otherwise, false.
Gets or sets the count of the next restore event.
The count of the next restore event.
Gets or sets the name of the backup media.
The name of the backup media.
Handles the NextRestoreEvent class.
Represents the page restore planner.
Initializes a new instance of the class with specified database.
The database.
Initializes a new instance of the class with specified database and tail log backup file.
The database.
Name of the tail log backup file.
Creates the restore plan.
The created restore plan.
Gets or sets the database.
The database.
Gets or sets the suspect pages.
The suspect page.
Gets or sets the tail log backup file.
The tail log backup file.
Represents the arguments passed by the event raised when a process reaches a percent complete marker.
Gets the message for the .
The message for the .
Gets the percentage value amount that when used in integer multiples, and marks the point at which to report progress.
The percentage value.
The class represents the event handler that is used to handle percent complete events.
An value that specifies the source of the event.
A http://msdn.microsoft.com/library/en-us/cpref/html/frlrfsystemeventargsclasstopic.asp EventArgs object that contains the event data.
The object is a programmatic tool that lets a file be relocated.
Initializes a new instance of the class.
Initializes a new instance of the class.
A value that specifies the logical file name.
A value that specifies the physical file name.
Gets or sets the logical file name for the specified file.
A value that specifies the logical file name for the specified file.
Gets or sets the physical file name for the specified file.
A value that specifies the physical file name for the specified file.
The object provides programmatic access to restore operations.
Initializes a new instance of the class.
Initializes a new instance of the class with specified destination database name and backup set.
The name of the database to be restored.
The backup set.
Gets or sets the type of restore to be performed.
A object representing the type of restore to be performed.
Deletes entries in the suspect page table.
The instance of SQL Server that is targeted by the restore operation.
Gets or sets a value that determines whether entries in the suspect page table will be deleted following the restore operation.
A value that indicates whether the suspect page table will be cleared.If True, the suspect page table is cleared following the restore operation. Otherwise, False (default).
Gets the list of the restore pages.
The list of the restore pages.
Gets or sets the index number used to identify the targeted backup set on the backup medium.
An value that specifies the backup set index number.
Gets or sets a property value that specifies whether to maintain a replication configuration during a restore operation.
A value that indicates whether to keep the replication configuration.If True, the replication configuration is kept in place.If False (default), the replication configuration is ignored by the restore operation.
Gets or sets the array of page addresses to be restored.
An array value that specifies the page addresses of the pages to be restored.
Gets or sets a property value that specifies whether a partial or full restore operation will be performed.
A value that indicates whether this is a full or partial restore operation.If True, the restore operation is a partial restore. Otherwise, False (default).
Reads the backup header and returns information about the media contents.
A object that specifies information about the media contents.
A object that represents the instance of SQL Server that provides access to the targeted media.
Returns the list of database files on the targeted media.
A object that specifies the list of database files.
A object that represents the instance of SQL Server that provides access to the targeted media.
Reads the media header and returns the media header values.
A object that specifies the media header data.
A object that represents the instance of SQL Server that provides access to the targeted media.
Returns the suspect page table for the targeted instance of SQL Server.
A object that specifies the suspect page table data.
A object that represents the instance of SQL Server that is targeted by the restore operation.
Gets 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.
An object that specifies the file names.
Gets or sets a value that specifies whether a restore operation creates a new image of the restored database.
A value that specifies whether a new image of the restored database will be created.If True, a new image of the database is created. The image is created regardless of the presence of an existing database with the same name.If False (default), a new image of the database is not created by the restore operation. The database that is targeted by the restore operation must exist on an instance of SQL Server.
Gets or sets a 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.
A value that specifies whether access to the restored database will be restricted.If True, access to the restored database is restricted to the db_owner fixed database role, and the dbcreator and sysadmin fixed server roles. Otherwise, False (default).
Generates a Transact-SQL script that can be used to re-create the restore operation.
A system object value that contains a list of Transact-SQL statements in the script.
A object that represents the instance of SQL Server that is targeted by the restore operation.
Performs a restore operation on the specified server.
A object that represents the instance of SQL Server that is targeted by the restore operation.
Performs a restore operation asynchronously.
A object that represents the instance of SQL Server that is targeted by the restore operation.
Checks the media on the instance of SQL Server that is represented by the specified object.
A value that indicates whether targeted backup set is readable and complete.If True, the backup set was verified successfully. Otherwise, False.
A object that represents the instance of SQL Server that is targeted by the restore operation.
Checks the media on instance of SQL Server that is represented by the specified object and loads backup history information into the history tables.
A value that indicates whether targeted backup set is readable and complete.If True, the backup set was successfully verified. Otherwise, False.
A object that represents the instance of SQL Server that is targeted by the restore operation.
A value that specifies whether the history tables will be populated with pertinent backup information.If True, the history tables are populated. Otherwise, False.
Checks the media on the instance of SQL Server that is represented by the specified object, loads backup history information into the history tables, and returns an error message.
A value that indicates whether targeted backup set is readable and complete.If True, the backup set was successfully verified. Otherwise, False.
A object that represents the instance of SQL Server that is targeted by the restore operation.
A value that specifies whether the history tables will be populated with pertinent backup information. If True, the history tables are populated. Otherwise, False.
A value that contains the error message when the method has completed running. This is an output parameter.
Checks the media on the instance of SQL Server that is represented by the specified object and returns an error message.
A value that indicates whether targeted backup set is readable and complete.If True, the backup set was successfully verified. Otherwise, False.
A object that represents the instance of SQL Server that is targeted by the restore operation.
A value that contains the error message when the method has completed running. This is an output parameter.
Checks the media on the instance of SQL Server that is represented by the specified object asynchronously.
A object that represents the instance of SQL Server that is targeted by the restore operation.
Checks the media on the instance of SQL Server that is represented by the specified object asynchronously and loads backup history information into the history tables.
A object that represents the instance of SQL Server that is targeted by the restore operation.
A value that specifies whether the history tables will be populated with pertinent backup information.If True, the history tables are populated. Otherwise, False.
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.
A value that indicates whether the targeted backup set is readable and complete.If True, the backup set was verified successfully. Otherwise, False.
A object that represents the instance of SQL Server that is targeted by the restore operation.
Verifies the most recent backup with the specified action, and checks to see that the backup set is complete and the entire backup is readable.
A value that indicates whether targeted backup set is readable and complete.If True, the backup set was successfully verified. Otherwise, False.
A object that represents the instance of SQL Server that is targeted by the restore operation.
A value that specifies the type of backup to verify.
Verifies the most recent backup with the specified action, checks to see that the backup set is complete and the entire backup is readable, and returns an error message.
A value that indicates whether targeted backup set is readable and complete.If True, the backup set was successfully verified. Otherwise, False.
A object that represents the instance of SQL Server that is targeted by the restore operation.
A value that specifies the type of backup to verify.
A value that contains the error message when the method has completed running. This is an output parameter.
Verifies the most recent backup but does not restore it, checks to see that the backup set is complete and the entire backup is readable, and returns an error message.
A value that indicates whether targeted backup set is readable and complete.If True, the backup set was successfully verified. Otherwise, False.
A object that represents the instance of SQL Server that is targeted by the restore operation.
A value that contains the error message when the method has completed running. This is an output parameter.
Gets or sets the name of an undo file that is used as part of the imaging strategy for an instance of SQL Server.
A that specifies the name of the undo file.
Gets or sets the date to be used in conjunction with the mark name specified by to determine the stopping point of the recovery operation.
A that specifies the stop at date.
Gets or sets the mark name to be used in conjunction with the date specified by to determine the stopping point of the recovery operation.
A that specifies the mark name.
Gets or sets the date to be used in conjunction with the mark name specified by to determine the stopping point of the recovery operation.
A that specifies the stop before date.
Gets or sets the mark name to be used in conjunction with the date specified by to determine the stopping point of the recovery operation.
A string that specifies the mark name.
Gets or sets the endpoint for database log restoration.
A string that specifies the date and time values that identify the endpoint.
Specifies the .
The enumeration contains values that are used to specify the type of action that is required during a data restore operation.
Restore the database.
Restore one or more data files.
Restore the transaction log.
Restore one or more data files while the database is still available to other users.
Restore a data page online while the database is still available to other users.
Represents the restore options.
Initializes a new instance of the class.
Specifies the physical block size, in bytes.
the physical block size, in bytes.
Specifies the total number of I/O buffers to be used for the restore operation.
The total number of I/O buffers to be used for the restore operation.
Gets or sets whether to delete entries in the suspect page table after restore.
True if delete entries in the suspect page table after restore; otherwise, false.
Gets or sets whether the restore operation is to continue after an error is encountered.
True if the restore operation is to continue after an error is encountered; otherwise, false.
Gets or sets whether to prevent replication settings from being removed when a database backup or log backup is restored on a warm standby server and the database is recovered.
True when prevent replication settings from being removed; otherwise, false.
Gets or sets the largest unit of transfer in bytes to be used between the backup media and SQL Server.
The size of the max transfer.
Gets or sets the percentage interval for PercentCompleteEventHandler event handler calls for individual Restore Operations.
The percent complete notification.
Gets or sets the recovery state.
The database restore option.
Gets or sets SQL Server should create the specified database and its related files even if another database already exists with the same name
True if the SQL Server should create the specified database; otherwise, false.
Gets or sets whether to restrict access for the newly restored database to members of the db_owner, dbcreator, or sysadmin roles.
True if restrict access for the newly restored database to members of the db_owner, dbcreator, or sysadmin roles; otherwise, false.
Undo uncommitted transactions, but save the undo actions in a standby file that allows the recovery effects to be reversed.
The recovery with stand by file.
Represents a sequence of Database Restore operations which will recover a database to a particular state in a point in time.
Initializes a new instance of the class with specified database.
The database.
Initializes a new instance of the class with specified server.
The server.
Initializes a new instance of the class with specified server and database name.
The server.
The name of the database.
Adds the restore operation with specified backup set to be restored.
The backup set to be restored
Adds the restore operations with specified backup sets..
The backup sets.
Gets the status of most recent asynchronous operation including possible errors.
The async status.
Gets or sets a value indicating whether to close existing connections.
True if close existing connections; otherwise, false.
Occurs when the restore plan is completed.
Gets or sets the name of the database.
The name of the database.
Verifies and executes the Restore Plan.
Verifies and executes the Restore Plan async.
Occurs when the server sends information.
Occurs when the next media needs to be loaded.
Occurs when the next restore occurs.
Occurs when the server sends percent complete information.
Gets and sets the type of the Restore action: Database,File,Log,Page.
The restore action.
Gets or sets the restore operations.
The restore operations.
Verifies the Restore plan and scripts the operation.
The string collection of the T-SQL script for the operation.
Gets or sets the erver where the Restore plan executes.
The server.
Sets the restore options.
The restore options
Gets or sets the tail log backup operation.
The tail log backup operation.
Verifies the restore plan.
True if check backup media integrity; otherwise, false.
Represents registered instances of SQL Server.
Represents registered instances of SQL Server.
Returns an array of servers.
An array of objects.
Refreshes registered server collection.
Gets a collection of registered servers.
The collection of registered servers.
Gets a group of registered servers.
A group of registered servers.
The enumeration contains values that are used to specify the type of backup verification.
Value = 0. Verifies the latest database backup.
Value = 2. Verifies the latest file or filegroup backup.
Value = 3. Verifies the latest incremental backup.
Value = 1. Verifies the latest log backup.
Represents the database page used for Page Restore.
Initializes a new instance of the class with the specified file identifier and page identifier.
The file identifier.
The page identifier.
Compares to other SuspectPage.
The value of the object specified by the CompareTo method.
The other SuspectPage.
Determines whether the specified object is equal to the instance.
True if the specified object is equal to the instance; otherwise, false.
The object to compare with the instance.
Gets or sets the file identifier.
The file identifier.
Returns a hash code for the instance.
A hash code for the instance, suitable for use in hashing algorithms and data structures like a hash table.
Gets or sets the page identifier.
The page identifier.
Returns a string that represents the instance.
A string that represents the instance.
The object is a tool object that provides programmatic control over copying of schemas and data to other instances of SQL Server.
Initializes a new instance of the class.
Initializes a new instance of the class that uses the specified database as the source of the transfer operation.
A object that specifies the database that is the source of the transfer operation.
Gets or sets the batch size property.
The batch size property.
Gets or sets the operation to complete before it times out.
The operation to complete before it times out.
Reports that data has been transferred.
For internal use only. Throws a System.NotSupportedException if invoked by a caller.
An object that specifies the data transfer provider interface.
The ITransferMetadataProvider class represents an interface that implements the transfer metadata process on the referenced connection.
representing a collection of key/value pairs that are sorted by the keys and are accessible by key and by index
Saves metadata when transferring databases across instances.
Returns a URN array with options.
A URN array.
The server
The dependency chain.
True if data only; otherwise, false.
True if create order; false.
For internal use only. The value of this property is ignored if set by a caller.
A value that specifies the file location for storage of temporary packages created during the transfer operation.
Transfers data as specified by the object.
Represents the base class for transfer.
Initializes a new instance of the class.
Initializes a new instance of the class that uses the specified database as the source of the transfer operation.
The database that is the source of the transfer operation.
Gets or sets a value that indicates whether all the SQL Server database triggers are copied from the source database to the target database in the transfer operation.
true if all SQL Server database triggers are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server defaults are copied from the source database to the target database in the transfer operation.
true if all SQL Server defaults are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server full-text catalogs are copied from the source database to the target database in the transfer operation.
true if all the SQL Server full-text catalogs are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server full-text stop lists are copied from the source database to the target database in the transfer operation.
true if all SQL Server partition functions are copied from the full-text stop lists to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server logins are copied from the source database to the target database in the transfer operation.
true if all SQL Server logins are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server objects are copied from the source database to the target database in the transfer operation.
true if all SQL Server objects are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server partition functions are copied from the source database to the target database in the transfer operation.
true if all SQL Server partition functions are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server partition schemes are copied from the source database to the target database in the transfer operation.
true if all SQL Server partition schemes are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server plan guides are copied from the source database to the target database in the transfer operation.
true if all SQL Server plan guides are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server roles are copied from the source database to the target database in the transfer operation.
true if all SQL Server roles are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server rules are copied from the source database to the target database in the transfer operation.
true if all SQL Server rules are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server schemas are copied from the source database to the target database in the transfer operation.
true if all SQL Server schemas are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server search property lists are copied from the source database to the target database in the transfer operation.
true if all SQL Server search property lists are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server sequences are copied from the source database to the target database in the transfer operation.
true if all SQL Server sequences are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server assemblies are copied from the source database to the target database in the transfer operation.
true if all SQL Server assemblies are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server stored procedures are copied from the source database to the target database in the transfer operation.
true if all SQL Server stored procedures are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server synonyms are copied from the source database to the target database in the transfer operation.
true if all SQL Server synonyms are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server tables are copied from the source database to the target database in the transfer operation.
true if all SQL Server tables are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server user-defined aggregates are copied from the source database to the target database in the transfer operation.
true if all SQL Server user-defined aggregates are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server user-defined data types are copied from the source database to the target database in the transfer operation.
true if all the SQL Server user-defined data types are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server user-defined functions are copied from the source database to the target database in the transfer operation.
true if all SQL Server user-defined functions are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server user-defined table types are copied from the source database to the target database in the transfer operation.
true if all SQL Server user-defined table types are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server user-defined types are copied from the source database to the target database in the transfer operation.
true if all the SQL Server user-defined types are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server database users are copied from the source database to the target database in the transfer operation.
true if all SQL Server database users are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server views are copied from the source database to the target database in the transfer operation.
true if all SQL Server views are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether all the SQL Server XML schema collections are copied from the source database to the target database in the transfer operation.
true if all the SQL Server XML schema collections are copied from the source database to the target database; otherwise, false.
Gets or sets a value that indicates whether all the data is copied from the source database to the target database in the transfer operation.
true if all the data is copied from the source database to the target database in the transfer operation; otherwise, false. The default is false.
Gets or sets a value that indicates whether the schema is copied from the source database to the target database in the transfer operation.
true if the schema is copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether the target database is created in the transfer operation.
true if the target database is created in the transfer operation; otherwise, false. The default is false.
Gets or sets the database from which schema or data is to be transferred to the target location.
The database from which schema or data is to be transferred to the target location.
Gets or sets the properties that are associated with flat file destination based on a dictionary.
The properties that are associated with flat file destination based on a dictionary.
Gets or sets the database that is the destination of the transfer operation.
The database that is the destination of the transfer operation.
Gets or sets the logon for the instance of SQL Server to which the destination database belongs.
The logon for the instance of SQL Server to which the destination database belongs.
Gets or sets a value that indicates whether the instance of SQL Server that contains the destination database is enabled for Windows Authentication or not.
true if the destination instance of SQL Server requires Windows Authentication; false if the destination instance of SQL Server requires SQL Server Authentication. The default is false.
Gets or sets the logon password for the instance of SQL Server to which the destination database belongs.
The logon password for the instance of SQL Server to which the destination database belongs.
Gets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation.
The instance of SQL Server that owns the database that is the destination of the transfer operation.
Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the destination database.
true if the transfer operation translates the code page for characters on the destination database; otherwise, false. The default is false.
Marks the progress of the discovery process.
Gets or sets a value that indicates whether to drop the objects in the destination database before the transfer operation.
true if the objects in the destination database are dropped before the transfer operation; otherwise, false. The default is false.
Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation.
The URN values that represent the objects included in the transfer operation.
Creates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance.
An IEnumerable string list interface that contains the script.
Gets or sets the objects copied from the source to destination in the transfer operation.
The objects to be copied in the transfer operation.
Gets or sets the options for the transfer operation.
The options for the transfer operation.
Gets or sets a value that indicates whether to prefetch the objects before the transfer operation.
true if the objects are prefetched; otherwise, false.
Gets or sets a value that indicates whether DBO ownerships are retained through the transfer process.
true if SQL Server DBO ownerships are copied from the source database to the target database; otherwise, false. The default is false.
Gets or sets a value that indicates whether to preserve logins in the transfer operation.
true if the logins are preserved; otherwise, false. The default is false.
Gets the scripter for the transfer operation.
The scripter for the transfer operation.
Reports that an error occurred during the scripting process.
Marks the progress of the scripting process.
Creates a Transact-SQL command batch script that creates database objects that are transferred by the transfer operation.
The Transact-SQL script for transfer operation.
Sets the target server version based on the SQL Server version.
Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the source database.
true if the transfer operation translates the code page for characters on the source database; otherwise, false. The default is false.
Gets or sets the path to where the database files will be copied.
The path to where the database files will be copied.
Gets or sets the path to where the log files will be copied.
The path to where the log files will be copied.
Gets or sets a value that indicates whether to use the destination transaction.
true if the destination transaction is used; otherwise, false. The default is false.
The object provides programmatic access to the arguments used to report the details of the event that occurs when a backup verification operation completes.
Gets the property that specifies whether the verification operation was successful.
A value that specifies whether the verification operation was successful.If True, the verification operation was successful.If False (default), the verification operation was unsuccessful.
The class represents the event handler that handles completion events.
An value that specifies the source of the event.
An object that contains the event data.
The object represents a SQL Server registered server.
Initializes a new instance of the object.
Initializes a new instance of the object.
The T: to which the new registered server should be added.
A value that specifies the name of the registered server.
Initializes a new instance of the object.
The T: to which the new registered server should be added.
A value that specifies the name of the registered server.
Initializes a new instance of the object.
A value that specifies the name of the registered server.
Updates any object property changes on the instance of SQL Server.
Creates a registered server on the instance of SQL Server as defined by the object.
Gets or sets a textual description of the referenced registered server.
A value that specifies the textual description of the reference registered server.
Removes the from the server group and the registered server collection.
Gets a that is specified by a URN.
The that is specified by a URN.
A Microsoft.SqlServer.Management.Sdk.Sfc.Urn that identifies the object to get.
Gets or sets the login used to establish a connection with the registered server.
A value that specifies the used to establish a connection with the registered server.
Gets or sets the property value that specifies whether the connection is authenticated by Windows Authentication.
A value that specifies whether the connection is authenticated by Windows Authentication.If True (default), the connection is authenticated by Windows Authentication.If False, the connection is authenticated by using SQL Server standard authentication.
Gets the object value that specifies the parent of the object.
A object that is the parent of the object.
Gets or sets the password used with SQL Server standard authentication to establish a connection to the registered server.
A value that specifies the secure string password that is used to connect by using SQL Server standard authentication.
Gets or sets the instance of SQL Server that is the registered server.
A value that specifies the instance of SQL Server that is the registered server.
Gets the object value that represents the referenced registered server.
A object value that represents the referenced registered server.
The class represents a collection of objects that represent all the registered servers on the registered server group.
Adds a object to the collection.
A object that is to be added to the object.
Determines whether the specified string value exists within the collection.
A value that specifies whether the string value exists within the collection.If True, the string value exists within the collection; otherwise False.
A value that specifies a value for which the existence within the collection is being determined.
Copies the collection of objects to a one-dimensional array starting at the specified index value.
An array of objects.
An value that specifies the index value in the collection to start copying.
Gets the number of objects in the collection.
An value that specifies the number of objects in the collection.
Returns an interface that allows you to iterate through the objects in the collection.
An system interface for the referenced collection object.
Gets a object in the collection by index number.
A object value that represents the registered server.
An value that specifies the position of the object in the collection.
Gets a object in the collection by name.
A object value that represents the registered server.
A value that specifies the name of the object in the collection.
Gets the object that is the parent of the object.
A object that is the parent of the object.
Removes a object from the object.
A value that specifies the name of the registered server that is to be removed from the collection.
The class is a base class used in the construction of the object.
Gets a value indicating the collection is initialized.If True, collection is initialized. If False the collection is not initialized.
The sort list which contains the underlying collection of registered servers.
Gets a value indicating whether access to the collection is synchronized and therefore thread-safe.
A value that specifies whether the access to the collection is synchronized.If True, access to the collection is synchronized. If False (default), access to the collection is not synchronized.
Gets an object that can be used to synchronize access to the collection.
An value that can be used to synchronize access to the collection.
The class is a class used in the construction Microsoft SQL Server registered server objects.
Initializes a new instance of the object.
Initializes a new instance of the object based on the specified parent column and name.
A object that specifies the parent object.
A value that specifies the name of the object.
Checks the state of the object.
Initializes the object.
A value that specifies whether the object was initialized successfully.If True, the object initialized successfully.If False, the object failed to initialize.
A array.
An OrderBy object.
Initializes the object.
A value that specifies whether the object was initialized successfully.If True, the object initialized successfully.If False, the object failed to initialize.
Gets a value that specifies whether the object was initialized.
A value that is true if the object was initialized. Otherwise, false.
Gets or sets the name of the object.
A value that specifies the name for the object.
Gets the properties associated with the object.
A object value that specifies the properties of the object.
Refreshes the properties of the object.
Sets a parent.
A RegSvrSmoObject.
Sets a trace text.
A value specifying the trace text.
Gets the updated object state.
Gets the object that represents the object.
A object value that represents the object.
Gets the object that represents the object.
A object value that represents the object.
The object represents a group of Microsoft SQL Server registered servers.
Initializes a new instance of the object.
Initializes a new instance of the object based on the specified server group and with the specified name.
A object value that specifies the server group on which to base the new server group.
A value that specifies the name of the server group.
Initializes a new instance of the object that has the specified name.
A value that specifies the name of the server group.
Gets or sets the textual description of the referenced group of registered servers.
A value that contains the textual description of the server group.
Gets or sets the object that is the parent of the referenced object.
A object that is the parent of the referenced object.
Gets the path of the referenced server group.
A value that specifies the path of the referenced server group.
Gets the object value that specifies the type of server associated with the server group.
A system object value that specifies the type of server associated with the server group.
Gets the object value that represents the server group.
A object value that represents the server group.
The class is a base class that is used in the construction of the class, which represents a group of Microsoft SQL Server registered servers.
Updates any object property changes on the instance of Microsoft SQL Server.
Clears the server group collections.
Creates a server group on the instance of Microsoft SQL Server as defined by the object.
Removes the from the parent server group.
Gets a that is specified by a URN.
The that is specified by a URN.
A Microsoft.SqlServer.Management.Sdk.Sfc.Urn that identifies the object to get.
Represents a collection of objects. Each object represents a registered server that is included in the parent server group.
A object that represents all the registered servers that are included in the parent server group.
Represents a collection of objects. Each object represents a server group that is included in the parent server group.
A object that represents all the server groups that are included in the parent server group.
The class represents a collection of objects that represent all the server groups on the server group.
Adds a object to the collection.
A object that is to be added to the object.
Determines whether the specified string value exists within the collection.
A value that specifies whether the string value exists within the collection.If True, the string value exists within the collection.If False, the string value does not exist within the collection.
A value that specifies a value for which the existence within the collection is being determined.
Copies the collection objects to a one-dimensional array beginning at the index value specified.
An array of objects.
An
Int32
value that specifies the index position to start the copy.
Gets the number of objects in the referenced collection.
An value that specifies the number of objects in the referenced collection.
Returns an interface that lets you iterate through the objects in the collection.
An system interface for the referenced collection object.
Gets a object in the collection by index number.
A object value that represents the server group.
An value that specifies the position of the object in the collection.
Gets a object in the collection by name.
A object value that represents the server group.
A value that specifies the name of the object in the collection.
Gets the object that is the parent of the object.
A object that is the parent of the object.
Removes a object from the object.
A value that specifies the name of the server group that is to be removed from the collection.
--