Path: csiph.com!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: Erland Sommarskog <esquel@sommarskog.se>
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: How to backup SQL Express 13
Date: Wed, 11 May 2022 20:00:05 +0200
Organization: Erland Sommarskog
Lines: 15
Message-ID: <XnsAE94CB772A261Yazorman@127.0.0.1>
References: <t5aqus$9v2d$1@tota-refugium.de> <XnsAE929550276E3Yazorman@127.0.0.1> <t5bg88$aehe$1@tota-refugium.de> <XnsAE92E9E405CFEYazorman@127.0.0.1> <t5d3ds$bbi0$1@tota-refugium.de> <XnsAE93629CB7D32Yazorman@127.0.0.1> <t5d5k0$bd48$1@tota-refugium.de> <XnsAE93A4F762B01Yazorman@127.0.0.1> <t5e2s3$c27b$1@tota-refugium.de> <XnsAE93E956C2678Yazorman@127.0.0.1> <t5fp3b$bvra$1@tota-refugium.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 8bit
Injection-Info: reader02.eternal-september.org; posting-host="328ac9c7febe50e1077a34ad86ce8246"; logging-data="18585"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1/tB33bXGQe2HLuO0o0HFYc"
User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock: sha1:qUY1Ruqao1V1iGj8pEJls5NWn14=
Xref: csiph.com comp.databases.ms-sqlserver:2143

Tim Ritberg (tim@server.invalid) writes:
> I tried this, with different account formats: domain\user, user, user@
> 
> sqlcmd -H office2 -U user -Q "BACKUP DATABASE [contura] TO DISK = 
> N'/var/backup/demodb.bak' WITH NOFORMAT, NOINIT, NAME = 'demodb-full', 
> SKIP, NOREWIND, NOUNLOAD, STATS = 10"
> 
> Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server :
> Translated: "login error with user "user""

And where do you get this name "user" from? I mean, since the server
apparently is a user, there ia a user that can log in. Why not use that one?

It seems that you are running SQLCMD from a Linux box. On what OS does
SQL Server Express run?