sql 2012 - move ftdata folder
-
Tuesday, January 29, 2013 6:09 PM
I am moving all my system db's to a new drive. I noticed there are a few folders left, including FTData, JOBS, repldata. Are these folders ignored? I cannot find any docs for sql 2012 on moving these. Any suggestions?
Thanks
All Replies
-
Tuesday, January 29, 2013 6:39 PMModerator
Hello,
FTData could be related to fullt-text catalogs. To move them, please read the following article:
http://sqlserverpedia.com/wiki/FTS_-_Restoring_%26_Relocating_your_Catalogs
Please read the following article also, if you are moving system databases too.
http://msdn.microsoft.com/en-us/library/ms345408(v=sql.110).aspx
Hope this helps.Regards,
Alberto Morillo
SQLCoffee.com -
Tuesday, January 29, 2013 6:56 PM
This was a fresh install. The sysdbs were put on the wrong drive. I don't have any db's with ftc's, but wasn't sure how to move the ftdata folder then as it does contain xml files in there. All the documentation I find is for sql 2005/08
-
Tuesday, January 29, 2013 7:29 PMModerator
Hello,
If this is a new server, then you don’t have catalogs created and there is nothing to move.
Be careful moving the system databases.
Hope this helps.Regards,
Alberto Morillo
SQLCoffee.com- Marked As Answer by jrsqlguy Tuesday, January 29, 2013 7:35 PM
.png)
