Cari Blog Ini

22 Mei 2012

Backup Database With STATS

* Show progress after every 10%


Create a full backup with progress stats
This command creates a full backup and also displays the progress of the backup. 
The default is to show progress after every 10%.

-----start code
BACKUP DATABASE HRD
TO DISK = 'D:\HRD.BAK'
WITH STATS
GO
-----end code





* Show progress after every 1%.

-----start code
BACKUP DATABASE HRD
TO DISK = 'D:\HRD_After_1.BAK'
WITH STATS = 1
GO-----end code