Transaction Log Backup

[Former Member]

Hello, i have a problem to backup the Transaction log on a MS SQL Serve 2005.

I've got the following errormessage in DB13:

BACKUP LOG cannot be performed because there is no current database

backup. [SQLSTATE 42000] (Error 4214) BACKUP LOG is terminating ab

normally. [SQLSTATE 42000] (Error 3013). The step

failed.

Could anybody help me?

Regards

Herbert Heppner

[rolfc_weber · Accepted solution]

Hi,

Is this a new installation ?

If yes, you have to do at least one FULL database backup, before you can do a LOG backup.

Regards

Rolf

[Former Member · Accepted solution]

Hello Rolf, yes it is a new installation. I 've made a fullbackup three days ago. But the recovery state of the DB was 'SIMPLE'. If it is possible, the i must make a new fullbackup in recoverymode 'FULL' ?

Regards Herbert

[rolfc_weber · Accepted solution]

Yes you have to change to "FULL" recovery mode first, and do a FULL Backup.

Afterwards, you can start do LOG backup(s).

As long as the database is in "SIMPLE" you also can't make a LOG Backup.

(It does also not make sense to do so)

Regards

Rolf

[Former Member · Accepted solution]

Thank you very much for your help. I will do so.

Regards

Herbert

[clas_hortien]

Hello,

you need to have a full database backup before you can create transaction log backups, as it makes no sense to backup the T-Log when you don't have a database backup where you can apply it to.

Best regards

Clas