Questions tagged [sql]
Database language for managing data in relational database management systems (RDBMS). Note that each database implements SQL with slight variations. Please remember to tag with your specific database as well, e.g. [mysql], [postgres], [mssql], or [oracle].
1,295
questions
0
votes
1
answer
82
views
Slow SQL Queries over local net
Slow Queries for SQL over 1Gb link between servers using just SSMS
Server Configs:
Main SQL Node:
32GB Ram
16 cores
Sage Evolution Server:
16 cores
16GB ram
The config of the servers is that they ...
0
votes
0
answers
23
views
What MS licences would allow us to host client systems? [duplicate]
As I understand it, Microsoft licencing is tied to an organisation. My company is a gold partner and has volume licensing. We're toying with the idea of hosting some of our clients systems, but don't ...
-1
votes
1
answer
508
views
Best database (SQL\NoSQL) for storing file hashes and corresponding description [closed]
I am working on a system that store file hashes and a corresponding description
basically, the structure is very simple just 1 table, HASH (key) and File Description.
For example:
...
1
vote
0
answers
111
views
SQL Merge Replication Triggers Missing
In MS SQL Server 2008R2 SP3 Standard, I'm seeing an issue where reinitializing a merge publication with a new snapshot deletes all of the merge triggers from all of the tables, and then when snapshot ...
0
votes
0
answers
62
views
SQL Server 2012 not reinstalling
I have uninstalled everything from control panel with sql server 2012
It can never get past the first window of installation which has product key, license terms, product updates, install Setup files....
0
votes
1
answer
2k
views
execstop mysql error on stop and restart
prerequisite:
os: kali-linux 2018.1
uname -r: 4.14.0-kali3-amd64
mysql version: mysql Ver 15.1 Distrib 10.1.29-MariaDB
problem:
yesterday i had setup an apache server with this help, https://www....
-3
votes
1
answer
360
views
MySQL replication not working
I have been trying everything I could find and my servers are not replicating! Can someone look at my config files and offer some guidance?
My,ini master on Windows:
# Other default tuning values
# ...
0
votes
2
answers
2k
views
SCCM report to count collection members is returning junk
I have written a report to give me the total member count on multiple collections at once. It executes, but when it does, only the first collection in the list returns its actual membership. The ...
2
votes
1
answer
4k
views
SQL SVR 2016 - Relocating system databases to different drive (Invalid directory error Msg 5121)
I have a fresh install of SQL Server 2016 which i'm trying to relocate the system databases onto a different drive on the machine Drive:D I've ran the following commands but keep getting the same ...
1
vote
0
answers
456
views
Terraform SQL create users from variable
I was told this might be a better spot for my question:
I have users defined in tfvars:
test_database_users = ["td" , "tdus", "tdbusrs"]
Resource is defined as:
resource "template_dir" "...
0
votes
1
answer
719
views
How to run maintenance plan task on success of two other tasks
I need to run the maintenance plan task on success of two other tasks and only after those tasks have completed. At the moment task2 starts straight away after one of the other two completes and it's ...
1
vote
1
answer
2k
views
SQL Server - Connect via SSMS works fine, but ODBC fails
I have a SQL 2016 Express instance, and I can connect to this fine using sqlsrv_connect() from within PHP. However, when I try to create a ODBC connection it fails. I get the error message "SQL Server ...
1
vote
1
answer
84
views
Home Postgress Server Configuration
I have postgresql server installed on my main computer (my desktop). I am working on a hobby project via node.js and sometimes would like to work from my laptop when i can not be at my desktop.
How ...
0
votes
1
answer
1k
views
exporting with from MSSQL with BCP over Samba shared folder
I have a daily routine that runs over a SQL db and exports some data with BCP. I need to move these files to a Linux machine, so I shared the folder using Samba.
The local export works fine, yet when ...
1
vote
1
answer
234
views
How to access a SQL Anywhere Server without a database to create one?
is it possible to connect to a SQL Anywhere Server without an existing database to create one. In SQL Anywhere Studio i always have to define an existing database.
Regards
Martin
0
votes
1
answer
84
views
SQL 2008 Cluster Resource could not bring online
I had problem in SQL 2008 R2 cluster resources. When I check the event "An error occurred while processing the log for database 'model'. If possible, restore from backup. If a backup is not available,...
1
vote
1
answer
2k
views
Setup SQL Transaction Log backup for every 30 mins [closed]
I know how to setup a one time sql transaction log backup from SSMS, but I could not find a very detailed steps for setup this transaction log backup for every 30 mins.
How can I do this in SSMS?
I ...
0
votes
1
answer
153
views
How to debug a SQL script containing INSERT statements with failing subqueries?
I have three tables in my database: tbl_object, tbl_tag adn tbl_object_tag_xref.
tbl_object and tbl_tag only have the two columns id and name.
tbl_object_tag_xref matches objects to tags and vice ...
0
votes
1
answer
88
views
Bulk Load with SQL Login - Credential no longer works
I built a Java plugin which runs a SQL script. This does a bulk load to read from xml files on a server, using a SQL login. To get it to work a SQL credential to a domain account was linked to that ...
0
votes
1
answer
361
views
sccm 1702 sql server service running account
I am having an issue with the installation of SCCM 1702. When it runs it's pre-requisite check I get an error indicating the login account of the sql server is incorrect. It is specifically ...
1
vote
1
answer
1k
views
SQL Server slow in guest machine over time (virtualization with KVM on a Centos 7 Host)
We have a new server a HP DL360, 64GB RAM, 2x8 core CPU, SAS HDD Raid1 array and one SSD Raid1 array.
The SSD Array is configured with 2 Samsung 850 Pro devices (not HP certified).
We installed a ...
0
votes
1
answer
1k
views
AWS : Lag issues between RDS SQL Server over two regions
Data policies of our customers means we have to host our database in the UK / EU.
We currently have an US West EC2 instance (Windows) running as a web server. But since adding the new London RDS (SQL ...
0
votes
0
answers
167
views
Error moving Sql Server Azure between subscriptions
I’m trying to move a SQL Azure Server that has 2 databases from one subscription to another. The databases’ sizes are 10G and 1G. I’m using the azure portal to do it and I’m getting the following ...
2
votes
0
answers
53
views
SQL Mirgations - Domain Trusts or not to Trust?
I am about to migrate something like 18 SQL servers into AWS from an on prem\colo. We will be building a new Domain in AWS and would like to leave the old domains behind. Do I need to setup a domain ...
0
votes
2
answers
38
views
How I can get db's current restore mdoe status by query?
So, my db can be in three differrent statuses.
RECOVERY
NORECOVERY
STANDBY
And I want to know current db's status by query. Can you help me ?
The single what I've found is
SELECT is_in_standby
...
2
votes
1
answer
8k
views
SSL Security error with SQL Server 2016 sp1
I'm running SQL Server 2016 sp1 on a Windows Server 2012 r2 box. Supposedly, unlike earlier versions of SQL Server, SQL Server 2016 is compatible with TLS 1.2 right out of the box.... Right? Anyway,...
-2
votes
1
answer
67
views
Is it possible to create a SQL script to copy a database from some remote server to local server, running script in local server? [closed]
I need copy database from some server to my local machine database.
HOST REMOTE SQL SERVER (READ ONLY PERMISSIONS) ----- TO --- > MY LOCAL SERVER
Thanks Advance
2
votes
0
answers
2k
views
Blocking urlencoded SQL injection with nginx
I inherited an Nginx setup in front of an Apache server. Today I found some SQL code hitting the apache access logs: GET /mgrayson/splice%27%29%20AND%20%28SELECT%204520%20FROM%28SELECT%20COUNT%28%2A%...
0
votes
1
answer
130
views
Does SQL licence expire for a single instance? [duplicate]
I have two instances of SQL server namely Adventure and instance 2. Now I cannot start SQL server from services for Adventure but the instance2 is fine. Once i go through the log file it showed SQL ...
0
votes
1
answer
359
views
Can postgres delete constraint affect performance when doing SELECT, not delete?
For example, if I set ON DELETE CASCADE, can it somehow affect performance outside delete command? Or will it only affect performance when deleting?
And more importantly - if I set to do nothing on ...
3
votes
1
answer
881
views
Prestashop + Google Cloud SQL
I am currently trying to setup a Prestashop 1.7 instance using Google Cloud Compute Engine and Google Cloud SQL (MySQL 5.7).
I managed to get to the installation page of Prestashop, but when I try to ...
3
votes
2
answers
9k
views
Unable to Windows Update and WSUS broken
for a while now, despite working faultlessly for over 3 years, both WSUS and Windows Update have stopped working on our single domain contoller running Windows Server 2008 (not R2).
The error we get ...
0
votes
1
answer
531
views
Interpreting a Deadlock Log / XDL file
I've generated the following XML + XDL:
<deadlock>
<victim-list>
<victimProcess id="processc1eaf13468" />
</victim-list>
<process-list>
<process id="...
2
votes
2
answers
5k
views
Is using MySQL Workbench over the Internet safe?
Let's say I have a server with an SQL Database somewhere on the other side of the planet. Is it safe to establish a connection over the Internet? e.g. with MySQL Workbench.
I'm asking because I heard ...
0
votes
2
answers
426
views
2 SQL Databases with crucial data
I have two databases with 45gb each with very crucial data. Now the sql is telling me that both are corrupted. My database is in emergency mode. What I can do to put it back online?
And when I try ...
3
votes
2
answers
3k
views
How to convert a MyISAM .sql dump into InnoDB?
Can I convert dumped .sql MyISAM database into InnoDB engine before importing it to my MySQL server? Unfortunately, importing the current .sql file takes ages to complete.
0
votes
1
answer
80
views
Mongodb and SQL Server
Our db group is looking at placing our mongodb server instances on the same servers that host sql server. Our SQL foot print is fairly large with a good dozen dbs larger than 200gb in total space ...
1
vote
1
answer
2k
views
Foreign Key Constraint Error 1005 erno 121
I'm racking my brain trying to get this table created. Other tables create just fine in mariadb 10 with similar constraints. I've run it through debuggers with no success.
ERROR 1005 (HY000) at line ...
1
vote
0
answers
432
views
PHP Fatal error: Uncaught exception
AFter building and hosting one of my zend application website, few days after, when tring to load the website, it resolves: ' No such file or directory ' on the homepage.
then i had to check up the ...
0
votes
0
answers
13
views
Trying to understand Microsoft SQL and Windows Server licensing [duplicate]
I'm trying to understand how many licenses I'm supposed to purchase and check if I have the correct amount of purchased licenses.
I have Windows Servers & SQL Servers in virtual environment.
From ...
0
votes
1
answer
263
views
Looking for SQL Server 2014 SP1 Build 12.0.4213.0
I'm trying to install a new SQL Server 2014 instance, on a new machine, with this version:
SQL Server 2014 SP1 Build 12.0.4213.0
I have it installed on one of my machines, but I have no clue how to ...
0
votes
1
answer
213
views
MySQL account has password, but only logs in without it
I am running Windows Server 2012 R2 trying to host a Drupal site. Because it is Drupal, I am trying to connect to a MySQL server rather than a MSSQL server. I created a new schema as well as a new ...
1
vote
2
answers
136
views
Move MSSQL Server to another Server
So I'm about to move a MSSQL Server to another better hardware server.
I need to make sure I'm moving everything.
I made a small list of what I think I need to move:
Databases (ofcourse :))
MSSQL ...
0
votes
3
answers
3k
views
MariaDB Refusing remote connections
I've gone through a lot of tutorials and questions and I still can't get it to work.
I've used the following great example: MariaDB refuses remote connections
But still no luck connecting... But ...
1
vote
1
answer
185
views
SharePoint SQL DB is nearly 50 GB. Cannot shrink due to lost/expired SA password
Back in June of last year I posted about how our old SharePoint '07 database has grown exorbitantly large. The problem is that C:\ and E:\ are on a single VMDK and the C:\ parition is nearly out of ...
0
votes
1
answer
696
views
Login failed for user '401hk'. Reason: Could not find a login matching the name provided. [CLIENT: 220.180.111.229]
We have a Microsoft Azure virtual instance and over there we have installed the SQL Server 2014 Express edition. While investigating a issue we found below logs in windows event viewer in application ...
0
votes
1
answer
213
views
Move SQL Indexes in bulk
Let me start off by saying I am not a SQL guru, I know just enough to get into trouble with it :) We just migrated a client over from SQL 2008 R2 to SQL 2016 on new hardware and we want to move the ...
0
votes
0
answers
88
views
How to connect Google VM Instance to Google SQL Instance and use it both to run Wordpress
Dears,
Its been 2-3 weeks since I've started learning how to host my websites on Google VM instance, I've installed Vesta Cpanel and it will install PHP, apache, MySQL, PHPMyAdmin .. etc all the ...
1
vote
0
answers
619
views
For SQL server with one User CAL, can one user be logged in concurrently from multiple devices?
So basically our client had no idea what they were doing when licensing SQL Server, and ended up only purchasing one User CAL. What I'm wondering is, can that same User CAL be used across multiple ...
1
vote
1
answer
19k
views
How to check buffer pool size in sql server?
Is there any way to find total allocated buffer pool size in sql server.In mysql we can find it by using the variable innodb_buffer_pool_size.Is there any equivalent for that in sql server?