Powershell & Python.

Backup your SSRS Databaes(ReportServer and Report Server Temp DB and Any other DB needed) using Microsoft SQL Server Managment Studio: 

And Backup your Encryption Key using...

double post.

You can set permisions per report or on entire folder. My hunch is you have permissions set on reports not the folder.

Found this:

Use Key Vault Insights: Azure provides Key Vault Insights, a feature in Azure Monitor, to visualize metrics like request frequency, latency, and failures.

Monitor SQL Server Activity: If you're using...

I created the tables and results returned. Re-enter the refnum in both tables, you might have a space in there.

SELECT DISTINCT refnum FROM RefSched;
SELECT DISTINCT s.refnum FROM supplier;

Check if values match. Maybe Data Type Mismatch? Since DESC is a reserved keyword in SQL Server, you should...

• This reply was modified 2 days, 15 hours ago by  Tav29.

--Check The Credential setup

SELECT name, credential_identity FROM sys.credentials WHERE name = 'YourCredentialName';


--Validate the Key Vault Key
SELECT name, key_algorithm FROM sys.symmetric_keys WHERE name = 'YourTDEKeyName';

https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/setup-steps-for-extensible-key-management-using-the-azure-key-vault?view=sql-server-ver16&tabs=portal

run both.

SELECT * 
FROM sys.objects 
WHERE name = 'fn_syspolicy_is_automation_enabled' AND type = 'FN';


SELECT msdb.dbo.fn_syspolicy_is_automation_enabled() AS IsAutomationEnabled;

• This reply was modified 2 days, 21 hours ago by  Tav29.

launch Sql Server Configuration Manager, Do you see SQL Agent running?

Your are correct regarding "Data for 2024-02-29 is left in place until 2027-03-01."

Good point Phil. I do believe DATEADD(year, -3, GETDATE()) Takes leap year into account, I'm too lazy to load test data. also I would not delete data from a table...

• This reply was modified 4 days, 13 hours ago by  Tav29.
• This reply was modified 4 days, 12 hours ago by  Tav29.

You can add to your SP after records are created or execute another SP that deletes the records over 3 years old. You need to have a date for when...

a simpler way is to run Powershell Script:CheckforSameFileNames.ps1 before processing files

Script Code below

Set-ExecutionPolicy -ExecutionPolicy Unrestricted -Scope CurrentUser
Write-Host "Execution policy set to Unrestricted for...

• This reply was modified 1 week ago by  Tav29.
• This reply was modified 1 week ago by  Tav29.
• This reply was modified 1 week ago by  Tav29.
• This reply was modified 1 week ago by  Tav29.
• This reply was modified 1 week ago by  Tav29.
• This reply was modified 1 week ago by  Tav29.

https://stackoverflow.com/questions/6598139/how-to-loop-only-through-files-that-dont-exist-in-destination-using-an-ssis-pac?rq=4

What helps me, I would flowchart the entire process and  then create your SSIS Package.

• This reply was modified 1 week ago by  Tav29.