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”Type in name of the SQL Agent Job as “Test Backup Job”
3) Create a backup job step
Select the page “Steps”
Click on”New” to create a new job step
Type in name for job step as “Backup Job Step” and T-SQL statement to backup database
-- Script to backup database
BACKUP DATABASE [DemoDB]
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\DemoDB.bak'
0 comments:
Post a Comment