Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR MESAGGE: “Connections to SQL Server files (*.mdf) require SQL Server to function properly. Please verify the installation of the component or download from …
Read More »Database ‘xxx’ cannot be opened due to inaccessible files or insufficient memory or disk space
ERROR MESAGGE: “Database ‘xxx’ cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. …
Read More »An error has occurred while establishing a connection to the server…No connection could be made because the target machine actively refused it
ERROR MESAGGE: “An error has occurred while establishing a connection to the server. When connecting to SQL Server 20xx, this failure may be caused …
Read More »Ad hoc update to system catalogs is not supported
ERROR MESAGGE: “Ad hoc update to system catalogs is not supported.” EXPLANATION: If the “allow updates” option in SQL Server Instance is enabled, you …
Read More »Error 0xc002f210: Preparation SQL Task: Executing the query “” failed with the following error: “Retrieving the COM class factory for component with
ERROR MESAGGE: “Error 0xc002f210: Preparation SQL Task: Executing the query “” failed with the following error: “Retrieving the COM class factory for component with …
Read More »SQL Server is not Starting(The system cannot find the path specified)
ERROR MESSAGE: Error 3(The system cannot find the path specified.) occurred while opening file ‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf’ to obtain configuration information at startup. …
Read More »System.Data.SqlClient.SqlError: The operating system returned the error ’32(The process cannot access the file because it is being used by another process.)’
ERROR MESSAGE: System.Data.SqlClient.SqlError: The operating system returned the error ’32(The process cannot access the file because it is being used by another process.)’ while …
Read More »How To Recover Dropped Tables with Oracle Recyclebin
In this article I will tell you about Recyclebin which is one of the beautiful features announced with Oracle 10g version. With the Recyclebin …
Read More »What is SQL Server Database Compatibility Level and How To Change Database Compatibility Level
The Compatibility Level sets some database behaviors to work in accordance with the specified version of SQL Server. For example, for compatibility levels in …
Read More »ORA-00245: control file backup failed; target is likely on a local file system
When backup is taken with Rman, it creates the snapshot of the control file and uses it as backup file. The name of the …
Read More »