Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Action Property (Restore)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The Action property specifies a restore operation target or type.

object.Action [= value]

object

An expression that evaluates to an object in the Applies To list.

value

A long integer specifying a restore operation as described in Settings

Long, enumerated

Read/write

HRESULT GetAction(SQLDMO_RESTORE_TYPE* pRetVal);
HRESULT SetAction(SQLDMO_RESTORE_TYPE NewValue);

Constant

Value

Description

SQLDMORestore_Database

0

Restores the database.

SQLDMORestore_Files

1

Restores only files indicated.

SQLDMORestore_Log

2

Restores records to the database transaction log.

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.

Community Additions

ADD
Show:
© 2015 Microsoft