Path: csiph.com!weretis.net!feeder8.news.weretis.net!reader5.news.weretis.net!news.tota-refugium.de!.POSTED!not-for-mail
From: Tim Ritberg <tim@server.invalid>
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: How to backup SQL Express 13
Date: Tue, 10 May 2022 09:52:32 +0200
Message-ID: <t5d5k0$bd48$1@tota-refugium.de>
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>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Tue, 10 May 2022 07:52:32 -0000 (UTC)
Injection-Info: tota-refugium.de; logging-data="373896"; mail-complaints-to="abuse@news.tota-refugium.de"
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.8.1
Cancel-Lock: sha1:nwav1TFTXhqfhEqUbUmiMCBEwZw=
Content-Language: de-DE
In-Reply-To: <XnsAE93629CB7D32Yazorman@127.0.0.1>
X-User-ID: eJwFwYEBwCAIA7CXUKHFcxij/59gEgcLTUfAQyFs6pbP+bYWMFawymtkOv8MjWTNszqJUj0UUxEW
Xref: csiph.com comp.databases.ms-sqlserver:2133

Am 10.05.22 um 09:41 schrieb Erland Sommarskog:
> 
> Sorry, this is a newsgroup for Microsoft SQL Server. You can't expect
> people here to know what mysqldump is. I have a vague recollection that
> is actually a list of INSERT statements. A backup that you take with
> the BACKUP statement in SQL Server is indeed a binary file.
> 
> Since it is SQL Server that writes the backup, the backup must be written
> to a destination where SQL Server has write access, either local disk
> or a file share. But it is a good idea to copy the backup elsewhere,
> once you have taken it.
> 

So sqlcmd of mssql-tools wouldn't do the job remote? Or maybe with a 
netshare?

Tim