Action Property (Restore) (SQL-DMO)

The Action property specifies a restore operation target or type.

Applies To

Syntax

object.Action [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	Long integer specifying a restore operation as described in Settings

Settings

Constant	Value	Description
SQLDMORestore_Database	0	Restore the database
SQLDMORestore_Files	1	Restore only files indicated
SQLDMORestore_Log	2	Restore records to the database transaction log

Remarks

Microsoft® SQL Server™ can restore a database, one or more operating system files containing table or index data, or part or all of the transaction log of a database.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetAction(SQLDMO_RESTORE_TYPE* pRetVal);

HRESULT SetAction(SQLDMO_RESTORE_TYPE NewValue);