Forum Discussion

airam_aseret's avatar
12 years ago

vxsnap create for SQL

Hi, I try to get a VSS snapshots for SQL, but I have a problem. This is my environment: I have distributed 10 database on 2 volumes and the logs in another one. E:\Database, with 5 database, ...
  • mikebounds's avatar
    12 years ago

    I beleive what is being asked is if multiple databases on a volume can be quiesced or to snapshot multiple databases is it neccessary to put each databases on its own set of volumes.  I came across the issue in 5.0 probably about 5 years ago and was told by Symantec support that I needed to put each database in its own set of volumes.  As the 5.1 documentation still does not mention snapshoting multiple databases on the same set of volumes, I guess this is still not possible.

    This is possible with Oracle because Oracle has its own command to quiesce databases so you just quiesce all databases, then snapshot volumes and then resume databases.  I believe with SQL, you need an API call to quiesce and resume database so it is not easy to do the manual individual steps to get a consistent SQL snapshot.

    Mike