DIFFERENCE BETWEEN BACKUP AND RECOVERY

• sanfun

  SSC Rookie

  Points: 31

  More actions

  January 22, 2010 at 3:10 am

  #219740

  CAN ANYBODY TEL ME THE DIFFERENCE BETWEEN BACKUP AND RECOVERY

• Henrico Bekker

  One Orange Chip

  Points: 27652

  More actions

  January 22, 2010 at 3:25 am

  #1107205

  Backup enables you to do recovery 🙂 ( I assume you are referring to restore, and not a db in Recovery mode)

  Ok, all jokes aside, backup is: Making a copy of your database. (not going into granular details and options)

  Recovery: Getting back what you lost....i.e. restoring a backup of a database, after the original has gone corrupt.

  Read more on BACKUP:

  Meaning of the word: http://en.wikipedia.org/wiki/Backup

  MSDN: http://msdn.microsoft.com/en-us/library/ms186865.aspx

  Read more on RECOVERY (Restore):

  http://msdn.microsoft.com/en-us/library/ms186858.aspx

  If you were referring to a db in Recovery mode, please read:

  http://www.sqlservercentral.com/Forums/FindPost397609.aspx

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle