Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR MESAGGE: “Cannot drop the database ‘database_name’ because it is being used for replication. (Microsoft SQL Server, Error: 3724)” EXPLANATION: You may encounter an …
Read More »MSSQL
The index “index_name” (partition 1) on table “table_name” cannot be reorganized because page level locking is disabled
ERROR MESAGGE: “Executing the query “ALTER INDEX [index_name] ON [dbo].[table_name] REORGANIZE WITH ( LOB_COMPACTION = ON ) ” failed with the following error: “The …
Read More »How To Transfer CRS Resources To Other Node in RAC Databases(crs_relocate)
Sometimes you may want CRS resources to run on other nodes in RAC databases. In this case, you must manually move the relevant resources …
Read More »How To Recover Suspect Database in SQL Server
The fall of the database into the suspect mode is the fearful dream of every dba. It is necessary to take precautions with a …
Read More »How To Recycle Error Log Without Restarting SQL Server Service
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 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 »