December 21, 2007 at 12:20 am
hi ,
whn i try to restore data it raises error.
the below statements i tryed but it displays errors
begin transaction sample
delete from tt_performance_rep
commit transaction sample
backup log eds to disk='d:\eds_21_1248.bak'
use master
restore database eds from disk='d:\full_bak\eds_21_1215.bak'
with norecovery
after that it rasies error like this
Msg 3159, Level 16, State 1, Line 1
The tail of the log for the database "eds" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
pls clarify my small doubt.
thanks & regards
kumarp
December 26, 2007 at 2:46 pm
You need to specify WITH NO_TRUNCATE. Otherwise the log will be truncated.
December 26, 2007 at 2:47 pm
Once you complete the tlog backup, you have to restore the full backup and the tlog backup.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply