Viewing 15 posts - 1 through 15 (of 73 total)
@steve-2 jones, this is exatly what I think for my testing and plan to propose to our SQL team. I don't think we'll have more than 2-3 named...
May 17, 2020 at 8:04 am
I found inbound traffic was not an issue (so far...). Its my outbound. In my example, the outbound server (ServerA ) has firewall restrictions and so I need to make...
May 16, 2020 at 12:58 am
I just wanted to amend that I just need to run
Invoke-Sqlcmd | Out-Null
This seems to then fully load the assemblies into memory and everything is OK after.
October 24, 2019 at 6:40 pm
@na_ma_cool, make sure you check the folder/file security also and that the sqlagent service account has access to read/write to that share and folder. Share security and folder/file...
October 24, 2019 at 6:24 pm
And no, AAG behaviour is not the same as a cluster service, you don't do log replay in a WSFC, you failover the service and volumes.
I agree it is...
October 23, 2019 at 7:37 pm
Per other posts, it most likely a permissions issue. Assuming you have separate accounts for SQL Agent and SQL Server the database backup files are create using the SQLServer account. ...
October 23, 2019 at 6:38 am
Not sure if this is the same issue, but we have AG group that the T-LOG full on the receiving side. While we had plenty of room on the primary...
October 23, 2019 at 1:27 am
Common latch information
May be related since you mentioned tempdb. This helps with tempdb contention.
https://logicalread.com/sql-server-tempdb-best-practices-multiple-files-w01/#.XXgAuihKiUk
September 10, 2019 at 8:01 pm
This is not to fix the initial issue, but just tip in case you didn't already do this. Run the restore statement immediately after the ALTER statement in the same...
September 10, 2019 at 7:55 pm
Sorry for the late reply. Thank you very much for this!
September 9, 2019 at 7:04 pm
Posting a possible solution even though this is an old topic in case somebody else encounters this issue
I ran into this issue why when trying to applying SQL 2016 security...
August 3, 2019 at 2:56 am
October 31, 2017 at 1:34 pm
July 28, 2017 at 12:07 pm
July 27, 2017 at 4:32 pm
Not sure if you every resolved this issue. I don't know if you issue was the same as mine, but I got this also and thought this was weird.
1....
July 26, 2017 at 2:00 pm
Viewing 15 posts - 1 through 15 (of 73 total)