Top of Page
This topic explains how to perform general maintenance tasks for NVivo Server—for example, how to back up, restore and repair projects and refresh the list of projects you see in NVivo Server Manager.
It is important to regularly backup server projects—the simplest way to ensure server projects are backed up regularly, is to create a backup schedule in NVivo Server Manager. Once created, the backup schedule runs automatically and backs up all the projects on the server. If you prefer, you can back up projects via SQL Server Management Studio—this allows you to create more complex schedules or backup individual projects.
You can view the backup schedule on the Backups tab in NVivo Server Manager—if there is no schedule, you can create one.
To create the backup schedule via NVivo Server Manager:
Open the NVivo Server Manager.
Click the Backups tab.
Click Create.
The Create Backup Schedule dialog box opens.
Select when you want the backup operation to run, by setting the Frequency, Time of Day and Start date.
Set backup expiry options—by default, backups do not expire. If you want to automatically expire backups, select After and set the number of days you want to retain the backup files.
Click Browse, and select the location of your backup files.
Select the Send e-mail if backup fails check box, if you want to be notified when a scheduled backup did not complete successfully. If you select this option, you must also enter:
SMTP Address—this is the address of your mail server (this mail server must allow relay from the NVivo Server without authentication). You can enter an IP address or a fully qualified domain name.
From e-mail address—this e-mail address defines the sender of the e-mail.
E-mail recipients—this can be one or more e-mail addresses for recipients (separated by a semi-colon).
Click OK.
NOTE
You can modify the backup schedule after you have created it. For example, you might want to change the frequency from weekly to daily or change the location of the backup files. To change the existing backup schedule, click the Modify button and change the required options.
You can delete the backup schedule—for example, if you decide to back up projects via SQL Server Management Studio, you may decide to delete the schedule in NVivo Server Manager.
If you do not expire backups, you should monitor disk space utilization in your backup location.
Once your backup schedule is created, you can check that the backups are running successfully via the History tab on the left.
You can restore a project from backup—refer to Restore a server project from backup for more information.
If you have set up a regular backup schedule via NVivo Server Manager, you can also restore a project via the Server Manager. When you restore a project, you can choose to restore to the existing project or restore to a new project.
TIP If a user has accidentally deleted content from their project and wants to see if a backup has the missing content, it is a good idea to restore a backup copy to a new project. If the new project has the missing content, the user can import the missing content via the NVivo client. This approach ensures that the user does not lose any work they have done in the existing project since the backup was made.
To restore a project:
Open the NVivo Server Manager.
Click the Backups tab.
On the left, click the Restore tab.
Under Destination for restore, choose where you want to restore to. You can restore to:
An existing project—select the project from the To Existing Project list.
A new project—enter a name for the new project.
Under Source for restore, select the project that you want to restore from the From Project list:
Select the backup you want to restore from—each backup is identified by the date and time it was created.
Click Restore.
NOTE If you are managing backups via SQL Server Management Studio, you will also need to restore the database via SQL Server Management Studio.
NVivo Server Manager allows you to create a simple backup schedule, but if you want to back up an individual project or create special schedules for particular projects, you will need to do this via SQL Server Management Studio. For more information, refer to the following MSDN articles:
Create a Full Database Backup (SQL Server Management Studio).
Use the Maintenance Plan Wizard (SQL Server Management Studio)
Each NVivo Server project is stored as a separate database in NVivo Server's SQL database instance. This means that these project databases can be backed up and restored on the same server device or a different one.
Alternatively, a project database can also be detached and re-attached into the same machine or a different one. Refer to the following MSDN articles:
You can use the Repair facility when projects become fragmented and are using server space inefficiently. When you repair a project, the project format (for example,10.0 or 9.2) is not changed.
It is a good idea to warn users before you repair a project as they will be automatically disconnected.
CAUTION If you choose to 'repair with possible data loss', you should back up the project before repairing. Individual projects can be backed using SQL Server Management Studio—refer to Back up projects via SQL Server Management Studio for more information.
To repair a project:
Open the NVivo Server Manager.
Click the Projects tab.
In the Projects list, select the project you want to repair.
Click Repair.
By default, server project data and log files are stored in the directory:
C:\Program Files\Microsoft SQL Server\MSSQL11.QSRNVIVO9\MSSQL\DATA\
To change the locations of data and log files for new projects:
Open the NVivo Server Manager.
Click the Settings tab.
Click the Browse buttons beside the Data file and Log file boxes to select the new folder locations. We recommend you store data and log files in an uncompressed locally attached disk that NVivo Server has permission to write to.
Click Save.
NOTE
The Log file setting only applies to new NVivo 10 for Windows format projects. Log files for NVivo 9 format projects are stored in the same location as the data files.
If you want to move existing files to a new location, you will need to migrate the project files using SQL Server Management Studio.
The default log file location above applies to NVivo Server 10 R2. If you are using NVivo Server 10, log files are stored in this location.
The Projects tab of the Server Manager displays all projects that are registered in the NVivo Server metabase. If you manually restore a project using SQL Server Management Studio, the project is not automatically registered in the metabase. When you refresh the project's list, the metabase's register of projects is rebuilt.
To refresh the project list
Open the NVivo Server Manager.
Click the Projects tab.
Click Refresh.
Click OK to confirm.
NOTE When the metabase project register is rebuilt, any projects that have been manually deleted from the server using SQL Server Management Studio will be removed from the list. The projects list will show only projects currently available on the server.
NVivo Server is currently only available in English.