Search SSWUG.ORG:



ARTICLES

Database Snapshots - A View of Database at a Specific Point in Time




Beginning with SQL Server 2005, Microsoft introduced a new feature called database snaphots, which gives DBAs a way of presenting a consistent view of data at a certain time. So in other words we can say that it is a static, read-only copy of a source database that gives you a consistent view of a database as of a certain point in time. You can use the snapshot for operations supported by a read-only database, such as reporting applications. You can create multiple database snapshots on a source database. You can recover the source database to the point when the snapshot was created from a database snapshot. However, when recovering from a snapshot, the source database must be available.

Read this article...



Basit Aalishan Masood-Al-Farooq


Basit Farooq is an internationally known Lead SQL DBA, trainer, and technical author with twelve years' experience of the Microsoft technology stack. He is an accomplished development and production SQL Server DBA with a proven record of delivering major projects on time and within budget. He is an expert at evaluating the clients' needs against the capabilities of the SQL Server product set, with the objective of minimizing costs and maximizing functions by making innovative use of advance capabilities. He has developed and implemented many successful database infrastructures, data warehouses, and business intelligence projects.

Basit has authored SQL Server 2014 Development Essentials book, published by Packt Publishing. He was also a technical reviewer for SQL Server 2012 Reporting Services Blueprints, authored by Marlon Ribunal and Mickey Stuewe, and Reporting with Microsoft SQL Server 2012, authored by James Serra and Bill Anton, both books were published by Packt Publishing. 

Basit has written over 250 technical columns and articles related to Microsoft SQL Server administration, database design and development, Microsoft Windows Azure and SQL Server implementation and integration, and business intelligence design and implementation for different SQL Server community sites, including: SQLMag.com, MSSQLTips.com, SQLServerCentral.com, SSWUG.org, SQL-Server-Performance.com, and SearchSQLServer.com. He also blogs regularly at basitaalishan.com about SQL Server topics.

Basit holds a Master's degree in Computer Science from London Metropolitan University and industry-standard certifications from Microsoft, Sun, Cisco, Brainbench, ProSoft, and APM, which include MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.

He can be reached via Twitter (@BasitAali), his blog (basitaalishan.com), or via LinkedIn (uk.linkedin.com/in/basitfarooq).




comments powered by Disqus