Exporting Latest State

To export data as of the latest available state, do the following:

  1. In the navigation pane, select a database or instance.

You can select the root instance node to export all the available databases at once.

  1. On the Database (or Server/Instance) tab, select Export Backup > Export latest state to Desktop\<db_name>.bak or right-click a database and select Export backup > Export latest state to Desktop\<db_name>.bak.

Using 1-Click Export