How to backup a DataBase with Scripting  the tables with Data .

• First open the SQL Server and connect.
• Go to the desired DataBase  which you want to backup the data
• 
• 
  
• 
• Right click on the DataBase and select Task and go to the Generate script option .
• You will see the Sql Server Script Wizard.

• Next you will get the option of selecting the tables of the Database which you want to take the script.
• Select the table from give option.

• Choose script options, select the Table/View Options :----
• Select the True option from the script data option in Table/View Options.
• From choose script option: there is a option of script data: true and False
• For this if you want to script the table with data than select True option from script data (Table/View option)

• 
  
• Select the object type for script e.g.  Table, Stored Procedures or the Functions.

• Than select the tables which you want to script.

• Click on the finish button and you are done with scripting the Tables of a Database as Backup.