• State Verified Answer
  • Locked Locked
  • Replies 4 replies
  • Subscribers 12 subscribers
  • Views 5953 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?

Parents
  • +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-
Reply
  • +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-
Children
No Data