Reply To: How to schedule a SQL Server backup?

Stephen West ~ Modified: September 30th, 2015 ~ ~ 1 Minute Reading

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

Moderator

Karma: 4 pts

use the following query:

BACKUP DATABASE [AdventureWorks2012] 
TO DISK = N'F:\Backup\AW12.bak' 
WITH CHECKSUM;