Viewing 15 posts - 226 through 240 (of 9,244 total)
300 dbs in an AG?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2023 at 9:39 pm
You do realise this thread is over 7 years old
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2022 at 8:12 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2022 at 10:34 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 5, 2021 at 8:07 am
wow , been a short while since I touched ssrs, it seems they have withdrawn multi instance support in favour of virtualisation of ssrs nodes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2021 at 11:09 pm
I didn't think you can install multiple instances on the same Windows host anymore, at least that's what I'm reading for SQL 2019.
where are you reading this, what...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2021 at 10:59 pm
so it was, apologies, did not see that in the line of code.
Best to mention it anyway
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2021 at 6:41 pm
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2021 at 6:39 pm
to be able to grant others permission you need to be assigned the GRANT WITH GRANT option, this defaults if you own the object
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2021 at 10:24 am
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,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2021 at 10:18 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2021 at 10:15 am
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.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2021 at 10:08 am
but MAXDOP 1 hint would have solved that as well (or adjusting the cost threshold for parallelism) and was a "better" option.
These are always over looked in favour...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2021 at 10:05 am
how are you determining the frag level, are you using the index physical stats DMV?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2021 at 9:31 am
I'm guessing your account has the necessary share and ntfs permissions on the remote fileshare, thats why it works through VS.
Setting up an agent proxy would be the best idea...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2021 at 9:29 am
Viewing 15 posts - 226 through 240 (of 9,244 total)