Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
When the database falls into the suspect mode, we can solve this problem by restoring only the corrupted pages instead of restoring full backup. …
Read More »A network-related or instance-specific error occurred while establishing a connection to SQL Server
ERROR MESAGGE: “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. …
Read More »Invalid zero-length device name. Reissue the BACKUP statement with a valid device name
ERROR MESSAGE: Msg 3044, Level 16, State 1, Line 1 Invalid zero-length device name. Reissue the BACKUP statement with a valid device name. Msg …
Read More »Cannot drop the database ‘database_name’ because it is being used for replication
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 »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 »“enq: SQ – contention” Waits and Solution
When a sequence is queried, the NEXTVAL value is generated from the seq$ table if it is not cached. If it is cacheed, it …
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 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 »