BACKUP LOG cannot be performed because there is no current database backup

[Najm]

Hi All,

I am facing this issue very frist time. I add a logical device as
following:

USE master

GO

EXEC sp_addumpdevice 'disk', 'AdvWorksData',

'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\BACKUP\AdvWorksData.bak'

-- Create a logical backup device, AdvWorksLog.

USE master

GO

EXEC sp_addumpdevice 'disk', 'AdvWorksLog',

'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\BACKUP\AdvWorksLog.bak'

-- Back up the full AdventureWorks database.

BACKUP DATABASE AdventureWorks TO AdvWorksData

-- Back up the AdventureWorks log.

BACKUP LOG AdventureWorks

TO AdvWorksLog

The database backup is completed successfully but log's backup fails
with the following messages:

Msg 4214, Level 16, State 1, Line 1

BACKUP LOG cannot be performed because there is no current database
backup.

Msg 3013, Level 16, State 1, Line 1

BACKUP LOG is terminating abnormally.

We are moving from SQL 2000 to SQL 2005. I have ensured that database
has full recovery mode on. We are using SQL 2005 on Windows 2003 Server
SP1.

Further more, I also created a plan to test it, and plan also fails
when backing up the logs.

Can anyone shed some light on this issue.

Thanks in advance.

Najm

[Najm]

I never mind guys. I figured out why it was happening. I had scheduled
a job previously that was running truncating the logs i.e.
truncate_only option.

All well that ends well :)