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

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

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	2021-04-20 22:56 +0200
Message-ID	<s5nf69$ddl$1@tota-refugium.de> (permalink)
References	(1 earlier) <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>

Show all headers | 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