Groups > comp.databases.ms-sqlserver > #2145

Re: How to backup SQL Express 13

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: How to backup SQL Express 13
Date	2022-05-11 22:42 +0200
Organization	Erland Sommarskog
Message-ID	<XnsAE94E6F63EF50Yazorman@127.0.0.1> (permalink)
References	(8 earlier) <t5e2s3$c27b$1@tota-refugium.de> <XnsAE93E956C2678Yazorman@127.0.0.1> <t5fp3b$bvra$1@tota-refugium.de> <XnsAE94CB772A261Yazorman@127.0.0.1> <t5h6le$cqrc$1@tota-refugium.de>

Show all headers | View raw

Tim Ritberg (tim@server.invalid) writes:
> 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.

The port number is instead of the instance name. Which you need if the
Browser server is not running or blocked by firewall.

It went to that folder, because you did not specify the full path. You can 
change the default path from SSMS under Server Properties, but I don't 
really recommend that.

SQL Server can write to net shares - but the service account for SQL Server
needs to have write access to the share.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

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