Click here to be directed to Microsoft’s SQL Server Blog
Azure SQL, General, Microsoft SQL Server, SQL 2022 / Comments Off on Microsoft SQL Server Blog
Azure SQL, Microsoft SQL Server / Comments Off on SQL Server 2022 Preview Videos
Azure SQL, Microsoft SQL Server / Comments Off on SQL Server 2022
Azure SQL / Comments Off on Microsoft SQL Server 2022
Microsoft, Microsoft SQL Server, SQL 2019, SQLServerCluster, Windows Server 2016 / Comments Off on Field Notes: Move of cluster role ‘SQL Server (A)’ for drain could not be completed. The operation failed with error code 0x138D
This error below comes up each time l tried to failover a SQL Role/Instance (A) to Node2 from Node1, in a 2 node SQL Server 2019 Cluster, running on Windows Server 2016.
“Move of cluster role ‘SQL Server (A)’ for drain could not be completed. The operation failed with error code 0x138D”
Issue turned out to be SQL Role A’s CEIP service was inadvertently only checked/enabled for one of the Nodes it always sticks to Node1 as shown below.
For comparison l looked at a SQL Role (B) with similar services.
Checking both nodes and clicking apply, then stop and restart the role, resolved this.
Microsoft SQL Server, SQL 2017, SQL 2019, SQLServerCluster, Windows Server 2016 / Comments Off on SQL Cluster issue: Msg 5184, Level 16, State 2, Line 1
Got this error message while completing moving SQL SAN Storage drives. The SQL instance came up online ok, and was accessible from SSMS, but each time l tried to create a test database – l got the error below.
Cannot use file ‘U:\MSSQL13.xxxxxxx\MSSQL\DATA\yyyyyy.mdf’ for clustered server.
Only formatted files on which the cluster resource of the server has a dependency can be used.
Either the disk resource containing the file is not present in the cluster group
or the cluster resource of the Sql Server does not have a dependency on it.
Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
- Go to the FCM – failover cluster manager
- Click on the SQL Server Role
- Click on the resouces tab below
- Right click on the “other resources” – line showing the SQL Server role/instance.
- Re-insert the new SAN drives to this role as shown below
- Click apply.
- In my case, no restart was needed
General, Hyper-V, Microsoft, Microsoft SQL Server, SQL 2019, Ubuntu / Comments Off on Install SQL Server 2019 on Ubuntu 20.04 VM on Hyper-V
Installation of Microsoft SQL Server 2019 developer edition on a virtual machine [VM] running Ubuntu 20.04 [linux] on Hyper-V.
Specifications of the VM:
- Hard disk 47Gb
- Processors: 2 Virtual processors
- RAM: 4Gb – 8Gb [Dynamic]
class=”alignnone size-full wp-image-931″ src=”https://sqlmint.com/wp-content/uploads/2021/10/Capture_Ubuntu_SQL04.png” alt=”” width=”1031″ height=”489″ />
class=”alignnone size-full wp-image-930″ src=”https://sqlmint.com/wp-content/uploads/2021/10/Capture_Ubuntu_SQL05.png” alt=”” width=”1023″ height=”760″ />
Reference documentation from Microsoft – click here.
From SSMS running on a Windows 10 workstation, l had no problems connecting to the server.
Azure SQL, General, Microsoft, Microsoft SQL Server / Comments Off on SQL Server Download Links
SQL Server download links – click here
Azure SQL, Microsoft, Microsoft SQL Server / Comments Off on Create Azure SQL Database
Create a Microsoft Azure SQL Database in screenshots guide.