Server Fault Stack Exchange
Server Fault Stack Exchange

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].

An abbreviation of "Structured Query Language," SQL is a database language used to manage data in relational database management systems.

Due to many vendor implementations of SQL (such as T-SQL for SQL Server & Sybase, PL/SQL for Oracle and PostgreSQL and MySQL) it is a fractured language and syntax that works with one vendor may not work with another.

1284 questions
-1
votes
2 answers

MySQL table "doesn't exist" error

I'm using Windows 7 Ultimate x64. After reinstalling OS copied back whole MySQL data directory to C:/Programdata. But now when i'm trying to open some table from restored db's with Navicat it shows me http://prntscr.com/2s9wl error. I don't know…
Tural Ali
  • 119
  • 1
  • 10
-1
votes
2 answers

How do I backup and restore a database using sql script?

I have a Database of 50Gb of data on Test Server A, I want to take the Backup and I want to Restore it to Test Server B. I need Backup and Restore step by step with query's?
sriakanth
-1
votes
2 answers

Does MS SQL Server requires more RAM memory than MySQL?

I had a talk with a professional who works in a hosting company and he told me that MS SQL Server does take more memory than MySQL in performing its queries. Is that true? And why do you think is the reason behind this? What makes SQL Server require…
Goma
  • 217
  • 1
  • 3
  • 10
-1
votes
1 answer

sql server 2008: how do you set up a trace on a specific database?

i am trying to use sql server profiler to trace all the sql statements on a specific database, is this possible to do?
Alex Gordon
  • 455
  • 3
  • 14
  • 31
-1
votes
2 answers

SQL Server 2005: Corrupt database - Automatically shutdown DB?

Lately I experienced a corrupt DB because of a defective harddisk. SQL Server 2005 detected the issue and put entries into Windows event log about inconsistent DB and invalid page checksums. But it just tried to deal with it. It kept on making daily…
Krumelur
  • 119
  • 4
-1
votes
1 answer

SQL Server 2008 setup error Attempted to perform an unauthorized operation

I am trying to install SQL Server 2008 Standard Edition on windows 7 and during installation it give error: Attempted to perform an unauthorized operation
muzammil
-1
votes
1 answer

Mysql server eating all RAM (100GB) when load is running

I am using Mysql - Server version: 8.0.29 MySQL Community Server - GPL My server has 100GB RAM. Of it I allocated innodb_buffer_pool_size as 90 GB SET GLOBAL innodb_buffer_pool_size = 96636764160; I am running a load script (shell) that basically…
santhosh
  • 103
  • 4
-1
votes
1 answer

Anybody familiar with the Shoretel database?

I have a copy of the local db from our old shoretel voip system... which is no longer in service. I've been tasked with trying to locate information pertaining to calls to and from specific numbers over the past year or so. Wondering if anybody is…
boog
  • 220
  • 3
  • 11
-1
votes
2 answers

Unable to find user account to set permissions for private key

I'm trying to set up a security certificate for a sql server. According to the documentation, I need to set up the permissions so that the sql server instance can read the private key. I tried setting up the permissions through mmc (see…
pbuchheit
  • 151
  • 2
  • 11
-1
votes
1 answer

Users and Roles Extraction in Oracle

I've tried to write a query to have a users/roles extraction, i don't have much SQL skills as well as on oracle, so I started with this: SELECT A.GRANTEE, A.GRANTED_ROLE, B.ACCOUNT_STATUS FROM DBA_ROLE_PRIVS A JOIN DBA_USERS B ON A.GRANTEE =…
bind2lrz
  • 7
  • 5
-1
votes
1 answer

MS SQL Server Cores / License To Purchase

After almost 6 years I'm approaching the 10 GB limit of my MS SQLExpress deployment. I'm looking at the licensing for MS-SQLServer and am getting more confused with everything I read. Can anyone help set the "Standard - server + CAL" vs "Standard -…
BigMikeL
  • 121
  • 1
  • 6
-2
votes
1 answer

Google Cloud SQL database increase

My Google Cloud SQL automatic storage increased up to 31GB but still the database size is only 120Mb and all the above happens in 3 days?
Vicky
  • 1
  • 1
-2
votes
1 answer

Is it possible to create a SQL script to copy a database from some remote server to local server, running script in local server?

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
Nicolas Gliksberg
  • 11
  • 3
-2
votes
2 answers

Transition legacy software from Windows XP on Windows 10

I have a 'general' question regarding transitioning legacy software from Windows XP to Windows 10. I will provide all relevant info and the reason for doing so. Firstly, the legacy software was coded by a software engineer in 2006 on Windows XP. The…
user6035892
  • 1
-2
votes
1 answer

sql server: best practice for log backup in full recovery mode

I have a development sql 2014 environment. I need to put all db in full recovery mode in order to test availability groups, so I need to manage logs to avoid excessive growth. I don't need to keep log backups at all since it is only a development…
maurice
  • 61
  • 2
  • 6
1 2 3
…
85 86