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
-- Create Demo Database
CREATE DATABASE DemoDB
-- Create a table
CREATE TABLE TestData(id int)
-- Insert sample data
INSERT INTO TestData(id) VALUES(1)
INSERT INTO TestData(id) VALUES(2)
SELECT * from DemoDB.dbo.TestData
In Object Explorer, Connect to SQL Server, Expand “SQL Server Agent” node, Expand Jobs; right click ; select menu “New Job”
-- Script to backup database
BACKUP DATABASE [DemoDB]
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\DemoDB.bak'
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm
That is very helpfu for a new user. Thank you very much
I need this tutotial...
Thank you very much!!!
why do u need to hide ur servername? how we can reach it :lol:
u forget to hide at first pic.
and the last word. ur server name is REDMOND and u will be HACKED :)))
good tutorial ty
very... very ... Help full...thanks
Thank Dear. thats very usefull for bigner
Thank you ,but I found all backup files are saved to xxx.bak folder can't be openned.so I want to delete the older backup files,how to do?
Awesome One....I was finding this from a long....Thanq
thanks, i already did this but when i try to run the job, it executes step 1 and when it had to do the actual backup of the dbase it comes with an error message that [the owner of the Backup database job does not have access to the server] I put the job owner as an administrator account.