In this tutorial I will walk you through performing a restore of my SQL server running Windows 2008 R2 with StorageCraft ShadowProtect. I will be restoring this server into a new virtual machine.
I will be using the ShadowProtect Recovery Environment CD version 2.1.1 x64 to perform the restore.
1. Boot the virtual machine from CD/DVD and make sure you have the StorageCraft Recovery Environment CD mounted.
2. The StorageCraft Recovery Environment will start to load.
3. I will select English for the language and click Ok.
4. click on the Disk Map and select the first hard disk. Right click and select Disk Utility.
5. Click on Format Drive and select Master Boot Record. Click format.
6. Click on Format when asked if you are sure you want to format the drive.
7. I will create a partition of 106MB for the Windows System Reserve, type will be NTFS and you can give the partition a name. Click Create.
8. The partition is created.
9. Right click the free space within hard disk 1 and click on Create Partition. I will allocate the remaining size, select NTFS as the type and you can optionally give the partition a name. Click Create.
10. Now our hard drive is partitioned correctly we can start to restore.
11. Close this window and make sure you are on the Disk Map tab. Right click the first 105MB partition and select Restore Volume.
12. The Restore wizard starts. Click the hard drive icon above the Name window.
13. I will add the hard drive with the label backups as this is where my images are located. Click Ok.
14. Browse to the System Reserved backup image that you wish to restore and click Next.
15. This window will list the image dependencies. Click Next.
16. Select the 105MB partition and click Finish. The restore will begin.
17. If you click on the tasks tab you can see the restore running and also when it completes.
18. Once the restore finishes you will return to this screen. Double click on the SCRE icon.
19. Now we will repeat the same steps for the second partition. Right click on the 42.8Gb partition and click Restore Volume.
20. Browse to the backup images you wish to restore from. This partition had a backup file name starting with C_VOL-b001*.spi. Select the date and time you wish to restore form. Click Next.
21. This window will list the dependencies. Click Next.
22. Select the 42.8GB partition and click Finish to begin the restore.
23. Clicking on the Tasks tab you can see the restore job status.
24. The restore job is now complete. Click on the file menu and select exit.
25. Select Restart or Shut Down. Make sure you unmount the StorageCraft Receovery Environment CD.
26. Windows will now begin to boot. You will most likely receive this message that Windows did not shut down successfully. Select Start Windows Normally.
27. Press CTRL ALT DELETE and log onto the server.
28. You will most likely also receive the unexpectedly shutdown window. Type a comment and click Ok.
29. I will open up my Microsoft SQL Server Management Studio and just make sure all my databases are mounted and everything is working correctly.
30. My Windows 2008 R2 with SQL Server is now restored and fully functioning.
If you have any technical questions about this tutorial or any other tutorials on this site, please open a new thread in the forums and the community will be able to help you out.
Disclaimer: All the tutorials included on this site are performed in a lab environment to simulate a real world production scenario. As everything is done to provide the most accurate steps to date, we take no responsibility if you implement any of these steps in a production environment.