If your system is running on a local server then you have the option of backing up your database. Below you will find some simplified instructions on how to backup your database. These instructions are taken directly from the Microsoft SQL Help Website with slight modifications.
Alternative Help: Backing up SQL Database
Backup Your Database
- After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
- Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database.
- Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears.
- In the Database list box, verify the database name. You can optionally select a different database from the list.
- In the Backup type list box, select Full.
- For Destination Back up to Disk and click Add
- Enter the backup location and enter the File Name. Include the extension .bak
- On main Back Up screen click OK to proceed with backup.