Applies To:
Microsoft SQL Server
Issue:
When importing a database, the restore fails. The error given states the SQL_DATA\ftrow_QCFTCAT.ndf file cannot be overwritten. And is being used by another database.
Microsoft.SqlServer.SmoExtended.
Solution:
When restoring the database, click the FILES option and rename the ndf file to something different.