SQL 2K5 Snapshot | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL 2K5 Snapshot

Do you guys use SQL snapshot in your environment, if yes, for what kind of purposes? Any advantages? ——————
Bug explorer/finder/seeker/locator
——————
Snapshots used for Major deployments incase want to rollback and for reporting…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Hi, Database snapshots can be used for Protecting your system from user or administrator error
Offloading reporting
Maintaining historical data
System upgrades
Materializing data on standby servers
Recovering data Advantages The user can create as many snapshots as he/she wants quickly in no amount of time. The user can schedule to take snapshots every hour. This will be useful in auditing scenarios
The snapshots can be used in restore operations.
The corrupted or deleted data can be recovered from the snapshot to repair the primary database.
In case of user error, the administrator can revert back to the snapshot taken just before the error. Regards
Deepak
SQL DBA
MICROSOFT SQL SERVER
SQL Server 2005: When and how to use Database Snapshots
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1176142,00.html
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
http://www.simple-talk.com/sql/database-administration/sql-server-2005-snapshots/ best explanation so far on this snapshots usage. Only in case of reporting we are using this facility. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>