SqlBak Blog

Setting Advanced Scripting Options in SSMS

Advanced Scripting Options window in SSMS showing the selection of "Schema and data" for types of data to script

This screenshot demonstrates how to configure the Advanced Scripting Options in SSMS during the process of generating scripts. By setting “Types of data to script” to “Schema and data,” you ensure that both the database schema and its data are included in the logical backup.

Leave a Comment