sql 2005 transaction log backups

hi all

i am trying to set up a transaction log back up against one db (its in full recovery mode), i create the backup as the picture illustrates and select the db, but each time i save and close out it loses the database selection !

i cant see what i could be missing?

also if anyone has any important steps i should be following when backing up the log files - please feel free to advise! eg i have read that there is an option to ignore transactions once they are backed up - but cant see it?

cheers

mal
bkup.JPG
malraffAsked:
Who is Participating?
 
malraffAuthor Commented:
must be a bug in sql !
as despite not showing the database that i have selected the plan is still running and backing up my logs!??

even if i select view T sql from the job it shows me nothing!
0
 
dba2dbaCommented:
Did you have the DB Setup to FULL Recovery mode?

Before taking a transaction log backup, you should

1) Change the recovery model to FULL

--ALTER DATABASE DATABASE_NAME SET RECOVERY FULL
--or using GUI . Database Properties - Options - Change it to FULL

2) Take a Full Backup

You have to do this in order to be able to setup transaction log backups.

Thanks,
0
 
malraffAuthor Commented:
did you read my question :)
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
dba2dbaCommented:
Sorry, I did not read the question properly. You can try applying the latest SP/Hotfix.

THanks,
0
 
dervishiCommented:
Tryto make trn backup using sql script

Backup Log "database_name" to "filebackup.trn.
0
 
malraffAuthor Commented:
sql server bug
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.