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 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

.

Relevant Pages

  • Re: How do you get a database into recovery mode.
    ... Your scenario is basically the traditional scenario, but you introduce some foreign backup technology for the database backup instead of SQL Server's own backup. ... you need to work out how you revert to such a snapshot with the same functionality as the TSQL NORECOVERY option (database being in restoring state). ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Enterprise Manager Newbie Question
    ... a SQL backup is not a simple copy of the database files. ... Is it possible to write a script that one could run from a workstation and ...
    (microsoft.public.sqlserver.tools)
  • Re: Does NTBackup backup SQL Express?
    ... schedule backups of the SQL databases which were written to a backup ... models you would have to backup and flush things manually. ... if you load the backup set does the database appear to be ... I've always scripted my SQL Server backups separatly. ...
    (microsoft.public.windows.server.sbs)
  • Re: Does NTBackup backup SQL Express?
    ... as I know enough that the logs must be flushed during every full backup. ... and the SBS server I regularly use runs MySQL not SQL ... if you load the backup set does the database appear to be listed ... I've always scripted my SQL Server backups separatly. ...
    (microsoft.public.windows.server.sbs)