Database Snapshots Maintenance and Security Considerations

With regard to database snapshots, several things need to be highly managed: snapshot sparse file size, data latency that corresponds to your users’ needs, the location of the sparse files within your physical deployment, the sheer number of database snapshots you are willing to support against a single database instance, and the security and access needs of users of database snapshots.

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.