Post reply

Transaction log back up

  • March 8, 2011 at 9:15 am

    #234782

    I was doing a full back up of the four databases on the data server without realizing that if the database recovery model is FULL , it's vital to do a transaction log back up.

    The database back up runs at 3:00 AM every day as a part of the maitenance plan.

    Can I just start transcation log back up now? Does this degrade the performance of the database ?

    I am new to this and any help wpuld be gretly appreciated.

    Thanks

  • March 8, 2011 at 9:25 am

    #1295964

    Please, please read this posting by Steve Jones (posted today as an editorial)

    http://www.sqlservercentral.com/articles/Editorial/72676/

    Added at 11:35

    Also be sure to read the forum discussion on Steve's editorial.

    -----------------------

    If that does not get you to begin backing up the log file(s), may I then suggest reviewing and updating your resume

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • March 8, 2011 at 9:31 am

    #1295967

    msharma-393915 (3/8/2011)

    I was doing a full back up of the four databases on the data server without realizing that if the database recovery model is FULL , it's vital to do a transaction log back up.

    The database back up runs at 3:00 AM every day as a part of the maitenance plan.

    Can I just start transcation log back up now? Does this degrade the performance of the database ?

    I am new to this and any help wpuld be gretly appreciated.

    Thanks

    Yes, start the t-log backups now. I run mine every 15 minutes or so.

  • March 8, 2011 at 9:38 am

    #1295975

    T-Log backups typically don't have a huge impact on performance, but there is writing to the IO subsystem, so there could be some contention there, depending on your setup. If you have these running regularly, then you should be fine with the load.

    Most people I know run these at least every hour if not more often. The schedule will depend on the amount of data you can afford to lose.

Viewing 4 posts - 1 through 3 (of 3 total)

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