Post reply

differential backup at the time of indexing and database defrag

  • December 22, 2011 at 2:49 am

    #253917

    When indexing and database defrag is going on then can we take differential backup for same database?

    please reply .....

  • December 22, 2011 at 2:53 am

    #1424644

    Yes you can, but you don't have to take my word for it. You can test it on your own by running your maintenance procedure on a test database and taking a differential backup. This way if I’m wrong, you’ll know about it.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 22, 2011 at 2:56 am

    #1424649

    Thanks for reply...

  • December 22, 2011 at 3:06 am

    #1424654

    You can it doesn't mean you should. Please try not to mix these two tasks. You might kill your system (poor performance).

  • December 22, 2011 at 3:37 am

    #1424679

    You can. It's going to hit the IO subsystem hard, with two heavy IO tasks at the same time. It's also going to make the diff larger than it probably would be otherwise and may cause your transaction log to grow. Unless you have no choice, don't run them at the same time, doing so will slow both down.

    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

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

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