Post reply

ONLINE INDEX and Diffrenticial Backup

  • May 18, 2011 at 3:06 am

    #251141

    When ı m making online index and when ı try to take diffrenticial backup backup cant takes very long time.....

  • May 18, 2011 at 3:09 am

    #1326276

    What do u want to say?Not clear

    Thanks

  • May 18, 2011 at 5:15 am

    #1326331

    It's possible that you're hitting resource contention when running both these processes at the same time. I'm assuming users are also accessing the system? You may want to separate the processes so that they don't run at the same time.

    Have you looked at the waiting states of the running processes to see what is blocking them?

    "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

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

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