Backup a table to an SQL file via SSMS (Step 2) The first step of the Generate Scripts wizard in SSMS for backing up a database table.