MSSQL

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 …

  ERROR: An error occurred while executing batch. Error message is: Invalid attempt to GetBytes on column ‘xxx’. The GetBytes function can only be used …

  ERROR: “An invalid schema or catalog was specified for the provider “Local Server” for linked server “(null)”.” EXPLANATION: I received this error message when …

  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: …

  ERROR: The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. …

  ERROR: Description: The package is encrypted with a password. The password was not specified, or is not correct. End Error Could not load package …

  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 …

  Tail Log Backup takes the backup of log records that have not yet been backed up. We can use this backup to return to …

DBCC CHECKTABLE is used to test the consistency of a table or indexed view. The DBCC CHECKTABLE command performs the same operations as the DBCC …

  In the Replication Monitor, you can see a message for a long time in the tab “Distributor to Subscriber History”. When you see this …