Home Forums SQL Server 2005 SQL Server 2005 General Discussion A severe error occurred on the current command.The results, if any, should be discarded. RE: A severe error occurred on the current command.The results, if any, should be discarded.

  • February 15, 2013 at 11:03 am

    #1588438

    tony28 (2/15/2013)

    it was just on test DB, if i did this test http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx and after appeared error with FULL

    BACKUP LOG and when I wrote command dbcc shrinkdatabase ('Your-Data-Base-Name', TRUNCATEONLY) it showed error like this topic

    Why are your shrinking your database? It's not going to fix a full log error, will make it worse if anything.

    after I found this site, where I first tried very inelegant way, how someone writes and it worked, then i could do this test and it worked.

    http://stackoverflow.com/questions/56628/how-do-you-clear-the-transaction-log-in-a-sql-server-2005-database%5B/quote%5D

    Gah, that is horrid advice on that so-called accepted answer, absolutely horrid.

    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