Hi all,
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.
TIA
Waiting for replyUhhh with job scheduler?
That's the easy way...
with code you'll need to use system stored procedures...look them up in BOL...
sp_Add_Job, ect|||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...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment