February 4, 2014 at 7:41 am
Hi All,
I use tfs, and there was necessity to downgrade tfs' sql server Enterprise edition to standard edition.
Before to downgrade, i should decompress compressed tables. When i run the query below.
select so.name
from sys.partitions sp
inner join sys.objects so on (so.object_id=sp.object_id)
where sp.data_compression!=0
I see there is a few internal tables with "ifts_comp_fragment_" prefix. When i execute:
[i]ALTER Table "sys"."ifts_comp_fragment_217767833_2681" REBUILD with(DATA_COMPRESSION=NONE)
[/i]
I am getting the error below:
Cannot find the object "sys.ifts_comp_fragment_217767833_2681" because it does not exist or you do not have permissions.
How do i achive this?
March 14, 2017 at 2:55 am
Hi!
No metter what the post date 🙂
I have the same problem and the same task - downgrade Edition and database with FTS catalog.
Have u got answer or just recreate FTS after downgrade?
i hope u'll read this!
March 15, 2017 at 5:40 pm
vavisv - Tuesday, March 14, 2017 2:55 AMHi!
No metter what the post date 🙂I have the same problem and the same task - downgrade Edition and database with FTS catalog.
Have u got answer or just recreate FTS after downgrade?i hope u'll read this!
Recreate the FTS catalog. Script it out before the downgrade
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply