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
0
votes
1 answer

SQL Server 2016 Log Shipping and Transaction Replication

Good Morning, I have a SQL Server 2016 that is doing Log Shipping to a DR Site. I currently want to also to Replicate (Transactional) specific Tables to another Server for Reporting Purposes. Will there be any issues or snafu's I should be aware of?…
Rich Vieira
  • 1
0
votes
1 answer

Error 258 when connecting to sql server instance over the network

Can't connect to a sql server instance over the network, and all SSMS gives me is a 258 error. Everything is supposed to be correct. Both machines are inside a domain and the user was added to the security\logins during installation. Server…
thexbuttonisntworking
  • 11
  • 1
  • 1
  • 5
0
votes
1 answer

sp_send_dbmail succeding but sometimes failing

Also posted in Stack Overflow. Any feed back would be much appreciated. I have a need for a SQL job to send multiple emails, and I have come across this error that I am unable to find any solutions for. When I send emails this way is succeeds every…
Randy
  • 1
0
votes
1 answer

Rolling Backups of .sql files

I'm having a bunch of docker-containers containing different databases. For every container there is a Jenkins-Job which performs a daily backup of the database as a .sql-file and then zips this file. As you can imagine this leads to a lot of…
Someone2
  • 103
  • 1
0
votes
1 answer

SQL Converting strings to date

this has really baffled me for a few days and am seeking help. I am using SQL Server 2017. I am trying to handle strings from a free format field and either convert them to a date in the format of "dd/mm/yyyy" or if they are not in this format then…
gfsadmin
  • 1
0
votes
0 answers

SQLCMD CMD Line Tools Fails install

I recently installed the most recent version of SQL CMD Line Tools. I installed it using these directions. I ran the following command to make sure the module is installed: Get-Module -ListAvailable -Name sqlserver Which returns the sqlserver…
JukEboX
  • 815
  • 4
  • 17
  • 46
0
votes
1 answer

Logparser - Selecting data in the past 2 weeks

I am trying to use LogParser to return the data from my iis log files for the past 2 weeks. When I run the following I get "Error: Syntax Error: : no valid content: expecting opening parenthesis instead of token 'DATEADD(day,-14,'" logparser "SELECT…
thehouseisburning
  • 1
0
votes
1 answer

SQL server connection TCP/IP overt Ethernet

I have two PCs. There is SQL Express installed on one of them. TCP/IP settins are here: tcp/ip settings tcp/ip settings When I perform Test-NetConnection on local computer I get But when I do it from remote PC I get As you can see tcp succeeds…
user3742046
  • 3
  • 2
0
votes
1 answer

repmgr for streaming replication - standby register

I'm testing repmgr tool and I'm a little bit confused. Everything's fine until standby register step. What should I have configured on standby server? From docs I assumed that standby should't have the cluster, but it didn't configure a new one.…
maar
  • 485
  • 6
  • 20
0
votes
0 answers

Has anyone here tried using ZWAMP as a dedicated SQL instance for long-term data collection?

By "ZWAMP", I mean this product, especially its MySQL implementation. What I'm really aiming to learn here are the inherent, hardware independent, data storage size, complexity, and duration limitations associated with that software, if any; and…
boxcartenant
  • 101
  • 1
0
votes
2 answers

How does Google Cloud Platform handle database backups with --async flag?

I'm currently working on adding an extra step to our companies CI/CD pipeline so we make backups of the database before making a deployment that could potentially run migrations on our database. To make the backup I authenticate with Google Cloud…
patrickdamery
  • 113
  • 1
  • 5
0
votes
5 answers

Microsoft DNS Server: how to configure it to use MSSQL database for DNS data?

Is it possible to configure microsoft DNS server (widows server 2008+) to use Microsoft SQL as a data source for DNS data? Is it any guides available?
grigoryvp
  • 3,655
  • 11
  • 39
  • 59
0
votes
1 answer

Error code ElasticPoolOverStorageUsage

I'm trying to create a new database in our Azure SQL elastic pool and getting the following error code. Error code: ElasticPoolOverStorageUsage. We have a total space of 32GB and based on the Elastic pool data storage graph, we have used only…
Andrew
  • 1
0
votes
1 answer

How to best setup SQL 2019 with 6 drives?

SQL 2019; Dell R710 2x2.93 GHz x5670; 144 GB RAM; 6 - 2 TB drives Derived from a previous question (posted here 10 years ago), I figure 3 x RAID 1 is the best way to go. Please correct me if I am wrong or if you think there is a better way. Assume…
ferb_badrobot
  • 1
0
votes
1 answer

Axapta 3.0 How to change Company permission for user?

We got an old axapta 3.0 Server to manage of one of our customers. The problem is our customer needs this old server to access old company data and no one has a plan how to administrate it. We need to change the permissions for several users that…
WhiteIntel
  • 131
  • 1
  • 7
1 2 3
…
85 86