Posted by Najm on 09/29/57 11:39

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

• Next in forum: Re: one for the SQL experts - dare I say TRICKY SQL!
• Prev in forum: Re: Views vs Stored Procedures, whats the difference?
• Thread view: BACKUP LOG cannot be performed because there is no current database backup

[Reply to this message]