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 sothat 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 setto 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 inthe 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 thirdscreen 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 leftshowing you the progress of the backup. Depending on the size of your database, this maytake several minutes.

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