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