ERROR MESAGGE: “System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)” EXPLANATION: You may …
Read More »Unable to open the physical file “xxx.mdf”
ERROR MESAGGE: “Unable to open the physical file “xxx.mdf”. Operating system error 5: “5(failed to retrieve text for this error. Reason: 15105)”. (Microsoft SQL …
Read More »Unexpected EOF encountered in BCP data-file
ERROR MESAGGE: “[Microsoft][SQL Native Client ]Unexpected EOF encountered in BCP data-file” EXPLANATION: You may encounter an error message when trying to transfer data to …
Read More »Property Owner is not available for Database
ERROR MESAGGE: “Property Owner is not available for Database ‘[database_name]’. This property may not exist for this object, or may not be retrievable due …
Read More »Database ” is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire load sequence is completed
ERROR MESAGGE: “Database ‘<database_name>’ is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire load sequence …
Read More »Error 1017 received logging on to the standby
If the logs are transmitted and not applied to the standby side, if you get the error in the “alert log” file as follows, the …
Read More »How To Filter SQL Server Error Log(Like or Not Like)
The SQL Server Error Log file is one of the first places each DBA looks at in order to understand and solve the problem. …
Read More »The database was backed up on a server running version x+y. That version is incompatible with this server, which is running version x
ERROR MESAGGE: Msg 3169, Level 16, State 1, Line 2 The database was backed up on a server running version x+y. That version is …
Read More »Argument data type xml is invalid for argument 1 of like function
ERROR MESAGGE: “Argument data type xml is invalid for argument 1 of like function” EXPLANATION: You may encounter an error when you query an …
Read More »Procedure expects parameter ‘@statement’ of type ‘ntext/nchar/nvarchar’
ERROR MESAGGE: “Procedure expects parameter ‘@statement’ of type ‘ntext/nchar/nvarchar’.” EXPLANATION: You may see this error message when you run the command in a variable …
Read More »