Use SQL Management Studio to back up specific SQL databases such as Asset Manager and Dimensions. This is separate from a full server backup. Backups can be one-off or scheduled. To take a one-off backup (works in both SQL Express and full SQL):
Log in to SQL Management Studio.
Locate the database you want to back up.
Right-click the database and click Tasks > Backup.
Select a destination for the backup file.
Enter a name for the backup file.
Click Save.
In full SQL (not Express), you can set up a schedule to run backups automatically:
Click Management.
Click Maintenance Plans.
Click Add new plan.
Click Backup Database task.
Work through the window that appears.
Click Save.
There are a number of other useful tasks in the Maintenance Plan that should be investigated to help keep the databases running efficiently, please refer to the help in MS SQL Server for more details.
If the user is on SQL Express and requires scheduled backups additional software will be required such as Dimensions Administrator which can be installed from the Dimensions Installation Disc
If the system is running regular backups either manually or as scheduled jobs please ensure that regular housekeeping is carried out to ensure that the computers disc space doesn’t run out.