im backing up my sql servers as follows
taking a vmdk image of the c drives
taking a file system backup of all drives except c dive excluding databases
taking a database level of all databases
this works perfect for most of my sql servers that have the master database located on the c drive as all i need to do is the following
restore vmdk which gives me back a working server with sql installed and running
the master databases as its on c drive exists and the service is started
i can then restore the file level backup whick restores and files and folder structure
then i can restore all my databases.
however i face a problem when someone has located the master database on a another drive like e drive etc
then when i restore vmdk the master datbases does not exist and sql service can not be started.
i cant restore the master databse as sql service is not started
how can i rebuild the master database ore restore it easily in a dr scenario
im using sql 2012 but have also 2008 and 2005