Windows

  You have defined a share on a remote server, and you cannot authorize the SQL Server service account on that share. You just have …

When you want to back up your database, you may see “Cannot open backup device” error as you see in the picture below. To resolve …

  In this article I will tell you how to add the MS DTC service to the windows cluster. First, we open Disk Management. You …

  In this article We create a share on a server and then we map this share on a server. I selected MSSQL as Category. …

  When creating a SQL Login, you can select the Enforce Password Policy option as described in my article “How To Create a Login On …

  After SQL Server Setup has been performed, it is necessary to make some settings in Security Policy in Windows for the performance of SQL …

  We use letters like C, D, E when defining disks on “Windows Server”. If the number of our disks increases, we may not be …

  SQL Server Configuration Manager is a tool in which many settings of SQL Server are made. In this article, I’ll refer to many of …

  Most DBA usually define the SQL Server Service Account as the Administrator on the server. Actually, this authority is not necessary. You must not …

You may want to move a database containing “File Stream” data to another disk with the detach attach method. Moving a database containing “File Stream” …