Questions I want to take a backup of particular tables available in my database in .bak file And all these should be done using T-SQL script Answers Backup Types are dependent on SQL Server Recovery Model. Every recovery model lets you back up whole or partial SQL Server database or individual files or filegroups of the database. Table-level backup cannot be created, there is no such option. But there is a workaround for this