Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 »Ekrem Önsoy
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 »The database was backed up on a server running version x+y. That version is incompatible with this server, which is running version x
ERROR MESAGGE: Msg 3169, Level 16, State 1, Line 2 The database was backed up on a server running version x+y. That version is …
Read More »Argument data type xml is invalid for argument 1 of like function
ERROR MESAGGE: “Argument data type xml is invalid for argument 1 of like function” EXPLANATION: You may encounter an error when you query an …
Read More »Procedure expects parameter ‘@statement’ of type ‘ntext/nchar/nvarchar’
ERROR MESAGGE: “Procedure expects parameter ‘@statement’ of type ‘ntext/nchar/nvarchar’.” EXPLANATION: You may see this error message when you run the command in a variable …
Read More »One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.
ERROR MESAGGE: “One or more files do not match the primary file of the database. If you are attempting to attach a database, retry …
Read More »