Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 19,391 of 19,505    |
|    Erland Sommarskog to Tim Ritberg    |
|    Re: How to backup SQL Express 13    |
|    11 May 22 20:00:05    |
      From: esquel@sommarskog.se              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?              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca