Can I use .NDF file recover my data?

microsoft.public.sqlserver.programming

17 Aug 2006 4:11 PM

Mike Torry

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 files to attach this database?

Thanks for suggestions,

17 Aug 2006 5:36 PM

Aaron Bertrand [SQL Server MVP]

You will need a log recovery tool.
http://www.aspfaq.com/2449

Show quote

"Mike Torry" <MikeTo***@discussions.microsoft.com> wrote in message
news:F9DC530B-F28D-45A1-80D8-1365BEC88B0E@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 files to attach this database?
>
> Thanks for suggestions,