Create Snapshot Dynamicly

• mobasha

  SSCertifiable

  Points: 5334

  More actions

  June 21, 2008 at 9:16 pm

  #208729

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

  ..>>..

  MobashA

• psteffek-663021

  SSC Rookie

  Points: 32

  More actions

  October 22, 2009 at 4:42 pm

  #1069702

  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!