• Krishna1 (6/20/2013)


    Dear Gail

    Thank with the script given it working fine. I was trying through SSMS and it was creating the issue. Dont know whats going wrong when i try it from ssms

    I ran that from SSMS too. Either the DB was left in full recovery (which is the default) or you had some code somewhere that was changing the DB to full recovery.

    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