Error when using db_shrinklog - There is already an object named 'DumpTrn' in the database.

• scdd25

  Newbie

  Points: 6

  More actions

  May 21, 2008 at 10:51 am

  #190881

  I experienced a power outage while running a shrink log in QA and now if I try to run it I get the following message:

  There is already an object named 'DumpTrn' in the database.

  I am not sure where to go to clear this in the db and in the mean time my transaction logs are huge.

  Any ideas? Thanks for the help.

• scdd25

  Newbie

  Points: 6

  More actions

  May 21, 2008 at 11:21 am

  #818757

  Cancel this. I dropped the 'DumpTrn' table db_shrinklog created and all is good now.