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. [tag:mysql], [tag:postgres], [tag:mssql], [tag:oracle]

learn more… | top users | synonyms

-5
votes
2answers
26 views

How to stop/start only SQL Server in Windows 7 when logged in as Limited User

I have an employee working as a data entry operator on Windows 7 PC. I want to create backup of the data and for that I have to stop SQL server while in administrator mode, to move data files to ...
-3
votes
0answers
13 views

Windows 10 - SQL Server Install hangs [on hold]

I've tried installed every version of SQL Express I can get my hands on (And I've got the MSDN SQL 2016 CTP 2). Everythings hangs, and always at this point. I've a feeling its a .net related issue ...
0
votes
1answer
7 views

SQL Server 2012 Native Client returns missing DLL error on install

OS: Windows 7 Pro SP1 Whenever I try to install the SQL Server 2012 Native Client x64 the install process gets to the end, the "removing backup files" stage then throws up this error: "There is a ...
0
votes
0answers
24 views

Bridge server for connecting two databases?

I'm in a bit of a pickle. I currently have 2 database servers. One is hosted in the US and is online on the internet. The other is local, working only on LAN and external connections are not allowed. ...
-2
votes
0answers
12 views

sql query to merge a variable number of rows into one row [closed]

I have a rather complicated query that I need some help with. I am not sure if it can be done in SQL. I have two tables: tags: tag_id tag_name 1 blue 2 green 3 black 4 ...
-2
votes
0answers
14 views

SQL Joins and Relationships [migrated]

Joins are somewhat confusing. I want to know how to choose the join based on the relationship between tables, or do joins have no dependency on relationship? if relationship is "one-to-one" then ...
0
votes
0answers
9 views

Attempt to write readonly database , Skype main.db [closed]

im trying to write and delete something from a skype database, but i get this attempt to write a readonly database If anybody do that before, can please say me the solution? thankyou very much ...
-1
votes
0answers
37 views

SQL Dump via Cronjob [closed]

OS: Debian SQL: MariaDB HTTP: NGINX TOOLS: PHPMyAdmin I try to run a automatically backup by cronjob hourly. For testing purposes I wrote the following shell script: mysqldump -u root -pMyPassword ...
0
votes
0answers
4 views

Hows to make a DB2 table read-only? [migrated]

We need to test how an application will fail when the DB2 database cannot be written to. What is the easiest way to make a DB2 table read-only? Is this considered locking? Thanks in advance, Bert
0
votes
1answer
39 views

Disabling TLS v1.0 with SQL & RDP

How do I disable TLS 1.0 without breaking MS SQL & RDP on Windows Server 2008 R2? If I simply disable it, RDP stops working along with MS SQL. Tried googling but I can't find a solution. Is this ...
0
votes
0answers
39 views

Do SQL backups run faster if you set the databases to read only first?

I have to do a backup of all databases back to back (3.25 GB of data for all .BAK files combined). Will it go faster if I configure the script to set the database to read only first before backing it ...
0
votes
0answers
43 views

How to export SQLCMD output to Excel

I am using SQLCMD command in powershell to run SQL scripts. When i pipe the output to TXT ,the formatting is all messed up. i want to export the results to excel file. how can i do that. My command ...
0
votes
1answer
23 views

on prem SharePoint 2013 size limitations

I am attempting to provide some of my remote users (bandwidth limited) with a on prem sharepoint server (Sharepoint 2013 foundation) on a Dell poweredge t110 II running windows server 2012 r2 ...
0
votes
0answers
14 views

Virtualized IIS 7 Intranet page is slow when querying against SQL database

OK… I’ve been tasked to figure out why an intranet site is running slow for a small to medium sized company (less than 200 people). After three days of looking on the web. I’ve decided to post what ...
0
votes
0answers
15 views

Upgade SQL Express 2012 -> 2014 gives: Script level upgrade for database 'master' failed because upgrade step

Trying to upgrade my SQL Express 2012 to SQL Express 2014 with the upgrade wizard, but get the error: Script level upgrade for database 'master' failed because upgrade step ...
0
votes
0answers
15 views

How to Restore from sql Maintenance plan backup

I have a SQl 2005 Instance in my PROD SQL server. I have been given a task to migrate databases inside that instance to different SQL box ( SQl 2008 r2 in Win 2008 r2 box) Database. Current sql ...
-1
votes
4answers
85 views

