How to Generate a Backup Script with Data in Sql Server 2008 Express

1. Open the Sql Server management studio, right click on the database you want to generate the script.

Tasks -> Generate Script




2. Click next from the next if window if the correct database is selected.

3. Select Script Data to true on the next screen. 

4. Select the object types you want to script.



5. Then select the tables, stored procedures, views and functions on each window appear.

10. Finally click finish to generate the script.