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.