Creating a backup using SQL Management Studio

1) In SQL Management Studio on the server, connect to the instance (eg.
SERVERNAME\SQLSERVER) where your Personnel database is located.

2) In the Object Explorer on the left (press F8 if it isn’t visible), expand the Databases section so
that you can see the Personnel database.

3) Right-click the Personnel database and select Tasks > Back Up…

4) In the new screen, ensure that Backup Type is set to Full, and that Backup component is set
to Database and there are 0 days against the Backup set will expire option.

5) In the Destination section, select the Back up to: Disk option. If there are any file paths in
the list below, select them and click Remove to clear the list.

6) Click Add… to open a second screen, and from here click the ‘…’ button to open a third
screen that displays your server’s hard drives and directories.

7) Select a suitable location for the backup file, and give a filename of PersonnelMigration.bak
– ensure that you add the .bak file extension to the filename as it is not automatically set.

8) Press Ok, then Ok, then Ok in the initial screen. A progress indicator will activate on the left
showing you the progress of the backup. Depending on the size of your database, this may
take several minutes.

9) Once the backup is finished, you can find it using Windows Explorer, right-click it and select
Send To > Compressed (zipped) Folder to put your backup into a zip archive, which can
compress the file size considerably to aid in transferring it