Safeguarding a Database Prior to Making Mass Changes

Occasionally, you may need to perform operations against your database tables that result in some type of mass update being applied to big portions of the database, for example, running a manual update to correct data issues or deploying a new application build that may require data modifications, inserts, and/or stored procedure or table changes. Generating a database snapshot before any of these types of operations provides a nice safety net for rapid recovery in the event you are not satisfied with the mass update results. Figure 29.7 illustrates this type of safeguarding technique.

Image

FIGURE ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.