EXEC sp_configure 'recovery interval', 90

  • Me facing this problem when i m executing particular critearea like date between '2007-08-01' and '2007-08-31' other wise system runing well. kindly guide me tu resolve this issue

    i m using SQLServer 20000.

    Muhammad Rizwan Abid
    System Analyst
    mrizabid@hotmail.com

  • You say you have a problem when executing, but you're not saying what the problem is. Could you clarify further? Is it a performance issue within a query?

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • mrizabid (3/18/2009)


    Me facing this problem when i m executing particular critearea like date between '2007-08-01' and '2007-08-31'

    What does that have to do with setting the recovery interval?

    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 3 posts - 1 through 2 (of 2 total)

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