Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 »Ekrem Önsoy
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 »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 »Error: The @newname value ‘test’ is already in use as a OBJECT name and would cause a duplicate that is not permitted. (Microsoft SQL Server, Error: 15335)
ERROR MESAGGE: “Error: The @newname value ‘test’ is already in use as a OBJECT name and would cause a duplicate that is not permitted. …
Read More »Cannot truncate table because it is being referenced by a FOREIGN KEY constraint.
ERROR MESAGGE: “Cannot truncate table because it is being referenced by a FOREIGN KEY constraint.” EXPLANATION: If you try to delete the contents of a …
Read More »The log in this backup set begins at LSN (xxx), which is too recent to apply to the database. An earlier log backup that includes LSN (xxx)
ERROR MESAGGE: “The log in this backup set begins at LSN (xxx), which is too recent to apply to the database. An earlier log …
Read More »