Can I use .DNF file to recover my data?

I want to recover data in a table on SQL 2000 server.
This database has 10 files (.MDF, NDF, and LDF). I know which .NDF file
contains the data of the table. I made detach the database.
Can I use one old backed up .NDF file replace the current .NDF file, and
together with other current files to attach this database?
Thanks for suggestions,No, SQL Server keep track of the database files and will not allow database files from different
point in time. That would adventure database integrity.
How about doing a restore (I presume you have backups) into a new database name, up until desired
time and then copy that table from there to your production database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Torry" <MikeTorry@.discussions.microsoft.com> wrote in message
news:1DCB6F00-51AC-468B-AC0A-1C350979B47E@.microsoft.com...
>I want to recover data in a table on SQL 2000 server.
> This database has 10 files (.MDF, NDF, and LDF). I know which .NDF file
> contains the data of the table. I made detach the database.
> Can I use one old backed up .NDF file replace the current .NDF file, and
> together with other current files to attach this database?
> Thanks for suggestions,
>|||Thanks for your help!
"Tibor Karaszi" wrote:
> No, SQL Server keep track of the database files and will not allow database files from different
> point in time. That would adventure database integrity.
> How about doing a restore (I presume you have backups) into a new database name, up until desired
> time and then copy that table from there to your production database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Mike Torry" <MikeTorry@.discussions.microsoft.com> wrote in message
> news:1DCB6F00-51AC-468B-AC0A-1C350979B47E@.microsoft.com...
> >I want to recover data in a table on SQL 2000 server.
> > This database has 10 files (.MDF, NDF, and LDF). I know which .NDF file
> > contains the data of the table. I made detach the database.
> > Can I use one old backed up .NDF file replace the current .NDF file, and
> > together with other current files to attach this database?
> >
> > Thanks for suggestions,
> >
>