Learn how to fix: Cannot insert a duplicate key row in object ‘sys.sysschobjs’ with unique index ‘clst’ while using DBCC CLONEDATABASE.
SQL SERVER – Automatic Seeding of Availability Database ‘SQLAGDB’ in Availability Group ‘AG’ Failed With a Transient Error. The Operation Will be Retried
Earlier I have written few blogs about automatic seeding feature. In this blog we would learn how to fix error: Automatic seeding of availability database.
SQL SERVER – Add Database to Availability Group Failure – This BACKUP or RESTORE Command is Not Supported on a Database Mirror or Secondary Replica
In this blog post, we will fix the error related to This BACKUP or RESTORE command is not supported on a database mirror or secondary replica.
SQL SERVER – FIX: Msg 7416 – Access to the Remote Server is Denied Because No Login-mapping Exists
In this blog we would talk about fixing error 7416 – Access to the remote server is denied because no login-mapping exists.
SQL SERVER – FIX: Msg 15274 – Access to the Remote Server is Denied Because the Current Security Context is not Trusted
In this blog we would talk about fixing error 15274 – Access to the remote server is denied because the current security context is not trusted.
SQL SERVER – Error: 5173 – One or More Files do Not Match the Primary File of the Database
In this blog, we would discuss error: Error: 5173 – One or more files do not match the primary file of the database and its solution.
SQL SERVER – REBUILDDATABASE Error: 0x84CF0004 – While updating permission setting for folder The Permission Setting Update Failed for File
While updating the permission setting for the folder, the permission setting update failed for the file with the error REBUILDDATABASE.