Another way to back up SQL is by using the native backup function of SQL to create a flat file backup, which can then become the target for a separate backup application if necessary. This method is especially useful if an environment already has a centralized backup infrastructure that doesn’t support SQL natively. The sample backup procedure that follows is based on SQL Server 2012; however, the steps are very similar for SQL Server 2008 R2.
To back up SQL through the SQL Server Management Studio, perform the following steps:
1. Log on to the server where Lync Back End databases are installed using an account with SQL administrative rights, and open SQL Server Management Studio.
2. At the Connect ...