O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

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

Creating Database Backups with SSMS

The backup options in SSMS are accessible through the Object Explorer. For example, you can right-click the AdventureWorks2012 database in the SSMS Object Explorer, select Tasks and Backup, and a backup window like the one shown in Figure 11.2 appears.

Image

FIGURE 11.2 The Back Up Database window in SSMS.

The Source section on the Back Up Database window contains information relative to the database that will be backed up. The source database is displayed in the first drop-down, along with the recovery model set for the database. The backup types available in the drop-down are dependent on the recovery model. ...

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