Backup job scheduling

Question

Backup job scheduling

Anil Kolla

SSC Veteran

Points: 215
More actions
November 23, 2011 at 10:28 am

#246742

Hi
I am Anil Kolla, basically a Oracle DBA. Could you please assist me, How to schedule a job for Backup in SQL server db?

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

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

Richard Moore-400646 SSCrazy Points: 2384 More actions · Answer 1

If you're not familiar with SQL, the easiest way would be to create a maintenance plan using the wizard. The wizard will basically walk you through the whole process as well as create the necessary scheduled job.

yoursuccessforever Newbie Points: 3 More actions · Answer 2

you can use this blog to create maintenance plan

http://www.pavlovit.com/sqlblog.php

Anil Kolla SSC Veteran Points: 215 More actions · Answer 3

Hi

Thing is I need to schedule a job so that, backing is done every day at 5:00pm. I can write a stored proc for this. But doesn't know how to execute it in server db.

Thank you

Anil Kolla.

Randy Doub SSCertifiable Points: 5322 More actions · Answer 4

Create a job in the SQL Server Agent. The Agent is a job scheduler.