dbcreator and restore?

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

Date: Mon, 27 Oct 2003 05:39:24 -0800

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: Problem with disable msde connection pool
    ... 'ALTER DATABASE TestDB SET single_user WITH ROLLBACK after 10 ... ' Restart the server... ... ' Execute query through SQLDMO to run the restore TSQL command ... the connection pool must be disabled. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Restore public folders and companyweb
    ... I understand that the Public Folder Store ... > database cannot be mounted due to integrity problems, ... > the pub.edb database from your backup of the old Server, ... please try the following steps to restore your public ...
    (microsoft.public.windows.server.sbs)
  • RE: Restore public folders and companyweb
    ... The new server must have the same domain name as the original server ... where the backup of the database. ... For the detailed steps to restore the SharePoint Services databases, ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)
  • RE: How to restore edb & stm files from bkf backup file on another exc
    ... copied to a different storage group on the same server or to a different ... On production server successfully backup information ... Restore Status ... Failed to find a database to restore to from the Microsoft ...
    (microsoft.public.exchange.admin)