Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #2143
| 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> (permalink) |
| 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 |
Show key headers only | View raw
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?
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar
How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-09 12:38 +0200
Re: How to backup SQL Express 13 Erland Sommarskog <esquel@sommarskog.se> - 2022-05-09 14:40 +0200
Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-09 18:41 +0200
Re: How to backup SQL Express 13 Erland Sommarskog <esquel@sommarskog.se> - 2022-05-09 22:59 +0200
Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-10 09:15 +0200
Re: How to backup SQL Express 13 Erland Sommarskog <esquel@sommarskog.se> - 2022-05-10 09:41 +0200
Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-10 09:52 +0200
Re: How to backup SQL Express 13 Erland Sommarskog <esquel@sommarskog.se> - 2022-05-10 16:13 +0200
Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-10 18:11 +0200
Re: How to backup SQL Express 13 Erland Sommarskog <esquel@sommarskog.se> - 2022-05-10 22:56 +0200
Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-11 09:37 +0200
Re: How to backup SQL Express 13 Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-05-11 12:54 +0300
Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-11 12:21 +0200
Re: How to backup SQL Express 13 Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-05-11 13:40 +0300
Re: How to backup SQL Express 13 Erland Sommarskog <esquel@sommarskog.se> - 2022-05-11 20:00 +0200
Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-11 22:34 +0200
Re: How to backup SQL Express 13 Erland Sommarskog <esquel@sommarskog.se> - 2022-05-11 22:42 +0200
Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-11 23:02 +0200
Re: How to backup SQL Express 13 Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-05-11 15:28 +0300
csiph-web