Viewing 15 posts - 601 through 615 (of 2,863 total)
Just to step back a bit - you indicated that you have 1 SQL instance per VM and the ones without AG's are working fine, but everything in an AG...
February 8, 2022 at 7:37 pm
The error from Chome should tell you that things are not set up properly.
My GUESS is you didn't add a script map for the PUMP dll. You didn't list that...
February 8, 2022 at 5:05 pm
Licensing is a question best answered by your licensing provider. Forum answers are going to be guesses based on what WE have seen, and you may have some deal with...
February 8, 2022 at 5:01 pm
My opinion - blocking outgoing traffic is only required if there is a risk of the server being compromised. If you can download and install arbitrary applications on the server...
February 7, 2022 at 3:01 pm
If I understand your question right, you are asking if you can add an index to a table on production while users are using the table. If so, yes. It...
February 4, 2022 at 5:21 pm
Found an old article on this, but I expect it is still valid:
I would recommend doing it on a test system first and trying things out and once you are...
February 4, 2022 at 3:40 pm
I've noticed this too. For me, I usually get that error if I wait too long to click on "Submit" after loading the page. Like if I load the page,...
February 4, 2022 at 3:33 pm
Just to confirm something - what does the network traffic look like on the AG instances?
My thought here is that your non-AG instances seem to be working fine, but the...
February 4, 2022 at 3:32 pm
If you configured the publisher and subscriber on the local system, then nothing should be going to Azure.
My understanding of replication is that you need to have a publisher which...
February 4, 2022 at 3:21 pm
My opinion - Profiles (and all other database mail configuration stuff) should be handled by the DBA, not by "corporate people". Heck, the SQL Server install should be done by...
February 4, 2022 at 2:26 pm
If replication from on-prem to the cloud works without firewall changes, I would be suspect of your firewall. I would double and triple check your firewall configuration to make sure...
February 4, 2022 at 2:17 pm
As far as I know, every time I set up a new instance, I re-setup the mail profile. I currently use the GUI for it as I lost my mail...
February 3, 2022 at 10:32 pm
Pretty sure SQL doesn't log that information. In general, I have found that I don't care who created an index, I just care that the correct indexes are created. Only...
February 3, 2022 at 10:24 pm
I think it is one of those "it depends" scenarios. If the column is named $$SomeName, then yes, the $'s are part of the column name.
If it is not a...
February 3, 2022 at 10:18 pm
I can't speak to replication from on-prem to cloud as I've not done that, but you ask what other options do you have and there are options. You could use...
February 3, 2022 at 2:21 pm
Viewing 15 posts - 601 through 615 (of 2,863 total)