Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR MESAGGE: “Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2147467259 Error message: Unspecified error Error description: …
Read More »MSSQL
The tail of the log for the database “database_name” has not been backed up
ERROR MESSAGE: Msg 3159, Level 16, State 1, Line 2 The tail of the log for the database “TestDB” has not been backed up. …
Read More »The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.
ERROR MESAGGE: “The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using …
Read More »The transaction log for database ‘database_name’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
ERROR MESSAGE: “The transaction log for database ‘database_name’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc …
Read More »A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
ERROR MESAGGE: “An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by …
Read More »Mail configuration information could not be read from the database
ERROR MESAGGE: “Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail configuration information could not be read from the database. > System.Data.SqlClient.SqlException: profile name is …
Read More »The backup set holds a backup of a database other than the existing ‘database_name’ database.
ERROR MESSAGE: “System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘database_name’ database. (Microsoft.SqlServer.Smo)” EXPLANATION: If you already have …
Read More »Assign the data on the same line when defining a variable with “Declare”.
In SQL Server 2008, when you define a variable with “Declare”, you can also assign data to that variable in the same row! We …
Read More »How To Increase SQL Server Error Log File Count
For more information about SQL Server Error Log, you should type Error Log in our search section. SQL Server Error Log consists of 6 …
Read More »The operating system returned the error ‘5(Access is denied.)’ while attempting ‘RestoreContainer::ValidateTargetForCreation’
ERROR MESAGGE: “System.Data.SqlClient.SqlError: The operating system returned the error ‘5(Access is denied.)’ while attempting ‘RestoreContainer::ValidateTargetForCreation’ on ‘C:\Program Files\Microsoft SQL Server\MSSQLx.MSSQLSERVER\MSSQL\xxx.mdf’. (Microsoft.SqlServer.Smo)” EXPLANATION: If you …
Read More »