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 Farooq is a Lead Database Administrator, Trainer and Technical author. He has more than a decade of IT experience in development, technical training, and database administration on Microsoft SQL Server platforms. Basit has authored numerous SQL Server technical articles and developed and implemented many successful database infrastructure, data warehouse and BI projects. He holds a master's degree in computer science from London Metropolitan University and industry standard certifications from Microsoft, Sun, Cisco, Brainbench, Prosoft and APM, including MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.
His online presences include:
comments powered by