Q: Lost DB due to system crash but saved DB files how to recreate DB. 
Author Message
 Q: Lost DB due to system crash but saved DB files how to recreate DB.
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..............



Tue, 08 Jul 2003 14:02:27 GMT
 Q: Lost DB due to system crash but saved DB files how to recreate DB.

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..............



Tue, 08 Jul 2003 15:19:33 GMT
 Q: Lost DB due to system crash but saved DB files how to recreate DB.
You should be able to use sp_attach_db - check out books online.

--
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..............



Tue, 08 Jul 2003 15:24:33 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. D2 DB App crashes when reopening DB forms

2. DB Server crash when users write to the db

3. SQL DB to File...File to SQL DB???

4. Restore two DB file into four DB file

5. FM Server 3.0 on NT - Crashes losing 75% of db records

6. issue re: x-db ownership chaining and master db system tables

7. Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB

8. HELP!: DB/2 Query Manager (DB/2 v1.0) not available under DB/2 v2.1

9. restoring the db from the db files

10. Create new db from old db files?

11. Attaching Access Db files to Access DB

12. Unix dB files to DOS dB?


 
Powered by phpBB® Forum Software