We perform FileGroup Backup and Restore operations in databases that are usually large and have more than one filegroup, while some of the filegroups are …
Read More »Invalid attempt to GetBytes on column
ERROR: An error occurred while executing batch. Error message is: Invalid attempt to GetBytes on column ‘xxx’. The GetBytes function can only be used …
Read More »An invalid schema or catalog was specified for the provider “Local Server” for linked server “(null)”.
ERROR: “An invalid schema or catalog was specified for the provider “Local Server” for linked server “(null)”.” EXPLANATION: I received this error message when …
Read More »Login failed. The login is from an untrusted domain and cannot be used with Windows authentication
ERROR: “Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: xxx.35.1.26] Error: 18452, Severity: 14, State: …
Read More »The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service
ERROR: The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. …
Read More »The package is encrypted with a password. The password was not specified, or is not correct.
ERROR: Description: The package is encrypted with a password. The password was not specified, or is not correct. End Error Could not load package …
Read More »Property ErrorLogFile is not available for JobServer ‘server_name’. This property may not exist for this object.
ERROR: Property ErrorLogFile is not available for JobServer ‘server_name’. This property may not exist for this object. EXPLANATION: In SQL Server Management Studio, you …
Read More »Collecting Schema Statistics Collectively
In some cases, automatic maintenance jobs are closed in databases. In this case, the schema statistics are not collected and cause serious performance problems. …
Read More »Tail Log Backup
Tail Log Backup takes the backup of log records that have not yet been backed up. We can use this backup to return to …
Read More »ORA-20005 : object statistics are locked
If you receive errors in the form of ORA-20005 and ORA-06512 during the collection of the table statistics, you must unlock the relevant table …
Read More »