Return
-
Title
How to Backup or Restore a database using SQL Server Management Studio -
Description
How to backup or restore a database using SQL Server Management Studio.
-
Resolution
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 2012Restore a database using SQL Server Management Studio.
SQL 2005
SQL 2008
SQL 2008 R2
SQL 2012UPDATE:
Please note that the above instructions also apply for SQL 2014, SQL 2016, SQL 2017 and SQL 2019.