home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 19,339 of 19,505   
   Erland Sommarskog to Tim Ritberg   
   Re: Easy way to copy database from MsSQL   
   20 Apr 21 20:44:36   
   
   From: esquel@sommarskog.se   
      
   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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca