Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

My name is aSkywalker and I am an involuntary DBA.

I have done some research, and would like to back up transaction logs every 10 minutes.

I have written some powershell scripts to compress, encrypt and shuffle the files around. I have created a maintenance plan to backup the Transaction log, then run the powershell script. (thanks to some great help from serverfault and stackoverflow!)

Now, I can see how to schedule it daily at a specific time. I can create subplans and schedule away. But I don't see a simple way to say 'every 10 minutes', and I don't want to start manually creating 144 subplans. Or do I have to?

share|improve this question

1 Answer 1

up vote 4 down vote accepted

Are you using SQL Server Management Studio to schedule this as a SQL Agent job?

When you're setting the job's job schedule properties, use the "Occurs Every" radio option in the Daily Frequency section. Change it to every 10 minutes with a start time of midnight and an end time of 11:59 PM. That ought to do what you're after.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.