All Questions
Tagged with sql-server sql-server-2017
829
questions
1
vote
1
answer
76
views
Deny access to Sql Server replica when it becomes primary
TL;DR
How to allow read-only access to some users on one replica (in an Sql Server availability group), only when the replica is secondary, and deny it when it becomes primary?
Explanation
I'm ...
0
votes
0
answers
35
views
Accessing this server via SQL Management Objects (SMO) or Distributed Management Objects (DMO) is currently not permitted
When I run this,
EXEC SP_CONFIGURE 'show advanced options', 1
EXEC SP_CONFIGURE 'SMO and DMO XPs', 0
SQL Server management studio unable to connect with error,
Accessing this server via SQL ...
0
votes
0
answers
79
views
SQL Server 2016 upgrade
We need to upgrade our SQL Server 2016 to SQL Server 2019. We are also using replication for our test and production environments.
What my question is: what are the downfalls of upgrading from SQL ...
0
votes
1
answer
50
views
SQL Server 2017 not recognizing Oracle driver for Linked server
I would like to connect from my SQL Server 2017 to an Oracle database via Linked server. I installed the Oracle driver from Oracle-Client-for-Microsoft-Tools-64-bit.exe, but the driver does not appear ...
0
votes
0
answers
89
views
High number of Latch Waits, is it a problem, and how to investigate?
We have reports of performance issues on one of our applications. I tried to have a look for anything obvious, but I'm an Oracle DBA, and my SQL Server knowledge is pretty limited - we don't have any ...
0
votes
0
answers
174
views
Maintenance Plans Failing Invalid Class String
This is on a SQL Server 2017. We are required to use maintenance plans for full/log backups and DBCC Checks. They have been working fine, but I received an email that they have failed yesterday. I ...
0
votes
0
answers
21
views
SQL Database Mirroring Timeout Update Questions
When performing SQL Database Mirror Timeout value updates:
Does both Principal & Mirror need to be in 'Synchronized' state?
Does the SQL Server instance need to be restarted for the changes to ...
-1
votes
1
answer
109
views
Identify which index's rebuild operation is causing the log file to grow
We have a database, in full recovery model, which goes under index rebuild maintenance once a week. There is an index which is causing the log file to grow. I have log file growth event alerts enabled,...
3
votes
0
answers
57
views
request_status is Grant and Convert on the same resource_type at the same time
I have a typical blocking scenario due to lock contention.
Lead blocker has these locks on an object.
<Object name="Table1" schema_name="dbo">
<Locks>
<Lock ...
1
vote
1
answer
70
views
Avoid logfile getting too large on SQL Server
I have a SQL Server stored procedure that essentially 'flattens' a complex database into a single, simplified, table in a separate database to allow users to query the data without needing to ...
0
votes
0
answers
21
views
Error after failing over always encrypted database
I started capturing the following error after performing failover into secondary replica for the database which was using the always encrypted feature of SQL Server 2017 Enterprise Edition:
Some ...
0
votes
1
answer
40
views
Upgrade SQL Server Server Express to Licensed Enterpise edition?
we have sql server express edition 2017 with default instanc ,now we want to upgrade it to Enterprise Licensed Edition 2017 with default instance in the same server
At first I thought I had to ...
0
votes
1
answer
113
views
Cannot do a backup of a read_only database
I'm facing a strange issue where my backup fail with the message :
Msg 3906, Level 16, State 1, Line 5
Failed to update database "MyDBB" because the database is read-only.
Msg 3013, Level ...
0
votes
1
answer
26
views
Is there a way to verify if a SSIS instance was configured as a cluster resource or not?
We had 2 servers in a cluster ( no aoag ) with SQL + SSIS.
one of the cluster nodes died and we removed it. we are in the plan to create a new cluster node and configure SQL engine normally on it as a ...
0
votes
1
answer
154
views
Can Query Store Show Spills To Tempdb?
I know that Query Store can show tempdb usage as of SQL Server 2017, but can it show spills to tempdb? I'm highly confident that the plan cache can.