Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  Before you read this article, I suggest you read articles “How To Install DPM Agent For SQL Server” and “How To Backup SQL Server …

  Before reading this article, you need to read the article “How To Install DPM Agent For SQL Server” and make the necessary installation. After …

  To be able to back up the SQL Server databases with DPM, the DPM Agent must be installed on the SQL Server servers via …

  ERROR MESAGGE: “Microsoft SQL Native Client (0x80004005) Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, …

  ERROR MESAGGE: “The database “xxx” cannot be opened. It is acting as a mirror database.” EXPLANATION: You experience this error if you try to …

  ERROR MESAGGE: “Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files …

  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 …

  During the DataPump export process, if the relevant session is waiting for the following message, you can resolve this issue by doing the following …

  If the view does not contain the object in another database, you only need to give the select authority on the view for the …

  ERROR MESAGGE: “Executing the query “EXECUTE master.dbo.xp_delete_file 0,N”,N”,N’2007-11-14T13:06:42′ ” failed with the following error: “Error executing extended stored procedure: Invalid Parameter”. Possible failure reasons: …