I have a question and it goes somthing like this:

The System crashed and the person some how managed to save the data file form the
SQL 7.0 data file. They are the .MDF and the LDF files of the database.

Is it possible to recreate the database with these two files.

Thanks in advance.................

hai..............

you can attach them to a new server with sp_attach_db. Do check it in BOL.

HTH,
Dejan Sarka

I have a question and it goes somthing like this:

The System crashed and the person some how managed to save the data file
form the
SQL 7.0 data file. They are the .MDF and the LDF files of the database.

Is it possible to recreate the database with these two files.

Thanks in advance.................

hai..............

--
Tony Rogerson SQL Server MVP
Torver Computer Consultants Ltd
www.sql-server.co.uk [UK SQL Server User Group - FAQ, SQL Tutorials etc...]

Hi All,

I have a question and it goes somthing like this:

The System crashed and the person some how managed to save the data file
form the
SQL 7.0 data file. They are the .MDF and the LDF files of the database.

Is it possible to recreate the database with these two files.

Thanks in advance.................

hai..............