Take back up of database
create new database, restore the backup in your newly created database
run the below query in sqlserver editor copy the output of the query
open new Query window paste the output and run(F5), this will truncate all the table data
select 'truncate table ' + TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE like 'BASE TABLE'