How to backup or restore a database using SQL Server Management Studio.
Use the links below depending on the SQL version that is installed:
Backup a database using SQL Server Management Studio.
NOTE: It is recommended to regularly do a full database backup.
SQL 2005
SQL 2008
SQL 2008 R2
SQL 2012
Restore a database using SQL Server Management Studio.
SQL 2005
SQL 2008
SQL 2008 R2
SQL 2012
UPDATE:
Please note that the above instructions also apply for SQL 2014, SQL 2016, SQL 2017 and SQL 2019.
