Peter Whyte

Get Estimated Database Backup/Restore Example

Written by

Peter Whyte

in

Post Date:

– Last Modified:

📚My SQL Server writing continues at sqldba.blog, including the current take on backups and restores: the backup scripts hub. This page stays as-is.

When you’re waiting on a database backup or restore to complete in SQL Server, we can run the script below to get an estimated time of how long the backup has left to go –

SQL Estimated Database Restore Time

Reading the Output

We have one 5GB database here currently being backed up at the time of executing this SQL DMV script. The backup progress is at 27% and is due to complete 1 minute after the backup was initiated.

This script will also be useful for getting the full command of the currently running SQL process on your SQL Server Instance, by removing the filter (WHERE Clause) on the query.

Related

Comments

One response to “Get Estimated Database Backup/Restore Example”

  1. pete Avatar
    pete

    Script Gist > https://gist.github.com/petesql/2385ca22d7ee211b045904e34ea082c9

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Start with a guide

Three guides collect the posts by the job you are doing rather than by date.

PowerShellFiles, CSVs, the firewall, scheduled tasks WSLInstalling it, distros, files across both worlds Windows AdministrationServers, domains, DNS, the tools worth having
Looking for SQL Server?

This site started as a SQL Server blog in 2017 and the archive is still here. The new SQL Server writing, and all the scripts, moved to a site of their own.

sqldba.blogScripts, error library, wait types, SSMS
Latest posts
Browse by topic