Recover a deleted table 1

[jefs]

Hi friends !
How´ve been doing ?


I strongly need your help.
I´m managing my SQL Server in order to recover the data from a deleted table. I looked through Books Online and I followed the steps mentioned on it:

RESTORE LOG TableName
FROM BkUpFileLog
WITH NORECOVERY
go
RESTORE LOG TableName
FROM BkUpFileLog
WITH RECOVERY, stopat = '20030312 09:00:00'
go

It didn´t work and it showed the message:

Server: Msg 4306, Level 16, State 1, Line 1

The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.

Server: Msg 3013, Level 16, State 1, Line 1

RESTORE LOG is terminating abnormally.

And so, is there anybody who could help me to recover the data from my deleted table ???

Thanks in advance,
Jefs.

 

[SQLBill]

Did you start the restore by restoring a FULL Backup WITH NORECOVERY???

-SQLBill

 

[jefs]

Dear friends.

Yes, I started the restore by restoring a FULL Backup WITH NORECOVERY???

And it keeps not working properly.

I think it would be better anybody describe me all steps to recover the data from the deleted table.

Please, is there any good soul there ???

Thanks again,
Jefs.

 

[SQLBill]

RESTORE BACKUP mydb --this is your database name
FROM mydbfull --this is the backup device you use
WITH NORECOVERY
RESTORE LOG mydb --database name
FROM mydblog --backup device name
WITH RECOVERY, STOPAT = '2003-03-12 09:00:00'

Do not use GO in between the RESTOREs, GO ends the batch.

-SQLBill