11 December 2012

Database Backup Query


USE DBName
GO
BACKUP DATABASE DBName
TO DISK = 'E:\Back up\AdventureWorks2012.Bak'
   WITH FORMAT,
      MEDIANAME = 'Z_SQLServerBackups',
      NAME = 'Full Backup of AdventureWorks2012';
GO