Backing up DWD Databases Follow these steps to back up the DWD database in SQL. Back up the DWD database Open Microsoft SQL Server Management Studio and connect to the DWD server. Select the appropriate database engine. Expand the database folder and locate the database to backup. Right-click the database name and select Tasks > Back Up to open the Back p Database window. Select and enter back up information as required. Click OK. Note: Refer to Microsoft documentation for additional information.