We have a backup from the previous week.

But thats currently not the first option. cos then we need to get the system up so that production doesnt stay offline. (critical...

Thanx for your reply

The failure doesnt happen on the restore of the full back. Full backup restores perfectly , (no recovery)

failure happenes when i am restoring a Transaction Log. i...

Please help or guide in this problme, never had this before.

While restoring all teh trasnaction logs, i came to a point on friday when the server had an unexpected...

OK solution reached.

Faulty server just rebooted itself again,

So i did not get a successful differential off the live server.

So ill go with teh normal way of restoring full, diff and...

was posted in wrong forum

Should have been under teh sql 2008 r2 forum, under dba or administration, couldnt change teh topic ?

Sorry for the inconvienience / duplication.

Sorry i think you are misunderstanding my request.

Due to time constarints,

i would like to take a diff backup on the faulty server at the same time while the new...

Thanx a million to all who helped .

You people are wonderfull.

The hacked way of attaching a suspect databases worked.

The database is still suspect , so i can put into...

I have backups for recent copies of our database.

But the copy that we had on the server which had a hardware fault was a year end version of the...

This is the reply i get

USE [master]

GO

CREATE DATABASE DBname ON

( FILENAME = N'H:\XXX.mdf')

FOR ATTACH

Result

File activation failure. The physical file name "f:\XXX.ldf" may be incorrect.

File activation failure. The physical...

sorry i posted it here, but then seen it was categorised as a performance tuning thing, so i reposted,

havent posted before here.?

Yes i have tried that.

My main posting has the results,

Thank you for your reply anyway.

Good day all.

im having the same problem.

I lost my drive due to some hardware fault.

My log files were on the faulty drive.

i do not have access to a backup...