Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 »How To Filter SQL Server Error Log(Like or Not Like)
The SQL Server Error Log file is one of the first places each DBA looks at in order to understand and solve the problem. …
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 »Could not backup database: The backup of full-text catalog ‘index_name’ is not permitted because it is not online
ERROR MESAGGE: “Could not backup database: The backup of full-text catalog ‘index_name’ is not permitted because it is not online. Check errorlog file for …
Read More »Cannot drop full-text catalog ‘catalog_name’ because it contains a full-text index
ERROR MESAGGE: “Cannot drop full-text catalog ‘catalog_name’ because it contains a full-text index.” EXPLANATION: You may receive this error when you try to delete …
Read More »Dedicated administrator connections are not supported. (ObjectExplorer)
ERROR MESAGGE: “Dedicated administrator connections are not supported. (ObjectExplorer)” EXPLANATION: When you use the Object Explorer in SSMS to connect to SQL Server using …
Read More »Exclusive access could not be obtained because the database is in use
ERROR MESAGGE: “Exclusive access could not be obtained because the database is in use.” EXPLANATION: You can get this error because you can’t put …
Read More »