How do I schedule a backup SQL Server 2005


I knwo how to do a backup task with sql server 2005. How do I schedule it run every night at a specific time?

Charles BaldoSoftware DeveloperAsked:
Who is Participating?
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
you can schedule a job for this,
from sql server management studio -> object exploretr -> right click on SQL Server Agent and click "Start" if it has a Red mark

under that you can see Jobs -> right click -> new Job and enter the details and schedule it
Charles BaldoSoftware DeveloperAuthor Commented:

I am sorry I just dont see it.
I can opposite mouse click on the database and choose a backup task and execute it manually.

However when I go to SQL server agent just dont wuite see how to schedule that backup as an agent.
Charles BaldoSoftware DeveloperAuthor Commented:
I figured it out, I just had to generate a script. Thought there should have been a category and a specific task.

All Courses

From novice to tech pro — start learning today.