Home > IT Answers > SQL Server > Error message on versioning in SQL Server 2005
SQL Server Ask the Experts
2,585 pts.
 Error message on versioning in SQL Server 2005
SQL Server 2005, SQL Server errors, Versioning
I’ve received this error message on SQL Server 2005: "Version store is full. New version(s) could not be added. A transaction that needs to access the version store may be rolled back. Please refer to BOL on how to configure tempdb for versioning." What exactly is version store, and do I need to configuring tempdb in a certain way to manage versioning?

Software/Hardware used:
ASKED: September 9, 2008  7:59 PM
UPDATED: September 10, 2008  3:15 AM
RELATED QUESTIONS
Answer Wiki:
The version store would be where data is stored when snapshot isolation mode is being used. As I understand this error you basically need to expand the size of the tempdb database so that more versioning information can be stored within the tempdb database.
Last Wiki Answer Submitted:  September 10, 2008  3:15 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.