Worth Corner, Crawley, RH10 7SL

Support Hours - Mon-Sat, 8.00-18.00

Welcome to our SQL Server blog

This blog was created in order to pass on some of our knowledge and advice in the hope that the community might find it useful.

Obviously Microsoft SQL Server is our area of expertise and therefore this is our most thorough blog with everything from the basic through to the the incredibly advanced and, as such, we should have something for everyone within our pages.

Backup a Database Using SQL Server Management Studio
Published: Jan 20, 2014
Making backups using the GUI is a little longer than when using T-SQL (here), but they do provide a much easier way to see and customise your backup options.

Start by Right-clicking your database in the GUI and select TASKS -> Backup…

This will open up the backup screen…

The first thing to note (other than the fact that this is an independent window, ie. Not linked to the database you right clicked as you can change the database through a drop down list if you so wish) is that you can easily select the type of backup you wish to take by selecting from the drop down at the top right:

NOTE: There is also the option to select a “Copy-only Backup”. This is VERY important and will be discussed later in the Copy Only Backup section.

The majority of the screen is self-explanatory (description, backup name etc) but the next part to focus on is to add the location to which you wish the backup written… therefore click “Add…”:

Click "…"

Select the folder you in which you wish the backup to be stored, and then type the required filename, followed by clicking “OK”:

Click “OK” again:

It will now appear on the main backup form:

That’s basically it. If you click “OK” then SQL Server will create your backup file.

If you wish to add a couple of checks to your backups (always a good idea, although this can slow down the process), then prior to clicking “OK” for the final time, select “Options” in the top left and you’ll see Verification and Checksum options available to add to your backup:

That’s it. It’s the same process for all 3 types of backup, you simply select from the drop down list where appropriate.

Leave a Comment
Your email address will not be published. All fields are mandatory.
NB: Comments will only appear once they have been moderated.

SQL  World  CEO
Kevin  Urquhart

iPhone Selfie

I am a SQL Server DBA, Architect, Developer, Trainer, and CEO of SQL World. This is my blog in which I’m simply trying to share my SQL knowledge and experiences with the world.


© Copyright 2020 SQLTraining Ltd.