How to Fix “Cannot open backup device” Error?
When you want to back up your database, you may see "Cannot open backup device" error as you see in…
0 Comments
November 5, 2018
How To Add MS DTC To The Cluster
In this article I will tell you how to add the MS DTC service to the windows cluster. First,…
October 26, 2018
How To Define a Share and Map This Share To Windows
In this article We create a share on a server and then we map this share on a server.…
October 13, 2018
SQL Server Password Policy
When creating a SQL Login, you can select the Enforce Password Policy option as described in my article "How…
October 9, 2018
Security Policy for SQL Server(secpol.msc)
After SQL Server Setup has been performed, it is necessary to make some settings in Security Policy in Windows…
October 8, 2018
What is Mounted Drive and How to Create It
We use letters like C, D, E when defining disks on "Windows Server". If the number of our disks…
September 27, 2018
SQL Server Configuration Manager Settings
SQL Server Configuration Manager is a tool in which many settings of SQL Server are made. In this article,…
September 23, 2018
SQL Server Service Account’s Permissions on Windows
Most DBA usually define the SQL Server Service Account as the Administrator on the server. Actually, this authority is…
September 17, 2018
How To Detach and Attach a Database Containing FileStream Data
You may want to move a database containing "File Stream" data to another disk with the detach attach method. Moving…
September 1, 2018
Running SQL Server With High Performance(High Performance)
It is a setting made on windows so that SQL Server can work with higher performance. This setting can…
August 31, 2018