Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Management help II. Restore databases with full text index hangs Management Studio

1 view
Skip to first unread message

Vinko

unread,
Jun 11, 2008, 6:59:50 AM6/11/08
to
Hi, me again.

(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.

0 new messages