Path: csiph.com!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: Erland Sommarskog <esquel@sommarskog.se>
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: Easy way to copy database from MsSQL Express to MsSQL-Server?
Date: Tue, 20 Apr 2021 20:44:36 +0200
Organization: Erland Sommarskog
Lines: 15
Message-ID: <XnsAD12D3032F167Yazorman@127.0.0.1>
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>
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 8bit
Injection-Info: reader02.eternal-september.org; posting-host="a8ab3087d516745258597b63a81d6a82"; logging-data="8500"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1+ww+A6wIdDZWHUaCJWpWJx"
User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock: sha1:MlvPg7I7jxAjGM7BobXExBof8Yw=
Xref: csiph.com comp.databases.ms-sqlserver:2086

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.