Originally written by John Hardwick, last updated Oct 12, 2023, on the Swan Retail knowledge base (FRS).
Overview
If you have a Swan Hosted SwanFRS system, your data is automatically backed up and therefore no action is required.
As soon as you start building your data, it is important to remember the time spent in reaching this point. As you continue to use SwanFRS and eventually ‘go-live’ with the system your reliance on this data grows to the point it becomes a fundamental aspect of your business, therefore it is important to consider a security policy whereby you save this data to disk periodically.
This manual details the process of generating a ‘back up’ strategy, thus protecting your company from loss of data should your machine fail.
It is your responsibility to ensure your system has an up-to-date data backup. Should your machine suffer a problem, it may be necessary to restore from this back up. If this is not available, you may be forced with restoring an ‘out-of-date’ database or worse still rebuilding your system from scratch.
Operation
The process of setting up your security policy is detailed below –
Ensure the Server is Running
In order for SQL server's scheduling to work, the SQL Server Agent must be running. To ensure this is running, right click on the SQL Server icon (computer with green triangle) which appears in the menu bar on your screen
From the pop-up window highlight the Open SQL Server Service Manager and click to select.
Ensure the Server selected is your SwanFRS set and change the services option to SQL Server Agent. If the server agent is running correctly, the window will appear as per the image below, otherwise, hit the start/continue button.
Create a scheduled job
From the start menu, select Microsoft SQL Server and open Enterprise Manager.
Expand the database's view (as shown below) and right click on the database SwanFRSLive.
It is not recommended that the database is modified in any way.
This should be the only time the database is accessed, unless you are working under instruction from Swan.
Select All Tasks and Backup Database.
It is recommended that a directory called SwanFRSBackups is created on the biggest hard drive available. All backup files can be saved in this directory, and it is easy to find to create a hard copy of the backups.
A separate backup should be created for each day of the week. The example below will create a back-up for Monday.
Ensure the Database reflects the correct database to backup and that Database – complete backup is selected. If a destination for the backup already exists, select it and click remove. Next, click the Add button to create the backup file.
After clicking the Add button, browse on the filename and select the SwanFRSBackups directory from the tree view. Enter a filename, in this example, we have used SwanFRSLiveMonday.
Click OK to accept the backup destination and ensure the backup Destination is now displaying the file name and directory that you have selected.
Modify the Overwrite radio button and select Overwrite existing media. This will overwrite the backup file each week.
Tick the schedule box and select the button to edit the schedule.
Modify the schedule name, in this instance to SwanFRSLiveMonday and select a Recurring schedule type from the radio button. Click the Change button.
Select the Weekly option from the Occurs radio button. In this instance, tick the option to run only on Monday, every 1 week(s).
Set the time that the backup will run by changing the time in the Daily Frequency section. This must be a time when there will be no users in the system, and it is recommended that this time does not coincide with any other backup procedures.
Leave the No end date option selected and select OK. Select OK again on the Edit Schedule message box.
Double check that the Backup window has the correct destination and file name. The overwrite existing media option should be selected and Schedule ticked.
Double check that the schedule will occur on the correct day, at correct time.
Select OK and the scheduled backup will be created.
Repeat all the steps for each day of the week.
The same can be done for the SwanFRSTest database, but this is not as crucial, unless you are not running a live system, in which case, the Test data will need to be backed up regularly.
In the case of live systems, you may wish to create a schedule to back up the test system once a week rather than every day. If this is running on the same day as a live backup, then the test backup should be scheduled at a different time to the live backup.
Viewing / Editing the Backup Schedule
Once the backups have been created, they can be checked or amended in the SQL Server Agent Jobs folder, within SQL Server Enterprise Manager. You may need to right-click on the Jobs folder and Refresh to see the scheduled jobs.
Double click the scheduled job and click the schedules tab to view the created schedules. They can be edited or deleted from this screen. It will also inform the user of the last time the schedule was run.
The finished schedule should reflect the image below. The status comment will contain the details of the last successful backup.
Creating a Hard Copy
It is recommended that the SwanFRSBackups folder, or its equivalent, is backed up onto a removable medium (CD, DVD, Tape, Internet, Portable Hard Drive, etc.) once a week. This should be done weekly because the files will be overwritten. It is also recommended that one of these backups is taken off site at least once a month. This will protect against fire. In order to back up the application folder onto a removable recording device.
The application is in the following folder on your server.
c:\inetpub\wwwroot
Files from the Confluence page
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article