SQL Server Management Studio can be used to create a database backup job to backup an user database. Here are the steps and User interface workflow to create a simple backup job, run the job and view results
1) Create a demo database and insert sample data using the following script.
-- Create Demo Database
CREATE DATABASE DemoDB
GO
USE DemoDB
GO
-- Create a table
CREATE TABLE TestData(id int)
GO
-- Insert sample data
INSERT INTO TestData(id) VALUES(1)
INSERT INTO TestData(id) VALUES(2)
GO
SELECT * from DemoDB.dbo.TestData
2) Create SQL Agent Job
In Object Explorer, Connect to SQL Server, Expand “SQL Server Agent” node, Expand Jobs; right click ; select menu “New Job”
Read more: SQL Server Agent Team Blog
1) Create a demo database and insert sample data using the following script.
-- Create Demo Database
CREATE DATABASE DemoDB
GO
USE DemoDB
GO
-- Create a table
CREATE TABLE TestData(id int)
GO
-- Insert sample data
INSERT INTO TestData(id) VALUES(1)
INSERT INTO TestData(id) VALUES(2)
GO
SELECT * from DemoDB.dbo.TestData
2) Create SQL Agent Job
In Object Explorer, Connect to SQL Server, Expand “SQL Server Agent” node, Expand Jobs; right click ; select menu “New Job”
Read more: SQL Server Agent Team Blog