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

Re: Easy way to copy database from MsSQL Express to MsSQL-Server?

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> (permalink)
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

Show key headers only | View raw

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

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

Thread

Easy way to copy database from MsSQL Express to MsSQL-Server? Tim Ritberg <tim@server.invalid> - 2021-04-18 13:01 +0200
  Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Erland Sommarskog <esquel@sommarskog.se> - 2021-04-18 23:15 +0200
    Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Tim Ritberg <tim@server.invalid> - 2021-04-19 22:20 +0200
      Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Erland Sommarskog <esquel@sommarskog.se> - 2021-04-19 22:53 +0200
        Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Tim Ritberg <tim@server.invalid> - 2021-04-19 23:25 +0200
          Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Erland Sommarskog <esquel@sommarskog.se> - 2021-04-20 20:44 +0200
            Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Tim Ritberg <tim@server.invalid> - 2021-04-20 22:56 +0200
              Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Erland Sommarskog <esquel@sommarskog.se> - 2021-04-21 20:25 +0200
                Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Tim Ritberg <tim@server.invalid> - 2021-04-21 21:23 +0200
                Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Erland Sommarskog <esquel@sommarskog.se> - 2021-04-22 21:20 +0200

csiph-web