469,603 Members | 2,121 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,603 developers. It's quick & easy.

I dont have any backup of my database, but I have the mdf's and ldf's files

Im trying to recover my database using the mdf and ldf files.

I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:? :(

Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:

·"Full Path\Name.MDF is not a primary database file." (This is one of
the files repaired using the magic tool.

·Error: 823, Severity: 24, State: 6

·"I/O error (torn page) detected during read at offset
0000000000000000 in file 'Full Pathi\Name2.mdf'... Name2.mdf is the
second file

·Device activation error. The physical file name 'Full Path\Name2.mdf'
may be incorrect.
When i try to execute the command "DBCC CHECKDB ('Database_Name') WITH
PHYSICAL_ONLY" i get the following message :
·Could not open FCB for invalid file ID 0 in database 'Logs'.

Do you have any ideas?
Thank you very much...:D

Jul 23 '05 #1
2 4625
It sounds like the files are probably damaged beyond repair, or at
least beyond the sort of repairs that you can do without help from
Microsoft. If the contents of the database are valuable enough, I would
call MS to see if they can help you to recover the data, otherwise
you'll probably have to recreate everything.

And (obviously) you should plan a backup/restore strategy and a source
control system for your database code, to prevent any similar problems
in the future.

Simon

Jul 23 '05 #2
Probably, thats what i'll do (call Microsoft asking for help help
help...:D )...

I swear this is the first time i dont plan a backup/restore
strategy.... The database was configured a long time ago and I didnt
realize to do it...but i promise ill do the next time...:D

Anyway, I have run the demo tool MSSQLRecovery. This program analyze a
mdf file and recovers corrupt data. It has checked the tables, stored
procedures, indexes, relationships... and says that everything is
OK...but it doesnt generate any report...

Do you know any tool which recovers tables, stored procedures using the
primary mdf file?

Thank you in advanced

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by WH | last post: by
1 post views Thread by gcetti | last post: by
3 posts views Thread by mark_drewersback | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.