SQL SERVER MANAGEMENT STUDIO 17 CREATE FULL
On the Security tab, grant full control access to the SQL Server service account.Right-click the folder and select Properties.Create a folder (or multiple folders) to be used for your log file.You can do so by using SQL Server Configuration Manager or Services.msc. Verify the service account used by SQL Server.The account used for the SQL Server service account must have full control of the new log file location. You can do so using Transact-SQL (T-SQL) or SQL Server Management Studio (SSMS). Use Disk Management to format and partition your newly attached ultra disk.Ĭonfigure SQL Server to use the new log drive.Connect to your VM by using Remote Desktop Protocol (RDP).To format your ultra disk, follow these steps: Format diskĬonnect to your virtual machine and format your ultra disk. Once the disk is attached, start your VM once more using the Azure portal. Use the Azure portal to attach an ultra disk to your virtual machine. :::image type="content" source="./././virtual-machines/media/virtual-machines-disks-getting-started-ultra-ssd/enable-ultra-disks-existing-vm.png" alt-text="Screenshot that shows the Yes option."::: Select Yes to Enable Ultra disk compatibility. :::image type="content" source="media/storage-migrate-to-ultradisk/additional-disks-settings-azure-portal.png" alt-text="Select additional settings for Disks under Settings in the Azure portal"::: Select Disks under Settings and then select Additional settings. Go to your virtual machine in the Azure portal. To enable compatibility, follow these steps: You can determine and validate VM size and region using the Azure CLI or PowerShell. Before proceeding, validate that your VM is in a region, zone, and size that supports ultra disk. Ultra disk is supported on a subset of VM sizes and regions. Attach diskĪttach the Ultra SSD to your virtual machine once you have enabled ultradisk compatibility on the VM. Back up databaseĬomplete a full backup up of your database.
![sql server management studio 17 create sql server management studio 17 create](https://www.codeproject.com/KB/database/1243356/image12.png)
This article teaches you to migrate your log disk to an ultra SSD to take advantage of the performance benefits offered by ultra disks. Azure ultra disks deliver high throughput, high IOPS, and consistently low latency disk storage for SQL Server on Azure Virtual Machine (VM).