(I could not find a specific management group, so I'm using this one)
Whenever I restore a backup that has fullText index information, the
SQL Management Studio hangs. If I kill the full text process and the
management studio after a while the restore happens to have occurred!
That means that I can use that restored database, I just have to
rebuild its full text index, and nothing is wrong. So, two questions:
1.- How can I prevent this from happening? I'd like the restore of the
full text index to happen without having to do this ugly workarounds
2.- Failing the above, can I create a backup without the full text
index? I haven't been able to, nor to tell the restore not to use the
full text file which would be the best option because I already have
plenty of full backups to be potentially restored.
Thanks.
V.