How to identify a database snapshot?

Hello,

Because you can not backup a database snapshot, I'm curious to as how you identify the database as a snapshot? I need to add an exclusion to my backup scripts so that they don't attempt to backup a snapshot.

Thanks

select source_database_id from sys.databases

if source_database_id is null for a database then it is not a snapshot.

if it is not null, then the database is a snapshot and the source_database_id refers to the database from which the snapshot was created.

Also take a look at http://msdn2.microsoft.com/en-us/library/ms178534.aspx