Exporting the Current State

To quickly export selected database state as of the current restore point to a default location (C:\Users\%username%\Desktop), use the Export Database > Export state of <date_time> to Desktop\<db_name> command from the ribbon menu or database shortcut menu.

To export multiple databases, select the server or instance node in the navigation tree, then use the Export Databases > Export state of <date_time> to Desktop\<server_name> (for all databases of selected server) or the Export Databases > Export state of <date_time> to Desktop\<instance_name> (for all databases of selected server).