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.
In this post I’m going to show what the WITH FILE = X option does when backing-up or restoring a SQL Server database.
This is a simple guide to restoring a full backup file in SQL Server, covering a just a few options available during so.
If you’re backing up or restoring a large database, you can run the script below to find out how long it has left to complete.