Data Backup and Recovery

SMO - Mirroring data subsets

JoeShmoe99
2,189 Views

Is there any way using SMO to run some sort of SQL script to limot the data mirrored to a date range?

Or another fancy way of doing this that avoids old school Oracle scripting?

1 REPLY 1

anandr
2,189 Views

Hi,

Can you explain in a lil more detail what your business use case is?

Unitl then, the following info might help:

SMO does integrate with Protection Manager to SnapVault or SnapMirror the local backups to a secondary storage system.  Once the lcoal backups are protected to secondary, using SMO you can restore them back to primary or clone them on secondary.

SMO provides pre and post scripts support only for the cloning operation.  SMO also can automate executing SQL scripts after a clone is created.  SMO currently does not provide these functionalities for backup or restore operations.

Thanks

Anand.

Public