Post reply

sql server agent job

  • August 20, 2008 at 2:57 am

    #130770

    Hi all,

    Can anybody give me an example or a link to an example of how to create SQL server agent backup jobs using SSMS?

    Thanks indeed

    Niyala

  • August 20, 2008 at 4:18 am

    #860511

    Hi,

    Right click the database you want to back up, select Tasks, then Back Up. Enter all the details on the General and Options tabs then click the Script button and choose Script Action to Job. Complete the job details and schedule it and you're done.

    Cath

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

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