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...
Showing posts with label logtransaction. Show all posts
Showing posts with label logtransaction. Show all posts
Monday, March 26, 2012
logtransaction backup
Subscribe to:
Posts (Atom)