jxycms
9/25/2017 - 11:54 PM

back up database using T-sql

back up database using T-sql

USE DatabaseName;
GO
BACKUP DATABASE DatabaseName
TO DISK = 'Z:\SQLServerBackups\DatabaseName.Bak'
   WITH FORMAT,
      MEDIANAME = 'Z_SQLServerBackups',
      NAME = 'Full Backup of DatabaseName';
GO