Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 »SQL Server Databases Are Not Appearing While Creating a New Protection Group(SQLServerWriter does not appear as a result of the vssadmin list writers command)
Before you read this article, I suggest you read articles “How To Install DPM Agent For SQL Server” and “How To Backup SQL Server …
Read More »How To Backup SQL Server Databases with DPM
Before reading this article, you need to read the article “How To Install DPM Agent For SQL Server” and make the necessary installation. After …
Read More »How To Install DPM Agent For SQL Server
To be able to back up the SQL Server databases with DPM, the DPM Agent must be installed on the SQL Server servers via …
Read More »