Restoring SQL 2000 Database on 2008 R2 Creating Logical File
I have a database on SQL Server 2000. There are only two logical files in the PRIMARY file group: the data file and the log file. However, when restoring the database to SQL Server 2008 R2, there is now a new logical file named `ftrow_Table1Field1` with a file name `ftrow_Table1Field1{GUID}.ndf`. *(I've replaced the actual table, field name, and GUID for simplicity.)* The path to the .ndf file is MSSQL10_50.MSSQLSERVER\MSSQL\FTData\.

I did not create this logical file, nor did I enable full-text search on the database. Field1 was originally a TEXT data type in SQL Server 2000, which I've changed via T-SQL to a VARCHAR(MAX) field. This is also not the only field I've converted from TEXT to VARCHAR(MAX).

Can anyone shed some light on what is going on here?

EDIT: I did another restore without running my massive T-SQL scripts for the next software release. Direct from the SQL 2000 backup, it creates this file. Looking at the Properties of the field in SSMS, it says Full Text is False. The data type is TEXT. This is not the only TEXT field in the database.
Restoring SQL 2000 Database on 2008 R2 Creating Logical File
===

I have a database on SQL Server 2000. There are only two logical files in the PRIMARY file group: the data file and the log file. However, when restoring the database to SQL Server 2008 R2, there is now a new logical file named `ftrow_Table1Field1` with a file name `ftrow_Table1Field1{GUID}.ndf`. *(I've replaced the actual table, field name, and GUID for simplicity.)* The path to the .ndf file is MSSQL10_50.MSSQLSERVER\MSSQL\FTData\.

I did not create this logical file, nor did I enable full-text search on the database. Field1 was originally a TEXT data type in SQL Server 2000, which I've changed via T-SQL to a VARCHAR(MAX) field. This is also not the only field I've converted from TEXT to VARCHAR(MAX).

Can anyone shed some light on what is going on here?

EDIT: I did another restore without running my massive T-SQL scripts for the next software release. Direct from the SQL 2000 backup, it creates this file. Looking at the Properties of the field in SSMS, it says Full Text is False. The data type is TEXT. This is not the only TEXT field in the database.