Post reply

What has changed?

  • May 22, 2014 at 4:54 pm

    #285855

    We are putting in a new backup system that only takes the block level changes in the backups. We back up our sql server about every 2 hrs. Normall our back up is couple hundred megs nothing to major. But twice a day it hits 10gigs.

    We backup at 12 its 100Megs or so then at 2 we back up its 10 gigs. Same thing happens between 6-11PM.

    Now as nice as it would be the backup software doesn't show what it backed up as it just builds rolling images.

    Does sql have anything that can show me what is happening during these time frames because I cannot find anything that could be doing it but something sure is.

    Thanks

  • May 23, 2014 at 2:28 am

    #1715981

    Index maintenance job?

    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

  • May 23, 2014 at 7:33 am

    #1716056

    please forgive my newbieness

    whats that and how do we figure out if it is running?

  • May 23, 2014 at 7:50 am

    #1716063

    That would be a job, if you have one, that is scheduled, by you the DBAs, to rebuild indexes to remove their fragmentation.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • May 23, 2014 at 7:54 am

    #1716071

    Think of it as rearranging the books on your shelf so that they're in alphabetical order. Because each book is now in a different place, that counts as a change and so your backup is much larger. Check whether you have any maintenance plans or SQL Server Agent jobs that sound as if they may be doing index "maintenance" or "rebuilding".

    John

  • May 23, 2014 at 7:56 am

    #1716075

    I think we found it last night. When we were running backupexec to tape we were also pushing our critical DB's offsite with another product. This was disabled but the server got restarted and the services turned back on. So this product was coming along doing its thing, Then when the new back ran it saw everything as a change and took it all again.

    Thanks for all the help.

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

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