Viewing 15 posts - 31 through 45 (of 279 total)
You could also consider merge replication, you can combine it with with AlwaysOn https://repltalk.com/2016/05/31/walkthrough-of-merge-replication-with-alwayson-high-availability-2/ or check the Peer-to-Peer - Transactional Replication.
Azure SQL Data Sync is only available for...
April 19, 2019 at 9:36 am
Why there is SSO to DB? SSO should be only to app as you have access logic in app. In this configuration you should configure access logic on db level...
April 19, 2019 at 9:15 am
There is Peer-to-Peer replication
https://docs.microsoft.com/en-us/sql/relational-databases/replication/transactional/peer-to-peer-transactional-replication?view=sql-server-2017
March 6, 2019 at 8:35 am
First check the error log there should be information why SQL wasn't able to accept new connections eg. non yielding scheduler. Depending on the error log there will be next...
February 24, 2019 at 4:24 pm
MS know best which platforms they support 🙂
https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-faq?view=sql-server-2017
"Microsoft may provide limited or no technical support for SQL Server software components that are...
February 14, 2019 at 6:01 am
Hi, this status mean: SUSPEND_FROM_REVALIDATION = Log change mismatch is detected on reconnection (see error log)
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-hadr-database-replica-states-transact-sql?view=sql-server-2017
looks like replica B was set to asynchronous mode and failover...
February 9, 2019 at 4:32 am
You should add ip from the second subnet. Why are you adding ip from the same subnet?
February 7, 2019 at 1:30 pm
You must provide SAS key in GUI. SSMS is working on your credentials and SQL Server during restore use its own. The same behavior is when you try to restore...
January 18, 2019 at 2:11 pm
No you don't need a certificate to use TLS1.2. Internally SQL is using by default automatically generated and self signed cert. You need a trusted cert if you use Force...
January 16, 2019 at 2:26 pm
Error is clear, you are trying to install localized SQL Server, are you sure that this is ENG media as there is 1036_FRA_LP folder?
https://social.msdn.microsoft.com/Forums/lync/en-US/ee93f5c1-6d5d-47a4-b914-31890580188b/sql-server-express-problem-with-instalation?forum=sqlexpress
"With SQL Server...
January 8, 2019 at 2:09 am
"TIMEOUT integer
Specifies the time-out period in seconds. The time-out period is the maximum time that a server instance waits to receive a PING message from...
December 13, 2018 at 8:15 am
Hi, you can start SQL in single user mode https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/start-sql-server-in-single-user-mode?view=sql-server-2017
and then add eg: local administrators group to sysadmin role, you don't need to reinstall it.
December 13, 2018 at 8:08 am
If you disable them then no, if you stop them then yes. You can check how schedulers are set for them, for distributor it will be start automatically with SQL...
December 5, 2018 at 1:47 am
What errors do you have in error log? There should be many errors and information regard this failover that will tell if this was cluster fault or some synchronization errors...
October 19, 2018 at 3:50 am
You must change application connection string to chose the driver that support TSL1.2 eg. ODBC 11. Many application use by default "SQL Server" driver that are present on all Windows...
October 19, 2018 at 3:46 am
Viewing 15 posts - 31 through 45 (of 279 total)