Create Snapshot Dynamicly

  • Comments posted to this topic are about the item Create Snapshot Dynamicly

    ..>>..

    MobashA

  • BEWARE!I like this script overall, it's exactly what I was looking for but this will drop all snapshots on the instance of SQL Server, not just the ones related to the database you are snapshotting!

    Note the lack of a DB name in the where clause for the following:

    SELECT

    b.name AS orignal_database_name,

    a.name AS snapshot_name

    FROM

    sys.databases AS a

    JOIN

    sys.databases AS b ON a.source_database_id = b.database_id

    WHERE

    ISNULL(a.source_database_id, 00000) <> 00000

    Always review any code you download!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply