Backup and restore data from production in sql server

Best is to use Excel as the export, import format.

Sometimes you need to change the design of the table(remove primary key, disable read-only, etc), to make it work.

select db, choose Tasks->export data, choose excel.

to restore, choose Tasks -> import data,
select the file and make sure the mappings are correct.