Full backup of SQL Server

Question

Post reply

Full backup of SQL Server

Saggy

SSCrazy

Points: 2003
More actions
December 24, 2011 at 1:25 am

#253928

Hi guys...
When we take backup of 400 GB so how should we know that how much percentage of backup is completed ? via command or something?
Reply ........thnx

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

salum SSCommitted Points: 1598 More actions · Answer 1

To see how much percentage of your backup is done , you can use this.

Find out SPID and pass it here

select percent_complete

from sys.dm_exec_requests

where session_id = 74

java[/url]

wayfarer SSC Enthusiast Points: 109 More actions · Answer 2

could you please be more specific? Are you taking the backup interactively? Or, is this a job, and you are wondering how long it will take?

If you want to know the status when you are taking a backup, you can use commands for example

-------------

backup database database_name to disk = 'path of drive'

with stats=10

-----------------

with stats is what returns your status for every 10%. you can change it to 20, and it returns when each 20% is complete.

I wouldn't recommending going as low as 5 or 1, because SQL has to return the status that often..

Not sure if that was what you were looking for. I think you can do stats from the GUI too.

So if it is a nightly job, that you wanted the status of - one of the ways, is to look at the history of the job to get a guess. (But, since you said one database, I was assuming, you wanted to know stats of when you take the backup manually.) 😀

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 3

I think you can do stats from the GUI too.

GUI shows the progress by default.

Per BOL:

STATS [ =percentage ]

Displays a message each time another percentage completes, and is used to gauge progress. If percentage is omitted, SQL Server displays a message after each 10 percent is completed.

For More:

http://msdn.microsoft.com/en-us/library/ms186865.aspx