Have there been any alter database actions on the primary?

do the primary and secondary instances have the same drive\path assignments

300 dbs in an AG?

You do realise this thread is over 7 years old

• This reply was modified 2 years, 9 months ago by Perry Whittle.

I encountered this same issue, found a solution and documenting this for prosperity.

SQL Log shipping expects the trn files to be named  "{DBNAME}_yyyyMMddhhmmss.trn"

for Ola Hallengren backup solution, this is...

just one note to add here, if you do restore the DMK from another server, and i recommend you don't, you will need to take extra steps in order for...

wow , been a short while since I touched ssrs, it seems they have withdrawn multi instance support in favour of virtualisation of ssrs nodes

where are you reading this, what...

so it was, apologies, did not see that in the line of code.

Best to mention it anyway

a mapped drive is user profile specific, one user mapping H: to a share wont be the same for other users logging on.

Use the UNC path and just ensure the...

to be able to grant others permission you need to be assigned the GRANT WITH GRANT option, this defaults if you own the object

Hi,

We have 4 SQL instances (2014, 2016, 2017, 2019) all using AOAG.

What's the score with SSRS connecting to these instances? I'm thinking for every SQL version we have,...

Never seen this behaviour before (maybe it has happened and I haven't been bitten yet!) I have some new DBs (SQL 2012) and these have been created by...

Check my stairway, already linked above.

Although written for 2012\2014 it's still relevant in most respects apart from later features like distributed AGs and cross domain\workgroup clusters.

These are always over looked in favour...

how are you determining the frag level, are you using the index physical stats DMV?