HP 10400 Application Software Suite for Microsoft SQL Media LTU manual RMSql setvc, SQL Server

Models: Application Software Suite for Microsoft SQL 7450 Application Software Suite Microsoft SQL Media LTU 10400 Application Software Suite for Microsoft SQL Media LTU

1 84
Download 84 pages 33.33 Kb
Page 63
Image 63

RMSql setvc

SYNTAX

RMSql setvc

-s <SQL server> [-i <instance>] [-d <database>] -t <timestamp> -exp <time>{hHdD} [-retain <time>{hHdD} [-f]]

DESCRIPTION

The RMSql setvc command sets time constraints for an existing virtual copy. To use this command, the policy must be expiration-based.

PARAMETERS

The following options are supported:

-s <SQL Server>

The SQL server to which the existing virtual copy belongs.

-i <SQL instance>

Optional. The SQL server instance to which the existing virtual

 

copy belongs. If not specified, MSSQLSERVER is used as the

 

default.

-d <database>

Optional. The database of the existing virtual copy. If not specified,

 

the timestamp is assumed to be at the instance level.

-t <timestamp>

The timestamp of the virtual copy for which you are changing the

 

expiration time.

-exp <time>{hHdD}

Set the expiration time for this virtual copy to the specified time

 

and time unit. Valid values are:

 

To set the expiration time in hours: 1-43800h (or H)

 

To set the expiration time in days: 1-1825d (or D)

-retain

Optional. Set or extend the retention time for the specified virtual

<time>{hHdD}

copy to the specified time. The virtual copy cannot be removed

 

during this time period.

Recovery Manager Commands 63

Page 63
Image 63
HP 10400 Application Software Suite for Microsoft SQL Media LTU manual RMSql setvc, SQL Server