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