Question : We are working on setting up AlwaysOn Availability Group for SQL Server 2014. There will be 2 nodes: […]
Tag: azure-vm
Change default collation when provisioning a SQL Server VM in the Azure portal
Question : Is there a way to change the default SQL collation directly from the “Create virtual machine” wizard in […]
Availability Group – Deleting old backup files
Question : I’m using Azure VMs with a SQL Server Availability Group, and Ola Hallengren’ scripts. Backups are working without […]
Why Azure site recovery may not meet RPO?
Question : While Azure Site Recovery may meet RTO, it may not meet RPO since it is not accounting for […]
Primary server ‘XYZ’ can not write to shared drive during availability group configuration
Question : I am in a process of adding databases to availability group. In one of the steps it was […]
PREEMPTIVE_OS_WRITEFILEGATHER wait on database RESTORE with IFI on
Question : I have an Azure VM with Windows Server 2012 R2 and SQL Server 2014 Enterprise Edition. I have […]
Transaction Log file size is increasing in my Azure (IAAS) SQL Server 2014 database [duplicate]
Question : This question already has answers here: Why Does the Transaction Log Keep Growing or Run Out of Space? […]
Moving database from one server to another
Question : I have a virtual machine running SQL Server 2012 in Azure and have also generated a script of […]
Set column to only accept negative values
Question : Is there anyway to change a column data type so that it will accept only negative values? It’s […]
Sql Server 2016 errror Incorrect syntax near ‘EXTERNAL’
Question : I have two SQL Server 2016 VMs in Azure. I am trying to connect these two sql server […]