Setting up Database Backups
Microsoft SQL Server offers various backup options (SQL Agent etc.). See the Microsoft Knowledge Base for more information.
Configuring backups for a Database with Microsoft SQL Server Express
Since Microsoft SQL Server Express does not offer an integrated backup feature, you can use the Citavi DBServer Manager to set up backups for databases on SQL Server Express. Backups can only be configured with DBServer Manager if Citavi is installed on the same computer on which SQL Server Express is being run, since Citavi DBServer Manager needs to configure a Windows task to ensure that backups are created regularly.
- Under Actions > Database click Configure backups.
- Click Browse to select the folder in which the backup file should be saved. The user account that is running the SQL Server service must have editing and reading permissions for the folder.
- To make sure that you have the correct permissions for the folder you selected, open the Windows Services feature (Control Panel > Administrative Tools > Services). Right-click the service SQL Server (NAME). Select Properties > Log On. Copy the entry in the This account field.
Switch to the Windows Explorer. Right-click the folder in which you want to save backups. Click Properties and switch to the Security tab. Click Edit, and then click Add. Paste the contents of the Clipboard in the box Enter the object names to select. Click Check Names and then click OK. Make sure that the following permissions have a checkmark in the Allow column: Modify; Read & Execute, List folder contents; Read; Write.
If the SQL Server service is run with a virtual service account (for example, NT Service\MSSQL$CITAVISERVER), this login name is only recognized by the MS SQL Server. If you want to save backups on another computer in the network, add the computer account for your MS SQL Server to the NTFS permissions for the backup folder.
Background: Services run under a virtual account use the credentials from your computer account to access network resources using the format <domain name>\<computer name>$.
- In DBServer Manager select the maximum number of backup versions to be saved. Older backups beyond this number will be deleted automatically unless you disable the option Delete older backups.
- If you want you can create email notifications for failed and successful backups. After selecting the settings you want, click Send test message.
- Click Run to manually create the first backup. The Citavi BackupHelper application starts and creates a backup of the database and all of the Citavi projects it contains. Backups are saved in the folder you selected with a time stamp (for example, CitaviProjectsACME 2015-07-28 13-44-02.bak).
Using the Task Scheduler to Automate Backups
- In Windows switch to the Control Panel, and then click Administrative Tools > Task Scheduler.
- Click Action > Create basic task.
- Enter a name for the task, and then click Next.
- Under Trigger select how often the task should be repeated, and then click Next. Select when the task should start and recur, and then click Next.
- Under Action, select Start a program, and then click Next.
- Click Browse and then select the path Program Files (x86)\Citavi 5\bin\BackupHelper.exe. The other fields in this section can be left empty.
- Click Next, and then click Finish.
Restoring a Database from a Backup
- In Citavi DBServer Manager under Actions > Database click Restore from backup.
- Select the backup for the database that you want to restore.
- Wait for the following message to appear: "The information from the database "[Name]" was successfully restored in the new database "[Name RECOVERED]".
- Delete the database you want to replace with the backup copy.
- Under Actions > Database click Rename and delete RECOVERED from the name of the recovered database.
- Wait for the following message to appear: "The database name "[Name RECOVERED]" was successfully changed to "[Name]".
- In Citavi DBServer Manager on the Tools menu, click Manage backups.
- Select the backup from the list and then select whether you want to edit or delete it.