Friday, September 14, 2012

SQL SERVER – How to see how much percent of backup has been completed while taking backup

SQL SERVER – How to see how much percent of backup has been completed while taking backup

There is simple command to get the level of percentage of backup in SQL SERVER.
When we have to take backup of big database at that time we can add the STATS option and can see the percentage of running backup

-- Creating test backup
CREATE DATABASE TESTDB
GO
--creating test table
CREATE TABLE TEST_TABLE (ID INT)
GO
-- Taking bacup with STATS option
BACKUP DATABASE TESTDB  TO DISK= 'C:\TESTDB.BAK' WITH STATS =10
GO


Like and Share to SQL Integrity Blog

No comments:

Post a Comment

Thank You !!!!