Database Backup

A tool for backing the data up and restoring it again.

Figure — Backup & Restore Tool, Backup tab; DB Server: hkuserver; Target Folder: C:\Backup; the date to start backing up data from; ☑ Remove source data after Backup; Start Backup

Figure — Backup & Restore Tool, Restore tab; DB Server: hkuserver; Source File: C:\Backup; Start Restore

Physical folder backup

To back the folder up, you must stop the database server. Open SQL Server Configuration Manager from the SQL program group, right-click the running service and choose Stop. When the backup has finished you must start the service again, or reboot the machine.

Figure — SQL Server Configuration Manager, SQL Server 2005 Services, showing the service states (SQL Server (MSSQLSERVER): Running; SQL Server Agent: Running); right-click to stop or start a service

Data rollover

The project is configured to keep historical data for up to 1900 days. Data older than that is removed automatically, without warning. To turn this off, clear the Enable tick and press Apply.

Figure — Backup & Restore Tool, Roll Over tab; ☑ Enable; Days to keep data: 1900; Apply