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 |
|
Pottman
Starting Member
2 Posts |
 Posted - 2010-05-13 : 07:07:48
|
| Dropping the full text index on a table in sql2008 seems to leave an orphaned ndf file.DROP FULLTEXT INDEX ON dbo.TblItemsDROP FULLTEXT CATALOG [15076_1_TblItems_Keywords]both complete and the index is gone... but EXEC sp_helpfilestill showsftrow_15076_1_TblItems_Keywords C:\SQLData\407824_lowandbonar_annualreport2008_com.ndf ftfg_15076_1_TblItems_KeywordsThe reason I'm trying to remove is that our cloud host charges for sqlStorage space and this 10Mb file is sat there not required for this client...Is the only option to have the host manually remove the file after I've issued the drop tsql?Help much appreciated :-) |
|
|
Pottman
Starting Member
2 Posts |
Posted - 2010-05-13 : 11:00:26
|
| Incase anyone stumbles on this... I found my own solution....DROP FULLTEXT INDEX ON dbo.TblItemsDROP FULLTEXT CATALOG [15076_1_TblItems_Keywords]ALTER DATABASE [407824_lowandbonar_annualreport2008_com] REMOVE FILE [ftrow_15076_1_TblItems_Keywords]ALTER DATABASE [407824_lowandbonar_annualreport2008_com] REMOVE FILEGROUP [ftfg_15076_1_TblItems_Keywords]does the trick. |
 |
|
|
|
|
|
Drop FullText Index....