Application developers may want to kill long-running queries. However, since application developers do not have ALTER SYSTEM privileges, they cannot execute the kill session command. Also, this authorization should not be given to users who are not dba. There is a way for application developers to kill sessions without ALTER SYSTEM authorization. We may […]
You can create jobs on SQL Server to do certain operations at certain intervals. For example, if you want to run a script every half an hour or you may need to get backups every night. We can duplicate samples. In this article I will describe how to create a job. Right-click Jobs under […]
ERROR MESAGGE: “The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.” EXPLANATION: When logging in to SQL Server Instance with a Login, you can receive a message that your password has expired and should be changed. If you receive such a warning message, then this means that the “CHECK_EXPIRATION” property […]
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 encounter an error message when you want to restore a backup file. You’re getting this error because you’ve taken a backup of the database to more than one file, and […]
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 Server, Error: 5120)” EXPLANATION: You may encounter an error message when you want to attach a database by using SQL Server Management Studio (SSMS). SOLUTION: You may receive this error […]
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 your database with the BCP tool from a CSV format file. SOLUTION: The reason for the problem is that the delimiters used in your CSV file are different from the […]
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 to insufficient access rights. (Microsoft.SqlServer.Smo)” EXPLANATION: For example, you may see this error message when you try to look at the properties of a database in SQL Server Management Studio. […]
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 is completed.”</database_name> EXPLANATION: You may encounter an error message when you back up your database. SOLUTION: If your database is a Secondary database, for example, in a Log Shipping scenario, […]
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 only reason is that the orapw file differs with standby because of the sys password change of the database. [crayon-5c1934423a93d260211783/] The solution is very simple. It is necessary to […]
The SQL Server Error Log file is one of the first places each DBA looks at in order to understand and solve the problem. In this article, we will examine the below scenarios. How to read the entire Error Log file without a filter How to read Error Log file by filtering. As […]
