How to take Full Database Backup (MS SQL Server) This topic describes how to create a full database backup in SQL Server 2017 using SQL Server Management Studio Back up a database Open MS SQL server management studio, then try to connect SQL server on local or a remote location After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer , click the server name to expand the server tree. Expand Databases , and either select a user database or expand System Databases and select a system database. Right-click the database, point to Tasks , and then click Back Up . The Back Up Database dialog box appears. General box options opens, In the Database drop-down list, verify the database name. Optionally, you can select a different database from the list. The Recovery model text box is for reference only. You can perform a...