Full Backup

• jitendra.padhiyar

  SSCertifiable

  Points: 5824

  More actions

  June 28, 2012 at 2:14 pm

  #392625

  Hello Masters,

  A full database backup backs up "everything"; both the data and contents of the transaction log. Am i correct ?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 28, 2012 at 2:27 pm

  #1506843

  No.

  http://sqlskills.com/BLOGS/PAUL/post/Debunking-a-couple-of-myths-around-full-database-backups.aspx

  http://sqlskills.com/BLOGS/PAUL/post/More-on-how-much-transaction-log-a-full-backup-includes.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• jitendra.padhiyar

  SSCertifiable

  Points: 5824

  More actions

  June 28, 2012 at 2:54 pm

  #1506859

  Thanks a lot GilaMaster !

  given information is very useful.

  Thanks again.

• kapfundestanley

  SSCertifiable

  Points: 5637

  More actions

  July 12, 2012 at 3:38 am

  #1511947

  Thank you learnt something.

  “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris