|
|
|
SSChasing Mays
 
Group: General Forum Members
Last Login: Tuesday, November 10, 2009 10:35 AM
Points: 710,
Visits: 1,269
|
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Yesterday @ 12:05 PM
Points: 1,
Visits: 20
|
|
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!
|
|
|
|
