Sybase Database in a SAN Environment Using EVA Snapclone Technology (August 2007)

Cloning a Sybase Database Using EVA Snapclone Technology

Assumption:

Sybase Adaptive server 12.5.x is installed on Storage LUNs, and all the necessary Sybase

devices and databases exist on these storage LUNs.

To clone the Sybase database, complete the following steps:

1. Connect to the Sybase database using isql, and enter the following commands:

1> quiesce database tagname hold userdb1, <insert the names of the databases

here separated by commas>

2> master for external dump

3> GO

This step effectively places all your databases effectively in a clean state and ready for taking

Snapclone.

Note:

You may need to Snapclone more than one LUN, depending on the number of database

devices used.

2. Take the databases out of quiesce mode by entering the following commands in the

Sybase isql environment:

1> quiesce database tagname release

2> go

This creates a clean Snapclone from which you can generate your new Sybase database

copy.

Note:

You must execute this command for each volume.

3. Mount the cloned volume to the identical path that was on your original server. For more

information on mounting the Snapclones on a server, see step 7 in Cloning a Full Database

with Hot Backup.