There are three ways, that I know of, that allow you to create logical backups of an SQL Server database.
(1) Detach and copy the data and log files (.mdf) from the data directory;
(2) Create a backup file (.bak) from the Tasks -> Backup menu when you right-click on the database in SQL Server Management Studio (Express) and;
(3) Create an SQL backup file in DDL-format (.sql) using the Microsoft SQL Server Database Publishing Wizard;
