Issue: Secondary database stuck in “Initializing / In Recovery” mode or “Reverting / In Recovery” mode after AlwaysOn failover. Fix: Wait until the secondary database has synced up with the database on the primary. This may take a while if there are pending transactions. Recommend waiting for the secondary database to sync back up with... » read more
Issue: There was a server crash on the database server. After the crash, Always On has been failing. Windows Failover Cluster log indicate cluster resource failure. SQL Server log has a lot of “sql server i/o request taking longer than 15 seconds”. Cluster Event: EventID 1069 Cluster resource ‘xxxxx’ of type ‘SQL Server Availability Group’... » read more
Rebuilding an index does two things. First, since you’re literally rebuilding the index, it reorders the pages and the rows on those pages. This has a benefit in that it can eliminate some pages, making the index smaller and condensing the rows to pages, based on your fill factor. Second, as a part of the... » read more
Issue: Database shrink cause database full and log backups to fail. Fix: Make sure to disable database backups when running database shrink.
Make sure the DDL file is place in this folder and has the following property set… D:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin File -> Properties -> General -> Unblock checked Checked the “Unblock” in file permission, restart SSRS services, and try uploading the RDL file again. Sources: https://forums.ivanti.com/s/article/Error-when-attempting-to-preview-a-report-in-BIDS-Failed-to-grant-permission-to-execute-Exception-from-HRESULT-0x80131418?language=en_US https://learn.microsoft.com/en-us/sql/reporting-services/custom-assemblies/deploying-a-custom-assembly?view=sql-server-ver16
Issue: Getting the following error when try to upload a RDL file to SSRS that uses a custom DDL file… Could not load file or assembly or one of its dependencies. Failed to grant permission to execute. Fix: Make sure the DDL file is place in this folder and has the following property set… D:\Program... » read more