Re: dbcreator and restore?

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 10/27/03 

Date: Mon, 27 Oct 2003 07:26:49 -0800

Hi Linda

It seems very strange that a user who is dbo cannot even do a backup. Can
you verify exactly what steps you are performing, first to make this login
dbo, and then to perform the backup.
Also, what exactly do you mean by making the login dbo? Are they actually
the owner of the database or are they only in the db_owner role?

The output of sp_helpuser (while in the database) could be useful. 

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Linda" <lritter@creativesolutions.com> wrote in message
news:070401c39c8f$bbfb70a0$a501280a@phx.gbl...
> 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?

Relevant Pages

  • Re: Confused about dbo
    ... neither the explicit database owner or aliased to the dbo user. ... member of the db_owner role does not mean you are aliased to the dbo user. ... When you connect to SQL Server you do so using a login. ...
    (microsoft.public.sqlserver.security)
  • Re: db_owner role in SQL 2k
    ... Windows login name. ... login that is the owner of a database and members of the sysadmin role. ... >> the username dbo" ... >> FULL permission to do anything and everything. ...
    (microsoft.public.sqlserver.programming)
  • Re: Change dbo
    ... I have a database where a user is defined as the dbo on a database. ... I tried using SQL Server Manger ... The login for this person maps to dbo. ...
    (microsoft.public.sqlserver.security)
  • Re: db_owner role in SQL 2k
    ... The owner of a database is a login, which is listed in the sysdatabases ... I try not to think of DBO as the Database Owner, but just as special, ... For anyone to use any database, their login name must have been given access ...
    (microsoft.public.sqlserver.programming)
  • Re: db_owner role in SQL 2k
    ... > The owner of a database is a login, which is listed in the sysdatabases ... > table in the master database as the owner of the database. ... and their user name will ALWAYS be DBO. ... > automatically members of the public role. ...
    (microsoft.public.sqlserver.programming)