Re: dbcreator and restore?

• Previous message: Kalen Delaney: "Re: dbcreator and restore?"
• In reply to: Linda: "dbcreator and restore?"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Mon, 27 Oct 2003 08:35:01 -0700

Members of db_owners can backup the database so I'm not sure
why you couldn't backup - maybe you didn't reconnect with
DBAGroup after changing the permissions? However, a database
role isn't enough for a restore. You can add the group to
the dbcreator server role to allow restoring databases. So
try adding the db_owners role for the database and the
dbcreators fixed server role.

-Sue

On Mon, 27 Oct 2003 05:39:24 -0800, "Linda"
<lritter@creativesolutions.com> wrote:

>I am looking for a way to allow a junior dba to restore
>databases on development servers. As a test, I created a
>new login called DBAGroup. I then assigned this login the
>dbcreator fixed server role. But the error I'm receiving
>when attempting to either restore or backup is:
>
>Server user 'DBAGroup' is not a valid user in database
>DBA_Test. BACKUP DATABASE is terminating abnormally.
>
>I've tried making this login dbo in this db, but get the
>same error.
>
>Is there any role or other combination of roles (short of
>sa) that would allow backup and restore?

• Previous message: Kalen Delaney: "Re: dbcreator and restore?"
• In reply to: Linda: "dbcreator and restore?"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]