C drive is OS drive
D drive is data drive (system and user dbs)
E drive is log drive (system and user dbs)
D drive has crashed. So sql isn't starting as master mdf file is missing.
I could have started the sql server by pointing to the backup of master mdf file, then restore msdb/model/user dbs. But all my backup files are in .bak format.
I have full and log backups of system/user dbs (.bak). How do I extract the master mdf file to startup my sql server?
Maybe restore master on a new test server, then copy that master mdf file to the original sql server. Or would it be appropritae to rebuild system dbs, and then restore master/msdb/model/user dbs?