BACKUP LOG Cannot Be Performed Because There Is No Current Database Backup

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 FilesMicrosoft SQL
ServerMSSQL.1MSSQLBACKUPAdvWorksData.bak'

-- Create a logical backup device, AdvWorksLog.

USE master

GO

EXEC sp_addumpdevice 'disk', 'AdvWorksLog',

'C:Program FilesMicrosoft SQL
ServerMSSQL.1MSSQLBACKUPAdvWorksLog.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