Get Estimated Backup Restore Time in SQL Server
This post contains a SQL script to get estimated completion times and process information for your currently running database backups &
Get Last Database Restore DateTimes in SQL Server
This post contains a script to help you get the last dates and times for when your databases were last restored in SQL Server.
How to Restore a Database in SQL Server
Restoring a database in SQL Server is a straightforward task, and one that SQL Database Administrators have to perform thousands of times throughout their career.
Attaching SQL Databases Without Log Files
If you’ve lost a database log file and you’re in critical need of the data, well… that would never happen ( ͡° ͜ʖ ͡°)Nevertheless, this is might be a handy random fact to know, that you can attach a data (.mdf) file without the associated log (.ldf) file in SQL Server.
Backup & Restore (WITH FILE)
In this post I’m going to show what the WITH FILE = X option does when backing-up or restoring a SQL Server database.
Restoring a SQL Server Database
This is a simple guide to restoring a full backup file in SQL Server, providing an overview of a few options that are available during the process.
Get Estimated Database Restore Time
If you’re backing up or restoring a large database in SQL Server, you can run the SQL script in this post to find out how long it has left to complete.
