Trial Azure: Database backup compressed file recovery speed test on virtual machine

Source: Internet
Author: User
Tags backup

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/

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.