Create a Backup Job in SQL Server.
The basic backup syntax that you need to type is here:
BACKUP DATABASE databaseName
TO DISK = 'file location'
Now let's see a real example with all of the values filled in. Here we're going to backup the Model database to a file called ModelBackup.bak on C:\.
BACKUP DATABASE Model
TO DISK = 'c:\Rraannaammeett.bak'
1. Expand the ‘SQL Server Agent' tree
2. right-click on ‘Jobs'. Then choose the top item, ‘New Job…'
3. you've got the new job dialog box. Filling in the information. You give your job a name, and everything else. Here I'm going to fill in the name of the job as ‘Backup user database'.
4. Next click on the ‘Steps' pane on the left and you'll be presented with this screen. It's blank because you haven't created any steps yet. So go ahead and click on the ‘New' button at the bottom.
5. you have to fill in a name so you know what the step is called. Make it something descriptive. There are several step types to choose from, but the default is T-SQL and since we're running a T-SQL command that's clearly the one we want to go with. Select your Database. Here's what we have so far. You see the only thing we've had to do is fill in the step name.
6. copy your backup statement into the query window. make sure your code will parse before you try to run it. Just click the ‘Parse' button I've circled. Here's what that looks like.
7. Now click OK and it'll take you back to your new job window and now you'll see your job step listed. And you can stack as many as you like inside there.
8. To schedule your job, click on ‘Schedules' on the left and then choose the schedule that's right for you. It works similar to the the way it does in Windows so there's really not much need for me to rehash it here.
9. just you click OK all the way out until the new job box is closed, your job will be added to the job tree. You may have to right-click on ‘Jobs' and refresh the display for it to show up.
After enable your jobs you got database backup file on your destination path.