Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In some cases, the SQL Server Error Log File grows very fast. And when the file grows too large, it becomes difficult to read. …
Read More »How To Kill Session Without ALTER SYSTEM Authorization
Application developers may want to kill long-running queries. However, since application developers do not have ALTER SYSTEM privileges, they cannot execute the kill session …
Read More »How To Create a SQL Server Job
You can create jobs on SQL Server to do certain operations at certain intervals. For example, if you want to run a script every …
Read More »The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON
ERROR MESAGGE: “The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.” EXPLANATION: When logging in to SQL Server Instance with …
Read More »The media set has 2 media families but only 1 are provided. All members must be provided.
ERROR MESAGGE: “System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)” EXPLANATION: You may …
Read More »Unable to open the physical file “xxx.mdf”
ERROR MESAGGE: “Unable to open the physical file “xxx.mdf”. Operating system error 5: “5(failed to retrieve text for this error. Reason: 15105)”. (Microsoft SQL …
Read More »Unexpected EOF encountered in BCP data-file
ERROR MESAGGE: “[Microsoft][SQL Native Client ]Unexpected EOF encountered in BCP data-file” EXPLANATION: You may encounter an error message when trying to transfer data to …
Read More »Property Owner is not available for Database
ERROR MESAGGE: “Property Owner is not available for Database ‘[database_name]’. This property may not exist for this object, or may not be retrievable due …
Read More »Database ” is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire load sequence is completed
ERROR MESAGGE: “Database ‘<database_name>’ is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire load sequence …
Read More »Error 1017 received logging on to the standby
If the logs are transmitted and not applied to the standby side, if you get the error in the “alert log” file as follows, the …
Read More »