This is a simple guide to restoring a full backup file in SQL Server, covering a just a few options available during so. As always, have a read through Microsoft’s documentation page before-hand for proper info. 1. Open SSMS and connect to your SQL Server. 2. Right click Databases and select Restore Database. 3. Select […]
If you’re restoring a large database, you can find an estimate of how long it’s going to take by running the script below. [crayon-5bee31092814b163334794/] As a quick alternative, you can also use sp_whoisactive to gain a rough idea of progress by viewing the percent_complete column.