September 21, 2018 at 2:35 am
Hello to all.
I am working with SQL Server 2012 Enterprise SP 4. This system has 3 instances and all of them are in a HAG.
Now I want to install anaother instance and would like to make them high available.
But this does not work. I get this message:
The requested row version was not found. There is probably no free space in the tempdb database. See the online documentation for information about configuring tempdb for versioning
I can't find a solution?
Any idea?
Regards
Alphanew
September 21, 2018 at 4:12 am
You haven't really given enough information for an answer. What does your TempDB look like (is it one file, what is the growth etc)? What free space do you have on the disk TempDB is on? Are the instances on the same server (strange way to use high availability, but whatever)? How are you trying to add the new instance etc?
September 24, 2018 at 5:42 am
Rick-153145 - Friday, September 21, 2018 4:12 AMYou haven't really given enough information for an answer. ... How are you trying to add the new instance etc?
This especially. But the question about whether the HAG is all on the same server or not is also important.
Another question for you... Why are you adding a new instance to the HAG? Is there a business reason or just a "I want another instance on the HAG" kind of reason?
The bad news is you may have to break the HAG and rebuild it from scratch. To do this, pause all data movement, remove all the secondary references from the HAG, prepare the new instance, then re-add all of them. It's a pain, but sometimes there are issues where rebuilding it is the only solution. I had to do it when our cluster didn't fail over properly after a corporate update package did something weird to our servers.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply