var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: logtransaction backup
Sql server 7.
I have been given task to schedule transaction log backup for every six hours. Pls give me the steps as how to schedule a transaction log backup.
Waiting for reply
Uhhh with job scheduler?
That's the easy way...
with code you'll need to use system stored procedures...look them up in BOL...
sorry if i am not clear, i want to know how to take transaction log backup.
Do you have client tools installed?
Do you have Books Online?
Look up BACKUP LOG...
If you want to do it with T-SQL
You could use the DB Maint Wizard in Enterprise Manager as well...