• State Verified Answer
  • Locked Locked
  • Replies 4 replies
  • Subscribers 12 subscribers
  • Views 5937 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

LiteSpeed information in tables in tempdb

robert.lindberg
over 6 years ago

I am running LiteSpeed 8.2 on SQL Server 2014. I have 5,660 tables in tempdb having names like _rep_#someGUID. These tables contain LiteSpeed backup information. This is clogging up my tempdb. Some of the tables are at least 2 months old. How can I get rid of these? Does anyone know how or why they are there?

  • +1 over 6 years ago
    Hello,

    Those tables are created by a maintenance plan to hold status messages.
    You can delete these manually of course.

    But I would recommend opening a support case to see why these temp tables are not dropped when the maintenance plan completes.


    Thanks,
    -Ben-
  • 0 over 6 years ago
    I have a ticket open currently with support. I was hoping the answer was that I could drop them. If not, I plan to restart the server this weekend. Thanks for the reply.
  • +1 over 6 years ago
    Hello Robert,

    No problem, always happy to help!
    Please note I have opened LS-516 to address the issue of maintenance plans not dropping the temp tables they create.

    Thanks for bring this to our attention!
    -Ben-
  • 0 over 6 years ago
    I have found the same to be true in another of my instances also. In that database the tempdb is only 300mb vs 40gb in the first one. I still have a lot of space being consumed by something that is tying up almost 27gb that are not showing as available to tempdb operations in Spotlight. Anyway, thanks for your help on this.

    signed - old Oracle DBA trying to live in a Microsoft world.