Specifies that snapshot writing is disabled. Snapshot writing
    is enabled by default. If you specify the SNAPSHOT IS DISABLED
    option, you cannot specify either of the SNAPSHOT IS ENABLED
    options, and you cannot back up the database on line. You can,
    however, continue to set snapshot options in the event that you
    will enable snapshots in the future. SQL warns you of a possible
    conflict in the setting of snapshot options while snapshots are
    disabled, but SQL will execute the statement.