Identify a Snapshot DB

[JayKusch]

Is there a system parameter like DATABASEPROPERTYEX that would identify whether a DB is a snapshot?

Thanks!

Thanks

J. Kusch

 

[TomKane]

Hey,

I got this from the msdn pages - I hope it helps:

To list the database snapshots of the instance of SQL Server, query the source_database_id column of the sys.databases catalog view for non-NULL values.

http://msdn.microsoft.com/en-us/library/ms175469.aspx

Regards,

 

[metevil80]

You could also create a policy that has a @IsDatabaseSnapshot condition which will verify whether your database it is a snapshot