The Active Network
ActiveMac Anonymous | Create a User | Reviews | News | Forums | Advertise  
 

  *  

  Using SQL 2005 Snapshots As A Rollback Procedure
Time: 01:49 EST/06:49 GMT | News Source: Microsoft | Posted By: Kenneth van Surksum

One of the great new features of SQL 2005 is database snapshots. With one simple transact SQL statement, you can provide your users with a read-only, static copy of their data. For example, you can take a snapshot on the last day of the month and users can do month-end reporting without worrying about changes to the underlying data. That’s pretty powerful. But did you know that snapshots can also be used to recover to a point in time? That is the subject of this article – how to use database snapshots to significantly reduce your recovery time in certain emergency situations.

Write Comment
Return to News

  Displaying 426 through 434 of 434
Prev | First
  The time now is 4:08:01 AM ET.
Any comment problems? E-mail us
#426 By 4240821 (142.111.253.203) at 1/28/2025 6:01:04 PM
https://justpaste.me/Y1MF1
https://justpaste.me/XyR51
https://justpaste.me/XboS2
https://justpaste.me/XN7x1
https://justpaste.me/Y1WX
https://justpaste.me/Y0U1
https://justpaste.me/Xji91
https://justpaste.me/XVdf
https://justpaste.me/XYXP1
https://justpaste.me/XcS93

#427 By 4240821 (193.36.231.79) at 1/29/2025 9:05:12 PM
https://justpaste.me/XUiE1
https://justpaste.me/XNu8
https://justpaste.me/Xr7d1
https://justpaste.me/XwOg3
https://justpaste.me/XorG2
https://justpaste.me/XlX12
https://justpaste.me/XkGu1
https://justpaste.me/XnoG4
https://justpaste.me/XRNZ
https://justpaste.me/Xw5j

#428 By 4240821 (193.160.216.96) at 2/10/2025 10:12:47 AM
https://hotpic.cc/album/SuGm9F0xjBAdt
https://hotpic.cc/album/fI5phoFCxplcC
https://hotpic.cc/album/19tmpOvTIqpke
https://hotpic.cc/album/eT3rPHdYbhwd6
https://hotpic.cc/album/TisBrYVWOQesD
https://hotpic.cc/album/JxGPrzaqJvdlM
https://hotpic.cc/album/h2EfL8HJWHnHp
https://hotpic.cc/album/PFelX6pe1wgeE
https://hotpic.cc/album/TisBrYVWOQesD
https://hotpic.cc/album/RLhm3JpTCNezj

#429 By 4240821 (193.36.231.79) at 2/11/2025 7:40:55 AM
https://hotpic.cc/album/G45LjUy6a3NG2
https://hotpic.cc/album/5rw0I6VwRHnDW
https://hotpic.cc/album/fYe5u0qz9cyAI
https://hotpic.cc/album/mvBqqceXF9RQn
https://hotpic.cc/album/y8SmvJYynyezm
https://hotpic.cc/album/zNiihp8NXuXKP
https://hotpic.cc/album/baBC4tVuvJpp9
https://hotpic.cc/album/aLUJoPXMwVa69
https://hotpic.cc/album/BEwlwSsmaCc6n
https://hotpic.cc/album/W9C70pLX73ITy

#430 By 4240821 (142.111.253.203) at 2/11/2025 10:48:26 AM
https://hotpic.cc/album/x0pa8br2BWLuS
https://hotpic.cc/album/lCKZr2dLrbaP2
https://hotpic.cc/album/QONaLm0fSHQHS
https://hotpic.cc/album/Sq4Sqo3sM7a4m
https://hotpic.cc/album/xF0aOQ82k5Kj9
https://hotpic.cc/album/DJXSCQGDI6yfM
https://hotpic.cc/album/MrrwIFhrHiTLL
https://hotpic.cc/album/0UoksDU49ZTfN
https://hotpic.cc/album/gSTwwLlKXjHm5
https://hotpic.cc/album/j1aT0tsYdwdmf

#431 By 4240821 (142.252.107.167) at 2/12/2025 12:19:45 AM
https://hotpic.cc/album/LWRe0MTiqi1Zw
https://hotpic.cc/album/dVTTHJc3kZbtT
https://hotpic.cc/album/ILPBOEnUGsAh7
https://hotpic.cc/album/RNxmJ8CLdBzYl
https://hotpic.cc/album/Z4vRsHaceNHzE
https://hotpic.cc/album/NR9fb0vX9KgHN
https://hotpic.cc/album/3tcBByiNUN5I5
https://hotpic.cc/album/pdY2q8AuDUKK5
https://hotpic.cc/album/TK2o4esORG9nv
https://hotpic.cc/album/EBTfIFRhY5C9b

#432 By 4240821 (193.228.48.158) at 2/12/2025 7:25:52 PM
https://hotpic.cc/album/Uq5A3Mz4vFbYz
https://hotpic.cc/album/2dDIGrcT9Dcta
https://hotpic.cc/album/hgCUUnxGerHRl
https://hotpic.cc/album/ct144u7sIpES9
https://hotpic.cc/album/xHX82fk000sXw
https://hotpic.cc/album/69YFVZgHj72oy
https://hotpic.cc/album/CzzRLYFRpwwvK
https://hotpic.cc/album/AGiX0hoZzJ4ZI
https://hotpic.cc/album/GIXKbHY4UHo7p
https://hotpic.cc/album/K0gQB7QyEGUhl

#433 By 4240821 (166.1.149.27) at 2/13/2025 1:52:13 AM
https://hotpic.cc/album/Cm2s7hW0WLI4h
https://hotpic.cc/album/VJpocRWnuv66c
https://hotpic.cc/album/FeIC9c1cMZ5iq
https://hotpic.cc/album/ulXI6Jt6BRUvP
https://hotpic.cc/album/1EBdcm3xwe6Cx
https://hotpic.cc/album/av3xrSGfMpIC6
https://hotpic.cc/album/hclq0xpjQxEXe
https://hotpic.cc/album/2aoVxGP0A0Pfe
https://hotpic.cc/album/Ksj2u2q6QCngx
https://hotpic.cc/album/rdJqUE2tEUVCY

#434 By 4240821 (142.111.253.203) at 2/14/2025 10:17:35 PM
https://hotpic.cc/album/fEEGgZIRKOLTb
https://hotpic.cc/album/oZMSthzYGL2lf
https://hotpic.cc/album/qUghyyWXnhAAQ
https://hotpic.cc/album/UFOFC4DTSJzIS
https://hotpic.cc/album/v2mxLfdIDg8jf
https://hotpic.cc/album/LGlmj9SxGl6Zn
https://hotpic.cc/album/nBAsuRSgzZMdr
https://hotpic.cc/album/19tmpOvTIqpke
https://hotpic.cc/album/XG98trkwm0CBP
https://hotpic.cc/album/mQ1QC0Mgi2ePy

Write Comment
Return to News
  Displaying 426 through 434 of 434
Prev | First
  The time now is 4:08:02 AM ET.
Any comment problems? E-mail us
User name and password:

 

  *  
  *   *