Create a database backup job using SQL Server Management Studio

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

Posted via email from .NET Info