MYSQL - is LOCALHOST speedy than i.e. (domain) mysql.domain.com [closed]

I am interested, on some hosting(although they are paid hostings, for example, DreamHost. probably 000webhost too), in database server, you have to insert: mysql.domain.com (instead of: localhost). I ...
0
votes
1answer
21 views

SQL Server 2012 AlwaysOn Availability Groups Server Logins Fails When Switching Between Nodes

I am setting up a 3 node cluster as part of an availability group. Initially I tested failover between nodes using SQL Management Studio and everything failed over successfully when I stopped a node, ...
3
votes
2answers
96 views

Performance azure disks, high average queue length

I'm having a classic developer-system admin battle where I am stating that there is an IO problem on the disk of the shared sql server while the system admin tells me that the capacity hasn't been ...
0
votes
1answer
21 views

SQL clustering without WSFC (Windows Server Failover Clustering)

Is it possible to cluster, or make SQL "highly available" without having to pay the huge enterprise prices? By the looks of it, any type of SQL clustering requires enterprise edition Windows Server. ...
0
votes
1answer
31 views

Azure SQL - Sudden connection spike

At first: This is my first question on Serverfault. I am not sure if it fits better on Information Security. If so, please leave a comment and I will move the question. Question My company is ...
-1
votes
1answer
39 views

Database sql server Mirroring or replication

I have SQL server 2008 R1 with standard edition. I have a large database i.e. 500GB that i.e. growing rapidly 10GB a month .It is a cloud based solution. We have another data center where the ...
0
votes
0answers
9 views

Having Trouble Setting up OLAP/Analysis Services on SQL Server 2014

I have been having extreme trouble setting up an azure server with a sample multidimensional database i have been using this tutorial ...
-5
votes
1answer
23 views

DB Server and Fully Qualified Domain Name

I have a hosted virtual server (Windows Server 2012 R2) that exists solely to host a few SQL databases. I need to purchase a SSL certificate to encrypt data but purchasing a certificate requires that ...
2
votes
1answer
40 views

Hyper-V Guest data encryption

I have a new requirement to encrypt the data inside an sql database while it is at rest. So far I've looked at Bitlocker (see below), and other commercial products (I won't name because I'm not ...
-2
votes
0answers
36 views

Where are the latest benchmarks on SQL-on-Hadoop performance? [closed]

I'm investigating adoption of Hadoop in my company, and a key requirement will be use of SQL for doing analytics. Hard to know exactly what the main usages will be but no doubt a mix of small and ...
0
votes
2answers
75 views

Copy DB table across 2 different MSSQL servers

I have 2 MSSQL servers running, with more or less the same data set. It is really a production/development setup. Now, my workflow is like this. Every day backups are made of each one of the ...
0
votes
1answer
34 views

how to create public SQL server [closed]

