简化SQL Server备份和还原到Windows Azure-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

简化SQL Server备份和还原到Windows Azure

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 05:54 PM

sql serverbackupreduction

SQL Server 2012 SP1 Cumulative Update 2有一项新功能，可以简化当从户内平台SQL Server到 Windows Azure 时的SQL Server 数据库备份和还原能力。现在，您可以直接使用 SQL Server Native Backup创建备份到Windows Azure Storage。请参阅下面的内容来获得新

SQL Server 2012 SP1 Cumulative Update 2有一项新功能，可以简化当从户内平台SQL Server到 Windows Azure 时的SQL Server 备份和还原能力。现在，您可以直接使用 SQL Server Native Backup创建备份到Windows Azure Storage。请参阅下面的内容来获得新功能的简介，点击链接了解详细。

要更新，请转到。

概述：

除了硬盘和磁带，现在您可以使用 SQL Server 的本机备份功能来备份您的 SQL Server Database到 Windows Azure Blob 存储服务。在此版本中，您可以使用 T-SQL 和SMO备份到Windows Azure Blob存储。在SQL Server 户内实例上的SQL Server Databases或在宿主环境中，如运行在 Windows Azure VMs上的 SQL Server 实例都可以利用此功能。

好处：

灵活、可靠和无限的线下存储来提高灾难恢复：将您的备份存储在 Windows Azure Blob 服务上是一种方便、灵活且易于访问线下的选择。创建您的 SQL Server 备份的线下存储就像修改您现有的脚本/作业一样容易。线下存储通常距正式数据库的位置足够远，以防止单一的灾难可能会把线下和正式数据库的位置都影响到。您还可以还原备份到运行在 Windows Azure Virtual Machine上的SQL Server Instance，用于户内数据库的灾难恢复。万一灾难发生了，选择geo replicate Blob存储，将产生一个额外的保护层，该保护层可以影响整个区域。另外，随时随地您都可以很容易地读取备份来进行恢复。
备份存档： Windows Azure Blob Storage服务提供了更好的一个办法为那些经常使用磁带来存档备份的用户。磁带存储可能需要物理上传输到一个外部设施并且还要保护这些媒体不受破坏。在 Windows Azure Blob Storage上存储备份为您提供了一种即时、高度可用和持久的存档方法。
没有硬件管理的开销：使用Windows Azure存储服务就没有了硬件的管理开销。Windows Azure 服务管理硬件，并为geo-replication保证冗余度和提供针对硬件故障的保护。
目前，通过创建附带的磁盘就可以将运行在 Windows Azure Virtual Machine的 SQL Server 实例备份到 Windows Azure Blob 存储服务上。然而，可以附加到 Windows Azure 虚拟机的磁盘数量是有限制的。最大实例不超过16 个。如果直接备份到 Windows Azure Blob Storage，可以不拘于最大16 个磁盘的限制。
此外，存储在 Windows Azure Blob 存储服务中的备份文件可以直接提供给户内 SQL Server或其他运行在 Windows Azure Virtual Machine上的SQL Server，不需要数据库连接/分离或下载再附加 VHD的操作了。
成本效益：只需支付所用的服务。是线下备份存档节省成本的一种方法。

Windows Azure pricing calculator可以帮助您估计成本。

存储：收费会依据您使用的空间，的数量和冗余级别而定价。

数据传输：入站数据传输到 Windows Azure是免费的。出站传输根据带宽使用情况，并根据累进特定区域的量而收费。

它是如何工作的：

备份到 Windows Azure Storage设计得像一个备份设备（磁盘/磁带）。使用 Microsoft Virtual Backup Device Interface (VDI)，Windows Azure Blob存储被编码成"虚拟备份设备"，用于访问 Blob 存储的 URL 格式则被视为一种设备。支持 Azure 存储作为目标设备的主要原因是它提供了一致和天衣无缝的的备份和还原的过程，类似于我们现在的磁盘和磁带。

当备份或还原过程被调用，并指定 Windows Azure Blob 存储使用 URL"设备类型"时，引擎就会调用VDI 客户端进程，这也是该特征的一部分。备份数据被发送到 VDI 客户端进程，并再被发送到 Windows Azure Blob 存储。

如上所述，URL 像我们现在使用的备份设备一样，但它并不是一个物理设备，所以有一些限制。

如何使用它

要写一个Windows Azure Blob 存储的备份，您必须首先创建一个 Windows Azure Storage帐户，再创建一个 SQL Server Credential保存存储帐户的身份验证信息。使用TRANSACT-SQL 或SMO就可以发出备份和还原命令了。

