Test environment: Windows Azure Shanghai Room, virtual machine configured for large (quad core, 7 GB memory), the disk situation is shown in the figure below.
The database backup compression file is greater than 12.0 GB (12,914,327,552 bytes), placed in temporary Storage (D:).
The database restore operation commands are as follows:
RESTORE DATABASE [Cnblogstext] from DISK = N ' D:\cnblogstext.bak ' with FILE = 1,
Move N ' Cnblogstext ' to n ' F:\DATA\CNBlogsText.mdf ',
Move N ' Cnblogstext_log ' to n ' F:\Log\CNBlogsText.ldf ', nounload, STATS = 5
That is, restore from D to disk F.
The measured recovery takes 1 hours, 44 minutes and 15 seconds.
Comparison with other cloud service providers:
April on the Ali Cloud Database restore test, when the database backup compressed files around 18G, on the virtual machine recovery takes 1 hours 16 minutes (recovery in RDS only 10 minutes), see Cloud Computing Road: Trial Aliyun RDS-10 minutes vs 1 hours 16 minutes.
Recovering about 12G of database backup compressed files on Ucloud high-performance virtual machines in August took 18 minutes and 50 seconds.
Note: This test is only for azure virtual machines, not SQL Azure,sql Azure, which is much higher than virtual machines.
See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/Servers/cloud-computing/