Archive

Archive for the ‘SQL’ Category

Microsoft® SQL Server® Backup to Microsoft Windows® Azure®Tool

October 16, 2013 Leave a comment

Microsoft SQL Server Backup to Windows Azure Tool enables backup to Windows Azure Blob Storage and encrypts and compresses SQL Server backups stored locally or in the cloud.

SQL Server 2012 and SQL Server 2014 have built in capability to back up to Windows Azure storage. The SQL Server Backup to Windows Azure tool provides the same functionality to previous versions of SQL Server. It can also be used to specify encryption and compression for your backups.

Using the 3-step wizard, you can specify a rule or set of rules that are applied to any SQL Server backup. One example of a rule could be to redirect all local backups to the specified Windows Azure storage. Another example of a rule would be to use compression or encryption for backups stored in a specific location.

Once you configure the rules, these rules are applied to SQL Server Backup files. If the rule is set to use Windows Azure storage account, the tool redirects the backups to the specified Windows Azure storage account, but leaves a stub file with metadata information to be used during restore.

Benefits:

· Support for backups to Windows Azure Storage for SQL Server versions that do not have the built-in capability. Using Windows Azure storage for your backups has several benefits off-site storage for disaster recovery, ability to access from any location, etc. For more information, see SQL Server Backup and Restore with Windows Azure.

· Encryption and Compress support for SQL Server versions that do not have the built in capability. Currently only SQL Server 2014 has encryption support, and SQL Server 2008 or later support compression during backup. SQL Server 2008 supports compression in Enterprise edition only, but for SQL Server 2008 R2 and later encryption is supported on Standard editions or higher.

 

Download from there

http://www.microsoft.com/en-us/download/details.aspx?id=40740

Advertisements
Categories: Azure, SQL

Is Hyper-V Dynamic Memory supported for SQL Server?

February 24, 2011 1 comment

Simply YES

Q7: Is Hyper-V Dynamic Memory supported for SQL Server?

A7: Hyper-V Dynamic Memory is fully supported with SQL Server. Only SQL Server versions and editions (Enterprise and Datacenter) that support Hot Add Memory can see memory that is added by using Hyper-V Dynamic Memory. SQL Server versions that do not support Hot Add Memory are still supported. But these versions will detect only the memory that is present in the operating system when SQL Server starts. Before you deploy Hyper-V Dynamic Memory, please read the following resources when you use Hyper-V Dynamic Memory with SQL Server:

SCVMM reports error 10637 when Red Hat Linux selected as the Operating System

April 3, 2010 3 comments

Source

A new KB article regarding Red Hat is being posted on Microsoft Support any day now. For those of you who do not need the official KB, here’s the content. This is a relatively minor fix. If you are not a SQL expert, find one, or just follow the simple instructions for the free SQL Studio Express Edition. Thanks!

URL when published http://support.microsoft.com/kb/2022557.

Symptoms

On System Center Virtual Machine Manager 2008 R2, it is possible to select Red Hat as the virtual machine ‘Operating System’ property for a virtual machine hosted by Hyper-V. The job, however, will show as failed with Error 10637. This can occur when creating a new virtual machine or changing this property on an existing VM. This does not affect the function or stability of the virtual machine itself. This property is found on the General tab of the virtual machine properties dialog.

Error (10637)

The virtualization software on host server.contoso.com does not support the Red Hat Enterprise Linux 5 operating system.

Recommended Action

Specify a host with different virtualization software and then try the operation again.

Cause

A database entry that identifies the list of supported virtual machine operating systems per hypervisor requires an update. The following actions will remain unavailable for Red Hat virtual machines in SCVMM following this update:

  • Shut down of the guest operating system from the SCVMM Administrator Console
  • Detection and display of the VM Additions version for a virtual machine in the SCVMM Administrator Console and with Windows PowerShell
  • Display of the computer name of the guest operating system
Resolution

Using SQL Server Management Studio Express, or a full SQL installation, make a full backup of the SCVMM database. Next, connect to the SCVMM database (VirtualManagerDB by default). Open a new query and enter the commands below. The number of affected columns will be returned in the ‘Messages’ window if present.

update tbl_IL_OS

set OSFlags=0x14

where Name like ‘Red Hat Enterprise Linux 5%’

Microsoft SQL Server 2008 RTM

Microsoft Corp. today announced the release to manufacturing of Microsoft SQL Server 2008, the new version of the company’s acclaimed data management and business intelligence platform. This version of SQL Server provides powerful new capabilities such as support for policy-based management, auditing, large-scale data warehousing, geospatial data, and advanced reporting and analysis services. SQL Server 2008 provides the trusted, productive and intelligent platform necessary for business-critical applications.

 

With more than 450,000 customer and partner downloads of SQL Server 2008’s community technology previews (CTPs), more than 75 large-scale applications already in production and more than 1,350 applications being developed by nearly 1,000 independent software vendors (ISVs) on SQL Server 2008, it’s clear that customers and partners are excited about the capabilities now available in SQL Server 2008.

 

For more information please check out the Press Release and Virtual Press Room.

Categories: SQL
%d bloggers like this: