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,392 of 19,505    |
|    Tim Ritberg to guess sql server can't    |
|    Re: How to backup SQL Express 13    |
|    11 May 22 22:34:53    |
      From: tim@server.invalid              Am 11.05.22 um 20:00 schrieb Erland Sommarskog:       >       > 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?       Now I got it.       I startet Server Manager Studio as local admin and created a user for sql.              This is my backup command:       sqlcmd -U remotebackup -P foobar -S tcp:office2,49762 -Q "BACKUP       DATABASE [contura] TO DISK = 'testback' WITH NOFORMAT, NOINIT, NAME =       'demodb-full', SKIP, NOREWIND, NOUNLOAD, STATS = 10"              Strange that port 49762 and backup went into a sqlserver subfolder. I       guess sql server can't write directly to net shares.              >       > It seems that you are running SQLCMD from a Linux box. On what OS does       > SQL Server Express run?       Windows 10                     Tim              --- 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