A full SQL Server backup provides a database copy for recovery or transfer. This guide explains how to create one through SQL Server Management Studio (SSMS).
Create the backup
-
Open SSMS and connect to the correct SQL Server instance using an authorised account.
-
In Object Explorer, right-click the database and select Tasks > Back Up.
-
Check the database name, choose Full as the backup type and select a Disk destination.
-
Review existing destinations. Select Add to choose an approved server-side path and
.bakfilename.
-
Check overwrite or append options, then select OK and review the result.
The destination is on the SQL Server machine, not necessarily the computer running SSMS. The SQL Server service needs permission to write there, and your login needs backup permission.
Verify recovery
Keep a protected copy away from the database server and test restoration to a separate database. A successful backup notification does not by itself prove that your recovery procedure works. Coordinate ad hoc backups with the database administrator if an established backup chain is in use.