How to Backup Lync (Part 3)
Over the past two posts, I’ve explained how to backup the core pieces of Lync such as the topology, location services and Response Groups. In this post, we will learn how to backup the Archiving and Monitoring roles.
First, the settings for the Archiving and Monitoring roles are backed up when you backup the core Lync services. This was covered in part 1 of this series but for completeness, here it is again:
Export-CsConfiguration -filename <path and filename for backup>
Export-CsConfiguration -filename c:mylyncbackup.zip
Second, you will need to backup the CDR and QoE databases from SQL. This can be handled multiple ways. You can back it up via a third-party backup tool (such as Microsoft’s Data Protection Manager) using a SQL plug-in. Or you can back it up via SQL itself to a .bak file. In this post, we will use SQL to backup the CDR and QoE databases to a .bak file.
NOTE: We are assuming that you are working with SQL 2005 SP3, SQL 2008 SP1 or SQL 2008 R2 (Standard or Enterprise). These steps will not work with SQL Express. Granted, if you are running Archiving and Monitoring, you don’t want to be using SQL Express anyways as the databases will quickly outgrow it anyways.
Log into your SQL server and open up SQL Management Studio. Find your database (we are going to back up the CDR database in this example) and highlight it.
Next, right click on the database, go to Tasks and then select Back Up.
This will bring up the Back Up settings.
Make sure the Destination is set to Disk and then hit Add to choose where the file will be saved.
I have called my backup file LcsCDR_06072012.bak. You can call yours whatever fits for your naming convention. Next, hit Ok and the backup will start. When it is finished, you should get a pop-up box.
The last step is to verify that your file was created and has actual size to it so you know that a backup truly happened.
This is the manual process for backing up your CDR and QoE databases. If you wanted to take it one step further, you would simply create a maintenance plan that would run nightly to perform these backups if you didn’t have something like Data Protection Manager to backup all of your SQL databases.
How to Back up Lync (Part 1) https://www.pei.com/2012/04/how-to-backup-lync-part-1/
How to Back up Lync (Part 2) https://www.pei.com/2012/06/how-to-backup-lync-part-2/
Adam Ball, PEI