Periodic Backup using script and task scheduler

Question

Periodic Backup using script and task scheduler

alhayalara

SSC Veteran

Points: 244
More actions
June 21, 2010 at 3:13 am

#387190

till now we have been doing backups by way of the SQL server management of back up task.
We explored running backups by scripting the backup and were successful. However this still does not give us the ability to do periodic backup without human intervention.
We are now attempting/learning to do back up by way of task scheduler running the script on a periodic schedule. Can anyone shed light on this. THANKS.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 1

Are you looking for something in particular? There are probably a hundred "how-to" articles on setting up a basic backup schedule just here on SSC alone, and most of them are decent. Are there particular areas of backups you're concerened about or odd requirements that you don't know how to meet? Otherwise, take a look at one of the standard articles & follow the directions. You'll get to where you need to go.

Here's a search that brings up a series of great scripts, blog entries and articles on the exact topic.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Lowell SSC Guru Points: 323546 More actions · Answer 2

the recommended way is to take your script, which you already know works, and use SQL Agent to create a job from within SSMS, which runs on a regular basis.

while you can do basically the same thing with Windows Scheduled Tasks, SQL has the agent built in for exactly this type of purpose.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

alhayalara SSC Veteran Points: 244 More actions · Answer 3

Thank you guys for your tips. Will look into them and hope we can come up with one that meets our need.