IN the case of production server which is running 24/7 and can't afford any downtime, it is good to keep the mirrored server for reporting purpose. Say if the requriement is to have r eporting server that should be updated with data from production server
Read More...
When using SNAPSHOT backups in SQL Server there are few things you need to consider, that included monitoring the disk space usage where the database backups & snapshot files are stored. BOL confirms about SNAPSHOT backups as: The underlying backup
Read More...
Snapshot backups are introduced in SQL Server 2005 version that uses: The underlying backup technology creates an instantaneous copy of the data that is being backed up. The instantaneous copying is typically accomplished by splitting a mirrored set of
Read More...