How to schedule a SQL Server backup?

Andrew Jackson ~ Modified: September 11th, 2015 ~ ~ 1 Minute Reading

This topic has 2 replies, 3 voices, and was last updated 9 years, 1 month ago by Stephen West.

Viewing 3 posts - 1 through 3 (of 3 total)

Author

Posts
September 11, 2015 at 12:57 pm #637 Score: 0

Andrew Jackson
Moderator

Karma: 1 pt

I am trying to schedule a daily back up of a SQL Server 2005/2008 Database.

Can somebody please suggest me any recommendations on that.

September 12, 2015 at 1:04 pm #642 Score: 0

Lincoln Burrows
Moderator

Karma: 16 pts

Open database backup window then click on script link on top left select “script action to job” then choose schedule and eneter the parameters and sav then it will create a database schedule that will automatically create a backup of thee specified databse

September 30, 2015 at 9:26 am #768 Score: 0
Stephen West
Moderator

Karma: 4 pts
use the following query:
```
BACKUP DATABASE [AdventureWorks2012] 
TO DISK = N'F:\Backup\AW12.bak' 
WITH CHECKSUM;
```
Author

Posts

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.