下面的 TRANSACT-SQL 示例介绍了创建凭据、做完整的数据库备份和从完整数据库备份还原数据库的过程。

创建凭据

下面的示例演示了如何创建一个存储 Windows Azure Storage身份验证信息的凭据。

备份完整的数据库

下面的示例演示了如何备份 AdventureWorks2012 数据库到 Windows Azure Blob 存储服务上。

还原数据库

若要还原完整的数据库备份，请按以下步骤操作。

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Explain the InnoDB Buffer Pool and its importance for performance.Apr 19, 2025 am 12:24 AM

InnoDBBufferPool reduces disk I/O by caching data and indexing pages, improving database performance. Its working principle includes: 1. Data reading: Read data from BufferPool; 2. Data writing: After modifying the data, write to BufferPool and refresh it to disk regularly; 3. Cache management: Use the LRU algorithm to manage cache pages; 4. Reading mechanism: Load adjacent data pages in advance. By sizing the BufferPool and using multiple instances, database performance can be optimized.

MySQL vs. Other Programming Languages: A ComparisonApr 19, 2025 am 12:22 AM

Compared with other programming languages, MySQL is mainly used to store and manage data, while other languages such as Python, Java, and C are used for logical processing and application development. MySQL is known for its high performance, scalability and cross-platform support, suitable for data management needs, while other languages have advantages in their respective fields such as data analytics, enterprise applications, and system programming.

Learning MySQL: A Step-by-Step Guide for New UsersApr 19, 2025 am 12:19 AM

MySQL is worth learning because it is a powerful open source database management system suitable for data storage, management and analysis. 1) MySQL is a relational database that uses SQL to operate data and is suitable for structured data management. 2) The SQL language is the key to interacting with MySQL and supports CRUD operations. 3) The working principle of MySQL includes client/server architecture, storage engine and query optimizer. 4) Basic usage includes creating databases and tables, and advanced usage involves joining tables using JOIN. 5) Common errors include syntax errors and permission issues, and debugging skills include checking syntax and using EXPLAIN commands. 6) Performance optimization involves the use of indexes, optimization of SQL statements and regular maintenance of databases.

MySQL: Essential Skills for Beginners to MasterApr 18, 2025 am 12:24 AM

MySQL is suitable for beginners to learn database skills. 1. Install MySQL server and client tools. 2. Understand basic SQL queries, such as SELECT. 3. Master data operations: create tables, insert, update, and delete data. 4. Learn advanced skills: subquery and window functions. 5. Debugging and optimization: Check syntax, use indexes, avoid SELECT*, and use LIMIT.

MySQL: Structured Data and Relational DatabasesApr 18, 2025 am 12:22 AM

MySQL efficiently manages structured data through table structure and SQL query, and implements inter-table relationships through foreign keys. 1. Define the data format and type when creating a table. 2. Use foreign keys to establish relationships between tables. 3. Improve performance through indexing and query optimization. 4. Regularly backup and monitor databases to ensure data security and performance optimization.

MySQL: Key Features and Capabilities ExplainedApr 18, 2025 am 12:17 AM

MySQL is an open source relational database management system that is widely used in Web development. Its key features include: 1. Supports multiple storage engines, such as InnoDB and MyISAM, suitable for different scenarios; 2. Provides master-slave replication functions to facilitate load balancing and data backup; 3. Improve query efficiency through query optimization and index use.

The Purpose of SQL: Interacting with MySQL DatabasesApr 18, 2025 am 12:12 AM

SQL is used to interact with MySQL database to realize data addition, deletion, modification, inspection and database design. 1) SQL performs data operations through SELECT, INSERT, UPDATE, DELETE statements; 2) Use CREATE, ALTER, DROP statements for database design and management; 3) Complex queries and data analysis are implemented through SQL to improve business decision-making efficiency.

MySQL for Beginners: Getting Started with Database ManagementApr 18, 2025 am 12:10 AM

The basic operations of MySQL include creating databases, tables, and using SQL to perform CRUD operations on data. 1. Create a database: CREATEDATABASEmy_first_db; 2. Create a table: CREATETABLEbooks(idINTAUTO_INCREMENTPRIMARYKEY, titleVARCHAR(100)NOTNULL, authorVARCHAR(100)NOTNULL, published_yearINT); 3. Insert data: INSERTINTObooks(title, author, published_year)VA

See all articles