A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

New answers tagged

0

You need to run SSMS "elevated" as the Administrator for it to connect to SSIS.


3

You can't restore a file or filegroup without restoring the PRIMARY filegroup. There are a number of reasons for this given your scenario: Under SIMPLE mode, a Partial Backup always contains the PRIMARY filegroup and all read/write filegroups. You would need to switch to FULL recovery to utilise file/filegroup only backups that can exclude the PRIMARY. If ...


0

Ok I found this article https://blog.sqlauthority.com/2015/05/16/sql-server-service-pack-error-the-user-data-directory-in-the-registry-is-not-valid-verify-defaultdata-key-under-the-instance-hive-points-to-a-valid-directory/ It says my CU update fails because of Default Log path does not exist anymore Default Log path can be checked by one of below ways: ...


8

This is a bug. This answer indicates that it is fixed in CU17 but I just tested that and found it negative (and there is no indication that the fix was intended to be backported here). I tried SELECT [Group] , Commas = STRING_AGG(Member, ', ') , Colons = STRING_AGG(Member, '::') FROM (VALUES (1, 'a'), (1, 'b') , (2, 'c'), (2, 'd')) [v]...


2

First, don't drop the table to do this. You have two better options: Use the MERGE command TRUNCATE the table before inserting, don't DROP and CREATE. The main limitation on the TRUNCATE...INSERT pattern is permissions, since a simple read or update permission grant will not allow for TRUNCATE. ALTER permission on the table is needed to use this command. ...


1

The process failed (unfortunately I missed the error message) and now the source database is missing as well. I found another post on the same topic, which suggests locating and atttaching the .mdf file. If the database is no longer listed on the instance, but you can still see the .mdf file, it somehow got detached during this first unsuccessful ...


2

I have never tried to use SSMS to copy a live database as you have done. But I have copied many, many databases without an issue. Use the following approach in the future and you will not have the same issue again. Take a full backup (use COPY_ONLY) Then restore the backup with a new name. Your live database will never be detached, so you won't have ...


0

Upgrading your two 2017 instances to Enterprise is a simple process. SQL Server Setup has a function called Edition Upgrade, which is a fairly straightforward process. Your SQL 2016 Standard to SQL 2017 Enterprise is more complicated. You need to assess your environment and determine what best suits your resources, skills and appetite for risk. Microsoft ...


3

The most likely explanations I can think of are: the database has been restored from a backup or snapshot in the case of a restore from backup, the log file would be reverted to whatever size it was when the backup was taken in the case of a restore from a snapshot, the log file is discarded and replaced with a tiny, 2-vlf log file the monitoring is ...


0

Microsoft Support engineer replied below on my case: I (Support engineer) have reached my technical leads to have an urgent update on this and I was able to get it. Unfortunately, the Product Group confirms my initial suspicions about the setup you want to achieve not being possible due to Hybrid Connections limitations therefore not supporting this. It’...


0

DC1: (servers are in WSFC): DB_Server1 and DB_Server2 DC2: DB_Server3 Is it possible to configure SQL 2017 Always-On/SQL 2017 Distributed Always-On in above environmnet? Yes. The basic, and best solution: 1) Add DB_Server3 to the WSFC and add and add it to the AG, hosting an Async Replica, and optionally with an AG Listener configured to fail over ...


0

This is not enough information in your question, to definatively say if you can or can not meet your goal with your available resources. It is possible to Create a domain-independent availability group that spans physical locations. Yes it can be done. How to set up the infrastructure to support it, is going to be out of scope for DBA.se, but you can get ...


4

Why would a table with a Clustered Columnstore Index have many open rowgroups? There are many different scenarios that can cause this. I'm going to pass on answering the generic question in favor of addressing your specific scenario, which I think is what you want. Is it possibly memory pressure or contention between the insert and the delete? It's not ...


1

SELECT message.Id, message.message, message.category, person.Id personId, CASE WHEN personmessage.messageId IS NULL THEN 0 ELSE 1 END enabled FROM message CROSS JOIN person LEFT JOIN personmessage ON personmessage.personId = person.Id AND personmessage.messageId = ...


Top 50 recent answers are included