Re: dbcreator and restore?

From: Linda (lritter_at_creativesolutions.com)
Date: 10/27/03 

Date: Mon, 27 Oct 2003 10:24:30 -0800

It is working now. I have the login as dbo (not db_owner
role). I also created a backup after the login was set to
dbo and that is the backup that i successfully restored.

However, if I create a backup from production (where the
login is NOT dbo) and I use that as the backup.BAK from
which to restore onto the DEV server, then I get that
error message.
Does this make sense?

I don't want this login to be dbo on production.

Is there any way around this?
>-----Original Message-----
>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: Server needs restart to allow clients to connect
    ... > if so there's a little gotcha to do with housekeeping and HDD IO which may ... From the server console, the administrator can login ... >> correspond to the backup job which is executing at that time; ...
    (microsoft.public.windows.server.sbs)
  • Re: Server needs restart to allow clients to connect
    ... if so there's a little gotcha to do with housekeeping and HDD IO which may ... From the server console, the administrator can login ... > correspond to the backup job which is executing at that time; ...
    (microsoft.public.windows.server.sbs)
  • Re: Replacing Server Hardware
    ... Download BackupExec eval - install on the old server ... Backup Mailboxes - or backup everything! ... If the user is called FRED the User profile is stored at ... Login as Administrator and run http://servername/connectcomputer to the ...
    (microsoft.public.windows.server.sbs)
  • Re: Replacing Server Hardware
    ... Download BackupExec eval - install on the old server ... Backup Mailboxes - or backup everything! ... If the user is called FRED the User profile is stored at ... Login as Administrator and run http://servername/connectcomputer to the new ...
    (microsoft.public.windows.server.sbs)
  • Re: Remove/Add BUILTINAdministrators 2000 sp4
    ... I have seen a windows group referred to as a LOGIN for sql server in the ... the databases, and so it makes it dbo on all databases again. ...
    (microsoft.public.sqlserver.security)