Error message on versioning in SQL Server 2005

Tags:
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?
ASKED: September 9, 2008  7:59 PM
UPDATED: September 10, 2008  3:15 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following