How to Backup a SQL Database
Printable View
«
Go Back
Details
Title
How to Backup a SQL Database
URL Name
How-to-backup-a-SQL-database
Product
N/A
Other Environment Info
Resolution
Note:
This example is explained using
SQL Server 2012
; the backup procedure will vary in different versions of SQL server.
Log into SQL Management Studio.
Click the "
+
" next to
Databases
to expand databases.
Right click on the database to be backed up, and select
Tasks
>
Back Up..
.
On the
Back Up Database
screen, ensure
Backup type:
is set to
Full
and
Backup component:
is set to
Database
.
Click
Add
in the
Destination
section.
Click on the ellipses "..." button to give the backup file a location and name.
Populate the
File Name
, and change the destination path if desired, then click
OK
.
Click
OK
again on the
Select Backup Destination
screen.
Press
OK
to create the backup. This may take some time depending on the size of the database.
Need Help?