Post reply

What happens to users during a backup?

  • May 21, 2010 at 8:43 am

    #219191

    I have a need to make a backup during business hours. Normally this is done off hours when no one should be accessing the database.

    When the database freezes, is it just locked during the backup or are user connections dropped? One I can live with; the later is more of a problem.

    Just haven't done this before and thought I might find an answer here.

    Thanks!

    Norman

  • May 21, 2010 at 9:00 am

    #1170895

    Hi,

    Backup database task does not freeze database; users will not be dropped; They can connect to the database and work.

    Thank you

    [font="Verdana"]Renuka__[/font]

  • May 21, 2010 at 9:14 am

    #1170907

    when you take a backup, it gets the data, and then the log of all changes as well; so say you had a backup that was huge, and took 4 minutes to backup...people can continue working normally, and will not affect,slowdown or interrupt the backup .

    the last few seconds of the backup is getting all the current committed changes from the log and adding that too, so when the backup finishes, it's pretty much up to the second, and not just the data from when the backup started four minutes ago.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 21, 2010 at 10:07 am

    #1170936

    Thanks! I learned something new today!

    Norman

  • May 21, 2010 at 10:08 am

    #1170937

    And thank you as well Lowell,

    Much less of a problem than I thought.

    Norman

  • May 21, 2010 at 10:12 am

    #1170942

    glad i could help a bit!

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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