Fordraiders
asked on
Attach and Detatch databases
sql server 2005 express
Will I lose my full text searching and all other indexes if I move my databases and then re-attach them later ?
from a E:\ drive to my C:\ drive
any advice or things to watch for ?
Thanks
fordraiders
Will I lose my full text searching and all other indexes if I move my databases and then re-attach them later ?
from a E:\ drive to my C:\ drive
any advice or things to watch for ?
Thanks
fordraiders
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> attach your Full Text File
Your Full text files would be available in the folder path mentioned in Aneesh's link.
You need to just copy those files and then Attach the files back in your destination database..
Your Full text files would be available in the folder path mentioned in Aneesh's link.
You need to just copy those files and then Attach the files back in your destination database..
ASKER
Thanks
fordraiders