[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

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
0
Fordraiders
Asked:
Fordraiders
  • 2
2 Solutions
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
You need to attach your Full Text File in order to retain your Full Text search indexes..
And its always recommended to Rebuild indexes in your database after you attach it.
0
 
FordraidersAuthor Commented:
ok...this is my first time doing this.. " attach your Full Text File "  ??


Thanks
fordraiders

0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Hello fordraiders,

http://support.microsoft.com/kb/240867

Regards,

Aneesh
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> 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..
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now