Conversion from 7 to 2K

Hi
Have mdf, ldf files from SQL 7.0 (just files, SQL 7 server is not there
anymore). Now I have setup SQL 2000, how can I convert/import these files
into SQL2K.
Thanks
Hi,
Make a copy of MDF and LDF files, and then try attach them to the SQL Server
2000 instance.
SQL Server 2000 will attach the detached SQL Server 7.0 database files and
automatically convert them into SQL Server 2000 format.
Note:-
This process might fail incase if the SQL 7 files were not detached
properly.
Thanks
Hari
SQL Server MVP
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:6E42776C-61BB-4D7D-9ABC-DBCD2DE1076F@.microsoft.com...
> Hi
> Have mdf, ldf files from SQL 7.0 (just files, SQL 7 server is not there
> anymore). Now I have setup SQL 2000, how can I convert/import these files
> into SQL2K.
> Thanks
>
|||It worked. Thanks.
"Hari Prasad" wrote:

> Hi,
> Make a copy of MDF and LDF files, and then try attach them to the SQL Server
> 2000 instance.
> SQL Server 2000 will attach the detached SQL Server 7.0 database files and
> automatically convert them into SQL Server 2000 format.
> Note:-
> This process might fail incase if the SQL 7 files were not detached
> properly.
> Thanks
> Hari
> SQL Server MVP
> "Kelly" <Kelly@.discussions.microsoft.com> wrote in message
> news:6E42776C-61BB-4D7D-9ABC-DBCD2DE1076F@.microsoft.com...
>
>