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

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

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	2021-04-20 20:44 +0200
Organization	Erland Sommarskog
Message-ID	<XnsAD12D3032F167Yazorman@127.0.0.1> (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>

Show all headers | View raw

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.

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