It is stored in two separate files: one file contains the data, system tables, other database objects, the other file stores the transaction log.