All, sorry for not replying to the thread. The secondary server has been offline since Saturday. I have a maintenance window tomorrow so the plan is to reseed via AG...

Also is this server running SQL and SSIS? If SQL is also running on it I'd look at the memory allocation for SQL and make sure you're leaving 6-8GB...

ALTER DATABASE MyDB SET OFFLINE WITH ROLLBACK IMMEDIATE;
RESTORE DATABASE MyDB FROM DISK = 'D:\Backup\MyDB.bak' WITH REPLACE, STATS = 10;

Restore command

• This reply was modified 6 months, 4 weeks ago by  LearningDBA.
• This reply was modified 6 months, 4 weeks ago by  LearningDBA.

Even though the database is in simple recovery mode, I see "offline rollforward begins" in extended events when I restore a database.

Date transfer is complete

backup set is restored

offline rollforward begins

Processing...

WITH STATUS AS
(
SELECT BUSINESS_UNIT, PROJECT_ID, effdt, Project_Status, ROW_NUMBER() OVER (Partition BY Project_ID Order by effdt desc, effseq desc) as RN from PS.Project_Status
)

Select Distinct
prj.Business_Unitas ProjectBusinessUnit
,B.descras ProjectBusinessUnitName
,CAST (NULL as...

Thanks frederico_fonseca

This is the url

https://www.brentozar.com/pastetheplan/?id=S1e6Wn7MR

I will just provide some details.

As of last week, almost everyone had access to run select against some restricted views

Then I generated the list of users who had read only...

Any feedback?? Anyone??

I did suggest creating a new table, dumping only Feb 2024 data, renaming the new one and old one. No response yet from the user.

Also, this table has 4 indexes.

1...

• This reply was modified 10 months ago by  LearningDBA.

I changed the Legacy cardinality Estimation setting to ON and now both queries are taking the same time.

Hey experts, I am really hoping to get any feedback. Just trying to understand why this behavior...

I came across an article where I had to add 1 in the end like reports1, restart the services and viola it worked. Changing it back to reports worked as...

I made the changes based on your recommendations so now the plain report is displayed when I use https://server/ReportServer but then I get HTTP Error 404. The requested...

I followed this RSExecRole document, recreated the role, granted all necessary permissions, restarted reporting server but getting the same error. I have admin rights on the server. The service...

• This reply was modified 3 years, 11 months ago by  LearningDBA.

This role doesn't exist on Dev and Prod but I am able to manage the subscription. However, I am going to create this role as well as grant permissions

NT****  already...