By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,686 Members | 1,558 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,686 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Feb 10 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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 :)

Feb 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.