Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 »MSSQL
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 »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 »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 »Subquery returned more than 1 value
ERROR MESAGGE: “Microsoft SQL Native Client (0x80004005) Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, …
Read More »The database “xxx” cannot be opened. It is acting as a mirror database.
ERROR MESAGGE: “The database “xxx” cannot be opened. It is acting as a mirror database.” EXPLANATION: You experience this error if you try to …
Read More »Database diagram support objects cannot be installed because this database does not have a valid owner
ERROR MESAGGE: “Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files …
Read More »The report server has encountered a configuration error. Access denied to the path ”.
ERROR MESSAGE: “The report server has encountered a configuration error. Access denied to the path ‘c:\program files\microsoft sql server\mssql.3\reporting services\reportserver\rsreportserver.config’ is denied.” EXPLANATION: After …
Read More »