Blog – Tempdb 02

Insufficient space in tempdb to hold row versions. Need to shrink the version store to free up some space in tempdb

SQL Server Error Message:-
Insufficient space in tempdb to hold row versions. Need to shrink the version store to free up some space in tempdb. Transaction (id=7451216905 xsn=1161804223 spid=80 elapsed_time=328) has been marked as victim and it will be rolled back if it accesses the version store. If the problem persists, the likely cause is improperly sized tempdb or long running transactions. Please refer to BOL on how to configure tempdb for versioning.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.