Tag Archives: windows azure

How to set up Cloud-based Storage for SQL Server Backup

A central tenet of Disaster Recovery (DR) is that you should always maintain an offsite or off-premises copy of your critical database backups. The logic behind this is simple – if you don’t have access to your premises, for example in case of a natural disaster affecting your area, your offsite backups mean that you can restore them and still have access to your critical data. Let’s take a more in-depth look at cloud-based storage for your SQL Server backups. Continue reading How to set up Cloud-based Storage for SQL Server Backup

How to save SQL Server backups to Azure in SQLBackupAndFTP

Microsoft’s own Windows Azure cloud is one of the most popular backup options for storage of SQL Server backups. It is especially attractive as an offsite storage medium for SQL Server backups because it is a Microsoft product and is already has tie-ins with the latest versions of SQL Server, beginning with 2012 Service Pack 1, Cumulative Update 2. Let’s take a closer look at how to save your SQL Server backups to Azure. Continue reading How to save SQL Server backups to Azure in SQLBackupAndFTP

Client with IP not allowed access-Azure SQL error

Connect to Azure SQL error-Client with IP not allowed access

Client with IP not allowed access” is not a very common error, but still it does not let you do your job.
Sometimes when using SQLBackupAndFTP you might encounter an error saying that you cannot connect to your Azure SQL Database.
The error looks like: “Cannot open ‘<server>’ requested by the login. Client with IP address ‘<ip-address>’ is not allowed to access the server” 

Continue reading Client with IP not allowed access-Azure SQL error