Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2012-03-29 : 18:31:41
|
| Hi, I want to move a 2005 database and its 20 full-text catalogs - to another drive but on the same server.These are the steps I have identified. Are they accurate?1. Detach the database which contains the FullText Catalog. While detaching from Management Studio, there is "check box" called "Keep FullText Catalogs". Make sure that this is selected.2. Move the database file and catalog files to the location where you want them.3. Attach the database from Management Studio and this will try and find the FT catalogs=> this step will fail and it will prompt you to find the location of FTcatalog. Click 'yes'=> choose the FTCatalog path and presss 'OK'Have I missed any steps? Thanks, John |
|
|
|
|
|
Moving 2005 Database and Full-Text Catalogs