Tuesday, February 14, 2012

can i recover the data from datafiles ?

Hi all,
I am new to Sql Server,well i would like to ask that can i recover a
data from data files? actually i have few datafiles and i want to
extract data form those files.the version of sql server is 7.0 and it
is running on windows 98.there is a option in oracle to recreate a
controlfile if you know the location of datafiles to recover data from
those files.i wonder if sql server has something
like this.
thanks
Alokhi
lookup sp_attach_single_file_db stored procedure in the bol
However, if you did not detach the database properly (or at all) you may
face some problems to attach it.
<alok.behria@.gmail.com> wrote in message
news:1130329268.797372.48850@.g47g2000cwa.googlegroups.com...
> Hi all,
> I am new to Sql Server,well i would like to ask that can i recover a
> data from data files? actually i have few datafiles and i want to
> extract data form those files.the version of sql server is 7.0 and it
> is running on windows 98.there is a option in oracle to recreate a
> controlfile if you know the location of datafiles to recover data from
> those files.i wonder if sql server has something
> like this.
> thanks
> Alok
>

No comments:

Post a Comment