Path: csiph.com!weretis.net!feeder8.news.weretis.net!feeder5.news.weretis.net!news.tota-refugium.de!.POSTED!not-for-mail
From: Tim Ritberg <tim@server.invalid>
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: Easy way to copy database from MsSQL Express to MsSQL-Server?
Date: Tue, 20 Apr 2021 22:56:41 +0200
Message-ID: <s5nf69$ddl$1@tota-refugium.de>
References: <s5h3hp$o41$1@tota-refugium.de> <XnsAD10ECA229243Yazorman@127.0.0.1> <s5koma$7vs$1@tota-refugium.de> <XnsAD11E8F149422Yazorman@127.0.0.1> <s5ksfm$9rj$1@tota-refugium.de> <XnsAD12D3032F167Yazorman@127.0.0.1>
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Tue, 20 Apr 2021 20:56:41 -0000 (UTC)
Injection-Info: tota-refugium.de; logging-data="13749"; mail-complaints-to="abuse@news.tota-refugium.de"
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.7.1
Cancel-Lock: sha1:snhecP1Vvuzykrk8cPIFeBwMXhc=
In-Reply-To: <XnsAD12D3032F167Yazorman@127.0.0.1>
Content-Language: de-DE
X-User-ID: eJwNxdEVADEEBMCWCNalHA/bfwm5+ZkwKDodAQ8GD/PT/uMV6CQomgBqar3GpIcxG7LcK8ceI74RlA==
Xref: csiph.com comp.databases.ms-sqlserver:2087

Am 20.04.21 um 20:44 schrieb Erland Sommarskog:
> Tim Ritberg (tim@server.invalid) writes:
>> And what about users/permissions etc?
>>
> 
> Quoting Books Online:
> 
> BACKUP DATABASE and BACKUP LOG permissions default to members of the
> sysadmin fixed server role and the db_owner and db_backupoperator fixed
> database roles.
> 
> If the database being restored does not exist, the user must have CREATE
> DATABASE permissions to be able to execute RESTORE. If the database exists,
> RESTORE permissions default to members of the sysadmin and dbcreator fixed
> server roles and the owner (dbo) of the database.
> 

I guess, I would use admin account.

Tim