I Can't Attach an MDF, on SQL MANAGER 2005 (HELP)

Question

Post reply

I Can't Attach an MDF, on SQL MANAGER 2005 (HELP)

miguelxsc

SSC Journeyman

Points: 92
More actions
December 16, 2010 at 1:50 pm

#228496

Hello everyone
I'm in big trouble and need your help.
My server running Windows 2003 Server, suffered a power outage, which resulted in the destruction of the raid had.
I had to take the disks to a laboratory where it was rebuilt the raid.
He had two databases on the server, I got a file from mdf and LFD rebuild, despite having attachments without ldf therefore attach to the SQL server 2005 managed to rebuild the log.
In the case of another database strange thing happened, the date of the MDF does not match the last date of use, is dated June when the last use was in October, however the log I have the date of October.
Another strange thing is that the database typically had 700 mb and is currently at 580 mb. .
Does anyone have any suggestions to rebuild and get this database?
Help me please.
Thanks.

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

What's the exact error when you try to attach?

Let me guess, no backup?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

miguelxsc SSC Journeyman Points: 92 More actions · Answer 2

These are the two error messages.

The first attempt tried to use the log.

In the second he tried to rebuild the log.

thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Text of the errors please. I'm not downloading 5MB of images just to see a couple hundred bytes of test data.

Do you have a backup?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

miguelxsc SSC Journeyman Points: 92 More actions · Answer 4

miguelxsc

SSC Journeyman

Points: 92

December 16, 2010 at 2:50 pm

#1263751

No i don't have a backup

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

GilaMonster (12/16/2010)
Text of the errors please. I'm not downloading 5MB of images just to see a couple hundred bytes of test data.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

miguelxsc SSC Journeyman Points: 92 More actions · Answer 6

without log i have this message:

The log cannot rebuilt because the database was not cleanly shutdown.

miguelxsc SSC Journeyman Points: 92 More actions · Answer 7

An exception occurred while executing a transact-sql statement or batch

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

And with the log?

The more info you give the more likely it is that someone can help. If you're vague we're just going to keep asking for more and more details.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

miguelxsc SSC Journeyman Points: 92 More actions · Answer 9

An excepcional occurred while executing a trasact-sql statement or batch.

The operating system returned error 38 (end of file) to sql Server during a read at offset 0x000000100000 in file .....*.log

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 10

Ok... Give this a try, see if it lets you get the DB back. If not, you're out of luck.

http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

moosamca Right there with Babe Points: 773 More actions · Answer 11

Hi miguelxsc,

The SQL Server 2005 some time through this error, but i don't know why it is coming. However the database will attach successfully, even though it showed that error message. Could you please refresh your database and you will see your database there.

Regards

Moosa

Paul Randal One Orange Chip Points: 29544 More actions · Answer 12

moosamca (1/24/2011)
Hi miguelxsc,
The SQL Server 2005 some time through this error, but i don't know why it is coming. However the database will attach successfully, even though it showed that error message. Could you please refresh your database and you will see your database there.
Regards
Moosa

It's great that you're enthusiastic - but please don't post advice when you don't know what you're talking about.

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005