Viewing 15 posts - 16 through 30 (of 76 total)
Who is the scheduled task running as? NT AUTHORITY\ANONYMOUS LOGON login failures always boil down to the user in question not being able to be authenticated across the network.
March 28, 2019 at 6:56 pm
March 28, 2019 at 5:46 pm
Some people have encountered timeouts with DBs over 1 GB during the CREATE DATABASE phase and got around it by creating an empty database first on the destination. Do you...
March 27, 2019 at 10:44 pm
sqlfriends - Wednesday, March 27, 2019 11:59 AMAre there any scripts for the SQL agent job? I'am using 2017
This would be a...
March 27, 2019 at 6:05 pm
Replication and AlwaysOn should be fully supported in Standard Edition. See here and here.
There are some caveats and design decisions that are important. For...
March 27, 2019 at 6:00 pm
You can configure an Always On database as a Publisher or a Subscriber in a transactional replication topology and they automatically handle failover. See here for more info....
March 26, 2019 at 11:49 pm
The issue with setting SQLINST1 to synchronous is that after a failover, it will be a synchronous secondary whereas your normal state is that the secondary is asynchronous. Ideally, if...
March 26, 2019 at 11:35 pm
You have two options here:
March 26, 2019 at 8:16 pm
The information available in SQL Alerts can be limited. If you have SQL 2012 or higher you might try using Extended Events to capture details of these severity events. You...
March 26, 2019 at 8:03 pm
March 25, 2019 at 5:40 pm
What about the ##MS_PolicyTsqlExecutionLogin## login?
As per this link, that login needs sufficient READ access to each database in the policy in line with the T-SQL script used...
March 25, 2019 at 5:37 pm
Are you using xp_cmdshell in your backup solution?
If so, what code is it running, and have you tried running that code manually outside of SQL to see if there is...
March 25, 2019 at 1:13 am
We have some SQL Servers which are configured with Always on on Single...
March 25, 2019 at 1:07 am
Does the SQL Server Agent account have CONNECT permission to the database in question?
March 25, 2019 at 1:02 am
You cannot use an Azure SQL Database (PaaS) as a secondary in an Always On architecture, however, you can use it as a replication subscriber. You could replicate from your...
March 25, 2019 at 12:59 am
Viewing 15 posts - 16 through 30 (of 76 total)