How to Get SQL Database Back Up
- Open the SQL Server Management Studio (SSMS)
Note: install SSMS beforehand (if needed) from https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16
2.Connect to the required SQL Server Instance in case it is not connected.
a. In SSMS go to File > Connect Object Explorer
b. In the pop-up window, enter the credentials for the SQL server instance where the database is located and click Connect.
3.If the Object Explorer window in SSMS is not open, open it via View > Object Explorer or just press F8.
4.In Object Explorer, expand the Databases folder. The list of all databases will be displayed.
5.Right click the required database and select Tasks > Back Up.
6.In the pop-up window, click Add and locate the path and the name of your future backup file (remember the path!)
7.In the Back Up Database window, click Ok.
8.The path, remembered on Step 6, specifies the location of your backup.