Viewing 15 posts - 1 through 15 (of 15 total)
Thankyou, is there a way to enable "Both Successful and Failed Logins" under server/instance properties for SQL Managed Instance.
For SQLserver, enabling this would require a restart. In SQL MI, it...
March 14, 2022 at 1:43 pm
Thanks for the reply, There's only one connection string.
All the connections are only coming thru app and settings should be consistent for all the sessions.
March 3, 2022 at 10:17 am
Thanks, Do you have any links for this setup of continuous sync from MI to MI using DataFactory
November 26, 2021 at 4:34 am
Thanks for your reply. We are looking for a database size of over 500GB and need all the tables to be replicated. I dont want to recommend Transactional replication as...
November 24, 2021 at 11:21 am
Thankyou for the reply.
We are using 4tb disk as the db size is 3tb. Regardless of the disk size it says in the link, latency for general purpose tier should...
October 19, 2021 at 12:20 pm
Thankyou, Do you happen to have any links for whitepaper on Azure Managed Instance (like best practices and guidelines for db setup).
May 22, 2021 at 12:01 pm
Update:
This has been fixed. I've installed latest Cumulative update on both SQL instances, rebooted the servers and it is working now.
Thankyou all for your help.
June 12, 2020 at 11:18 am
I tried with granting sysadmin role to Nt Authority\System, getting same error.
Also modified the owner of hadr_endpoint to sa, same error.
I see this error, when I checked eventlog on PrimaryReplica...
June 10, 2020 at 1:02 pm
Yes, SQL server instance starttup account is a domain service account. I've added that account to both servers as local admin and to the instances as Sysadmin. Hadr endpoint port...
June 9, 2020 at 10:29 am
Thanks John, I'll get the lastest CU installed.
The error is comingup when I try to create AG with AG wizard. It was trying to add secondary replica and is failing....
June 9, 2020 at 4:28 am
The Job and SQL agent gets hung in a few seconds(<10 sec).
Weird thing is, when I run sp_addsubscription manually in SSMS, it is successful. The issue is only when I...
March 6, 2020 at 2:19 pm
Database size is 650gb. I've tried using snapshot method, creating the snapshot was very slow.
March 6, 2020 at 1:37 pm
profiler trace is resource consuming.On busy servers, running profiler with GUI causes more issues than actual performance issue(in my experience:-)).
server side trace is lightweight
I found this article helpful comparing profiler...
November 5, 2013 at 1:59 pm
thankyou..Yes, there's blocking and I understand we cannot have two full backups at sametime..Can you give me an explanation on why it cant be done or provide any BOL article...
November 5, 2013 at 10:00 am
thanks..Path is correct..But when I removed 'I$', it seems to be working..
Service account has Local admin privileges on the server..Do you know why it was showing access denied when I$...
November 1, 2013 at 7:06 am
Viewing 15 posts - 1 through 15 (of 15 total)