Post reply

backup backend process

  • August 16, 2011 at 6:37 am

    #242152

    Hi all,

    Can any one tell me the backend process of sql backups?

    Thanks in advance.

    Harish.G

  • August 16, 2011 at 6:55 am

    #1369042

    could you clarify what it is you want to know?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • August 16, 2011 at 7:12 am

    #1369055

    sure,

    for instance,if i ask a person to call up some one obviously he picks up receiver and enters the number it will be transfered to telephone exchange and from there it will be connected to destination now he picks up the call and communication will take place.

    after some time disconnect the call ,that will be stored some where in telephone record.

    Same way ,if i ask sqlserver to take the backup what are the steps it follow during the backup,what are the components of sqlserver involved in this process.

    Please let me know ,if you don't understand my example.

    Have been waiting for a person ,who can answer me this question in detail.

    Thanks in advance,

    harish

  • August 16, 2011 at 7:40 am

    #1369079

    First question: why? Are you trying to solve some particular problem?

    For deep internals, try this: http://technet.microsoft.com/en-us/sqlserver/gg429796.aspx (Video)

    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

  • August 16, 2011 at 7:56 am

    #1369089

    just to understand the internal mechanism.

    Regards,

    Harish.

  • August 16, 2011 at 8:32 am

    #1369112

    in truth unless you have a specific issue, maybe a 100TB database for instance, all you need to know is that the backup occurs. It's well documented about how the various pages are backed up and what happens with data which changes during the backusp - which si why we usually try to backup a database when activity is low.

    You may wish to write to multiple files to geta quicker backup, if you use a 3rd party tool, I use Litespeed, then there's a number of settings which affect the backup process.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply