Questions tagged [sql-server-2017]
SQL Server 2017 (major build version 14.00.xxxx). Please also tag sql-server.
1,037
questions
0
votes
0
answers
49
views
SQL Server Express mdf file is 50+gb
Good day,
I have a SQL Server Express database running on a POS register where the mdf file is 50+gb. When I run the select @@version I get the following:
Microsoft SQL Server 2017 (RTM) - 14.0.1000....
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
1
answer
48
views
SQL 2017 log reuse issue
I have a SQL 2017 Enterprise server where more and more VLFs are being consumed and none are being released. Log backups are running every 15 minutes. It is in an AG but this is working correctly (...
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
175
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 ...