What happens when we take SQL Server Full backup

• beejug1983

  SSCertifiable

  Points: 6491

  More actions

  September 4, 2013 at 2:59 am

  #395413

  Hi All,

  Please explain; what exactly happens internally in SQL Server when we take database full backup.

  Thanks in advance.

• HanShi

  SSC-Dedicated

  Points: 33519

  More actions

  September 4, 2013 at 3:07 am

  #1647216

  MSDN, Technet and BOL have very extensive explanation about the backup process.

  Just start reading 😉

  http://msdn.microsoft.com/en-us/library/ms175477(v=sql.90).aspx/css

  http://technet.microsoft.com/en-us/library/ms187048(v=sql.90).aspx

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

• Sean Pearce

  SSCoach

  Points: 15999

  More actions

  September 4, 2013 at 3:29 am

  #1647219

  beejug1983 (9/4/2013)

  ---

  Hi All,

  Please explain; what exactly happens internally in SQL Server when we take database full backup.

  Thanks in advance.

  Paul Randal wrote an excellent article on the subject.

  http://technet.microsoft.com/en-us/magazine/2009.07.sqlbackup.aspx

  

  The SQL Guy @ blogspot[/url]

  @SeanPearceSQL

  About Me[/url]

• beejug1983

  SSCertifiable

  Points: 6491

  More actions

  September 5, 2013 at 12:43 am

  #1647580

  Thanks Sean and HanShi for your replies.