Questions tagged [sql-server-linux]
29 questions
1
vote
0 answers
Docker and SQL Server Linux - Error 9002. The transaction log for database master is full due to NOTHING
I use Docker without Hyper-V with VirtualBox and Docker VM on Windows 10 Home edition.
I have the following Docker build file:
FROM repositoryname/mssql-server-linux:test-db
RUN mkdir -p /usr/src/app
WORKDIR /usr/src/app
COPY . /usr/src/app
#…
alexanoid
- 24,051
- 54
- 210
- 410
0
votes
1 answer
Add Providers to Linux SQL Server 2019
I want add a new linked server in my SQL Server (15.0.4261.1) running on Linux Red Hat Enterprise 8.6, before I add a linked server to other SQL Server database, but now when I want add a linked server to other I can't.
I check my SQL Server on…
0
votes
0 answers
Docker SQL Server image getting large with each docker commit
I have a docker SQL Server image that I configure and then share with team. Each time I update the data the image size increases significantly.
I start with the mcr.microsoft.com/mssql/server:2019-latest image which is about 1.6 gigs. I have to do…
Don Chambers
- 3,798
- 9
- 33
- 74
0
votes
1 answer
SQL Server 2019 on Linux Time Zone Problem
Why there are different results (offset should be +03:00):
SELECT
CURRENT_TIMEZONE() as [CURRENT_TIMEZONE()] , SYSDATETIMEOFFSET() as [SYSDATETIMEOFFSET()];
result is :
CURRENT_TIMEZONE() SYSDATETIMEOFFSET()
(UTC+03:00) Istanbul …
Ali Rıza Arslan
- 9
- 2
0
votes
0 answers
SQL Server-Python Permission issue on data export using Python in SQL Server
Returns error below command using SQL Server Management Studio and SQL Server is running on Ubuntu 18.04.
EXEC sp_execute_external_script
@language = N'Python',
@script =
N'import pandas as…
JERRY
- 1,165
- 1
- 8
- 22
0
votes
0 answers
WAITFOR Delay/Time not working properly in Windows Docker (SQL Server Linux)
The time specified in the waitfor delay is not honored in SQL Server Linux on Docker Desktop for Windows.
Script:
declare @tsstart varchar(100) = CONVERT (VARCHAR(100) , SYSDATETIME() ,121);
raiserror(@tsstart,0,0) with nowait;
WAITFOR DELAY…
praskutti
- 21
- 4
0
votes
2 answers
Is there a way to import data from an SQL file to Microsoft SQL Server Express Edition on Linux?
Ok, so I have a .sql file that i exported from MySQL Workbench and now I want to import it into Microsoft SQL Server Express Edition for linux, and I'm not sure how I should go about doing that, any suggestions?
Youssef
- 33
- 4
0
votes
0 answers
SA default password SQL Server on Linux
I installed SQL Server 2017 on Linux on a CentOS 7 derivate. Now I want to login with the command: "sqlcmd -S 172.0.0.1 -U SA". But I never set up a password. How am I able to login to the SQL Server? Root password is also not working. Could it be…
Ivo
- 303
- 2
- 15
0
votes
1 answer
How to change custom entry point in a dockerfile to apply migrations to sqlserver before run the ASP.NET Core Web application?
It is a VSTudio 2017 ASP.NET Core Web application project with SQL Server 2017 for Linux using Docker-compose. The dockerfile is:
FROM microsoft/dotnet:2.1-aspnetcore-runtime AS base
WORKDIR /app
EXPOSE 80
EXPOSE 443
FROM microsoft/dotnet:2.1-sdk…
Lupa
- 586
- 1
- 8
- 22
0
votes
1 answer
Execute stored procedure by using link server
I'm facing a problem. I have these 3 servers:
1 Server1
2 Server2
3 Server3
I want to create a job on Server1 which will send email in html format include drives spaces xp_fixeddrives of all three servers.
Please help me - what will be best…
Ahsan Mumtaz Abbasi
- 53
- 1
- 11
0
votes
2 answers
Connecting to SQL Sever docker container from another container without IP
I am running a SQL server container on Ubuntu using the following command
sudo docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=MyPassword' \
-p 1433:1433 --name db \
-d microsoft/mssql-server-linux:2017-latest`
I have another container on…
Islam El-Khayat
- 406
- 5
- 14
0
votes
1 answer
How can I view an SQL Server running in Docker?
I am following along in a book that has a .Net Core MVC and Angular project using the linux version of SQL Server for docker.
The project has a docker-compose.yml file like this:
version: "3"
services:
database:
image:…
Sam
- 4,766
- 11
- 50
- 76
-2
votes
1 answer
SQL 2017 Linux ag resource not failing over with pacemaker
We've setup a sql2017 cluster on linux following MS Documentation. Replication in the AG works fine but we are unable to failover. If I watch the logs during failover pacemaker is attempting to move the AG but it fails and continues running on the…
tweeks200
- 1,837
- 5
- 21
- 33
-3
votes
1 answer
Docker - SQL Server Linux auto shutdown
This is a first time I use docker, so I'm trying install sql-server-linux use docker in MacOS Mojave.
I'm read tutorial from https://database.guide/how-to-install-sql-server-on-a-mac/. But I meet a problem, my database server auto shutdown.
I'm…
The
- 49
- 11