Hi All
Is there any tools to fix log file

my H.D.D have bad sector and that on SQL server directory on my database
login file(x_db_login.idf)
so I copy from there by tools but it's not work other file for(x_db_data)
what I do? I creat database by same name(x) and i copy SQL(x_data /x_log)
from old to new
but still giveme same erorr.

Any one have solution for this??

note:file size after i copied is same that mean data is there

thanks

Hello,

If a file has been damaged because of disk problems, copying it to somewhere
else will not fix the file. You have a couple of strategies you can try.

1 - If it is only the log file that has been corrupted, you can try creating
a new log file and replacing the existing one. This following link leads to
a risky and unsupported procedure. But it has worked for me in one server
disaster.
http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.server/2004-03/3026.html

2 - If the data file has been corrupted, I can only suggest that you restore
from your last good database backup and restore the log backups as far a
possible. If you do not have a good backup and you can get the database
online, you can try:

DBCC CHECKDB(yourdatabase)

You will probably be prompted after the check to run DBCC CHECKDB again,
with some possibility of data loss.

If nothing else works, then there are companies who provide a service to
recover from damaged databases, providing you are willing to pay for their
service. I have never used them and cannot rate their service:
http://www.adrdatarecovery.com/services/data_recovery/servers_sql.html
http://www.werecoverdata.com/landingpagegoogle.aspx
http://www.datarecovery.net/


RLF

[quoted text, click to view]