Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

SQL 2005 SCHEDULED BACKUP?

I am new to sql, and am attempting to learn how to schedule a backup. When I right click on the database and choose backup, I do not get the schedule option at the top like I see in a lot of examples or as the books explain. Can someone tell me why I do not have this option available? Do I need something else running to enable this option?
0
phil301
Asked:
phil301
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Hi phil301,
for this pupose u need to create a job. Read the following article
http://www.sqlservercentral.com/columnists/phe/sqlserverjobscheduling.asp

Cheers!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now