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 451 through 455 of 455
Prev | First
  The time now is 5:19:54 PM ET.
Any comment problems? E-mail us
#451 By 4240821 (172.120.45.19) at 3/10/2025 1:10:55 AM
https://telegra.ph/Real-Madrid-Match-Insights-and-Rivalries-03-09
https://telegra.ph/Sergio-Ramoss-Champions-League-Triumph-03-09
https://telegra.ph/Mystery-of-McCartney-Kesslers-Disappearance-03-09
https://telegra.ph/Naji-Marshalls-NBA-Career-and-Highlights-03-10
https://telegra.ph/International-Womens-Day-2024-Highlights-03-06
https://telegra.ph/Jonah-Jackson-NFL-Player-Overview-03-04
https://telegra.ph/Stimulus-Checks-Bring-Temporary-Relief-Uncertainty-03-09
https://telegra.ph/Ben-Dwarshuis-Cricket-Career-Update-03-04
https://telegra.ph/Jimmy-Johnson-03-03-2
https://telegra.ph/Naji-Marshalls-Inspiring-NBA-Rise-03-09

#452 By 4240821 (142.111.213.137) at 3/10/2025 9:55:32 PM
https://telegra.ph/Exploring-Possible-Meanings-of-India-Match-03-09
https://telegra.ph/AI-App-Solves-Global-Communication-Barriers-03-06
https://telegra.ph/Olivia-Culpos-Vanishing-A-True-Crime-Tale-03-10
https://telegra.ph/Jordan-Goodwin-Saves-Family-from-Burning-Home-03-09
https://telegra.ph/Plane-Crash-in-Lancaster-Town-Rallies-Together-03-10
https://telegra.ph/Notre-Dame-Basketballs-Championship-Rise-03-09
https://telegra.ph/Fascinating-Facts-About-International-Womens-Day-03-06
https://telegra.ph/Drew-Dalman-NFL-Career-Update-03-05
https://telegra.ph/Chelsea-FC-Latest-Updates-and-Recent-Developments-03-09
https://telegra.ph/Suns-Dominate-Mavericks-in-Thrilling-Game-03-09

#453 By 4240821 (142.252.83.34) at 3/11/2025 11:37:06 AM
https://telegra.ph/Darius-Slays-Impressive-NFL-Career-Facts-03-10
https://telegra.ph/Kane-Williamson-Steps-Down-as-Test-Captain-03-05
https://telegra.ph/Towson-Tigers-Rise-to-CAA-Championship-03-10
https://telegra.ph/Paradise-Season-2-03-04
https://telegra.ph/Kendrick-Perkins-From-NBA-Champion-to-Analyst-03-09
https://telegra.ph/Governor-Hunts-Shadow-of-Corruption-03-09
https://telegra.ph/George-Pickens-Leads-Steelers-to-Overtime-Victory-03-10
https://telegra.ph/UEFA-Announces-2024-Champions-League-Fixtures-03-05
https://telegra.ph/George-Pickens-Shines-in-Steelers-Victory-03-10
https://telegra.ph/San-Luis-vs-Juárez-Football-Match-Overview-03-08

#454 By 4240821 (172.120.45.19) at 3/12/2025 3:55:53 PM
https://telegra.ph/Madison-Keys-Wins-First-Wimbledon-Title-03-08
https://telegra.ph/Identifying-Diego-Lopes-in-Various-Fields-03-09
https://telegra.ph/Tijuana-and-Atlas-Football-Match-Updates-03-10
https://telegra.ph/Naji-Marshalls-NBA-Career-and-Highlights-03-10
https://telegra.ph/Iowa-Hawkeyes-Triumph-in-Overtime-Thriller-03-07
https://telegra.ph/Scott-Laughton-NHL-Player-Overview-03-07
https://telegra.ph/Guardian-Solomon-Saves-the-Forgotten-Forest-03-11
https://telegra.ph/Invincible-Season-3-Episode-7-Fractured-Horizons-03-06
https://telegra.ph/Nick-Lachey-Finds-Inspiration-in-Unexpected-Place-03-10
https://telegra.ph/Nick-Lachey-Finds-Inspiration-in-Unexpected-Place-03-10

#455 By 4240821 (172.120.204.11) at 3/13/2025 10:04:52 AM
https://telegra.ph/West-Ham-vs-Newcastle-Match-Overview-03-10
https://telegra.ph/PSV-vs-Heerenveen-Match-Updates-Inquiry-03-08
https://telegra.ph/Howard-Lutnicks-Resilience-After-Tragedy-03-09
https://telegra.ph/Texas-Womens-Basketball-Historical-Success-and-Impact-03-09
https://telegra.ph/Bucknell-Basketball-On-Court-Glory-Off-Court-Drama-03-09
https://telegra.ph/Bucknell-Bisons-Cinderella-NCAA-Run-03-09
https://telegra.ph/Savannah-Guthries-Secret-Garden-Adventure-03-11
https://telegra.ph/Olivia-Culpos-Vanishing-A-True-Crime-Tale-03-10
https://telegra.ph/Khabib-Launches-Global-MMA-Academy-03-09
https://telegra.ph/Exploring-TimeChange-in-Various-Contexts-03-09

Write Comment
Return to News
  Displaying 451 through 455 of 455
Prev | First
  The time now is 5:19:54 PM ET.
Any comment problems? E-mail us
User name and password:

 

  *  
  *   *