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
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …