malraff
asked on
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
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
ASKER
did you read my question :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry, I did not read the question properly. You can try applying the latest SP/Hotfix.
THanks,
THanks,
Tryto make trn backup using sql script
Backup Log "database_name" to "filebackup.trn.
Backup Log "database_name" to "filebackup.trn.
ASKER
sql server bug
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,