SQL Server Error while creating db from DUMP

25 pts.
Tags:
LDF
MDF
SQL Server database
SQL Server errors
Hi, We get the following error while trying to create a new db from a dump which contains the MDF and LDF files. Appreciate if anyone could let me know on what could be the reason for this error. The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0000000000000000 in file 'D:msqldatadblogsDNCRM_log.ldf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

Answer Wiki

Thanks. We'll let you know when a new response is added.

It sounds like your database backup is corrupt.

The log should be the last thing restored. After the database restore has failed the database should be left in either a restoring state, or a suspect state. Try detaching the database, and reattaching it without the transaction log and see if SQL can recreate an empty log file for you.

You can also try bring the database online using the ALTER DATABASE command and see what SQL Server does with it.

Do you have another backup which you can try to restore from?

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following