I am trying to take transaction log backup using following query -
BACKUP LOG [Test] TO
DISK = N'X:\Backup\TestLog.trn'
WITH NOFORMAT, NOINIT, NAME = N'TestLog',
SKIP, REWIND, NOUNLOAD, STATS = 10
But it gives me error -
Msg 3049, Level 16, State 1, Line 1
BACKUP detected corruption in the database log. Check the errorlog for more information.
Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.
I am using sqlserver 2008. How can i fix this?
thanks in advance,