O'Reilly logo

Microsoft® Lync Server 2010 Unleashed by Tom Pacyk, Andrew Abbate, Alex Lewis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Backing Up SQL through SQL Server Management Studio

Another way to back up SQL is by using the native functions of SQL 2008 R2 to create a flat file backup that can be picked up by another backup application. This is especially useful if an environment already has a centralized backup infrastructure that doesn’t support SQL natively.

To back up SQL through the SQL Server Management Studio, perform the following steps:

1. Click Start, All Programs, Microsoft SQL Server 2008 R2, SQL Server Management Studio.

2. Connect to the appropriate instance of the Microsoft SQL Server Database Engine and provide the necessary credentials, as shown in Figure 11.7.

Figure 11.7 Connecting to SQL

3. Expand Databases in the left pane.

4. Right-click the database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required