I installed sql server on my computer. I can work with it as localserver. But i want to it to be a public server. I followed lot of tutorials but it's still don't work(I can't connect the server ...
0
votes
1answer
54 views

32Bit ODBC DSN “Server does not exist or access denied” but 64 bit ODBC OK connecting to SQL Server 2014

Using a new SQL Server 2014 Connecting via 32bit ODBC fails giving the error "Server does not exist or access denied" Connecting via 64 bit ODBC is successful What might cause this?
1
vote
1answer
35 views

SSH Tunnel issues

Our setup is as follows; - 2 tomcat servers hosting sites - 1 load balancer - SSH connection to client server which contains database This approach has worked fine with the exception of one client ...
0
votes
0answers
52 views

How do I create an SQLAlchemy class with two foreign keys (to different tables)?

Contrived example: class Person(Base): __tablename__ = 'person' id = Column(Integer, primary_key=True) name = Column(Unicode) class Location(Base): __tablename__ = 'address' id = ...
0
votes
1answer
79 views

How to import postgresql file on Linux with space in path?

If I try to import an sql script with a space in path, the file is not found. mypsqluser=> \i /home/markus/Documents/Projekte/My App/Installation/server_sql_script.sql ...
3
votes
0answers
32 views

SQL & BITS Errors on prereq for SCCM 2012

Hey anyone that can help, I've been stumped by this problem for a while now and I've no idea what to do. I've installed SQL 2008 to run with SCCM '12. I've set Log On As a domain account with ...
0
votes
1answer
58 views

How to backup SQL database without users and stored procedures

I have a database which i need to take backup monthly / or by running an script. I need to backup the data and structure only. I don't want to backup stored procedures and users for example... I have ...
0
votes
1answer
35 views

SQL Server 2008: Delete database while Rollback is in progress

I am trying to remove a test database in which a database modification failed. The resources being consumed by the rollback action in SQL are affecting production databases (users reporting slow ...
1
vote
0answers
40 views

MSSQL application failing to connect to database server

We run a very old application that connects to an MS SQL server 2008 database using the SQL server native client 10. Sometimes if there has been a power failure with the server the clients will stop ...
1
vote
1answer
25 views

Why Sql browser local connection works when turned off

I recently get to interesting issue with Sql server browser. I have Win 2008 R2 datacenter server running multiple instances of Sql server and Sql browser. The instances are running under dynamic port ...
1
vote
1answer
28 views

SP_UsageAndHealth Database, What Is It and Can I Shrink It?

I have a SharePoint 2013 server whose SP_UsageAndHealth database started growing out of control this morning. It's grown from about 50GB to a terrabyte and a half in the space of a couple of hours. ...
0
votes
1answer
30 views

Asphostportal IIS6 vs IIS7

I have two shared accounts at asphostportal. One uses IIS 6 and one uses IIS7. On both I have websites in Classic ASP. On the IIS 6 account, when I make an error in code and upload it then try to ...
0
votes
0answers
79 views

postgres sql returning "more than one row returned by a subquery used as an expression

Postgres sql is returning: more than one row returned by a subquery used as an expression The data base format is: rpt_rec_num | wksht_cd | line_num | clmn_num | itm_val_num ...
0
votes
0answers
11 views

Sql Express DB on Server 2008 R2 is there a product to test for coding errors

This is mostly an annoyance and not a huge problem. The issue is tied to the execution time for server requests for small data pulls. If I ask thee software to create a list of any 200 clients ...
0
votes
0answers
71 views

hMailServer --> find all bounced back emails

I've been assigned to clean up some of our obsolete client's email from database. So the process was to send all client an email and see which one bounces back. now the problem is I can't find where ...
0
votes
0answers
44 views

Import outdated MySQL dump using console

I have a mysql dump file created by outdated MySQL version. I have no access to that server (console). If i use this command on my current server: mysql -u user -p dbname < dump.sql I get this ...
0
votes
1answer
11 views

SQL User Bulk Removal

After I removed an AD Group from the general security area, it's still mapped to about 18 Databases (This is a QA box) how can I get rid of all the account without having to go through each DB one by ...
0
votes
1answer
73 views

SSRS Report fails with conversion error but runs fine in ssms?

I have an issue with a report that was written before my time (I warn you it's got a lot of code and the error makes no sense). Basically its a stored procedure that creates a table variable and then ...
0
votes
2answers
54 views

Migrate MSSQL 2008R2 to 2012 (new hardware)

Since hardware support for our server ends we are migrating to a new hardware and simultaneously upgrading MSSQL 2008R2 to MSSQL 2012. I searched a little bit and found some guides, but they all ...
0
votes
1answer
223 views

Clone database or copy data from RDS MSSQL DB to local database

Is there anyway I can clone an amazon RDS MSSQL DB to my ec2 instance local DB? And this has to be done through powershell also. Basically I need backup of RDS MSSQL DB in sql or bak extension, but ...
1
vote
0answers
29 views

X3250 Server: stuck at firmware screen

The server is initialize, then it is stuck at the IBM System X Server Firmware screen (before F1, F12 appears, etc). You can see in the attached image. ...
3
votes
1answer
130 views

SQL Server 2008 Restored Database allows differential backup when no full exists

I restored a backup file (it's used as a template for new databases) as a new database. Normally as part of this process, I take a full backup after the restore, but this time I was called away on ...
0
votes
1answer
31 views

Does SQL Azure Data Sync conflicts get logged?

I have successfully synced my SQL Azure DB with my on-premise DB. The log shows the following: Sync completed successfully in 1884.76 seconds. Upload: 405323 changes applied Download: 0 ...