db_backupoperator role on SQL Server 2000

From: Paul (Paul.Amarante_at_Diageo.com)
Date: 06/18/03 

Date: Wed, 18 Jun 2003 14:31:20 -0700

It is stated that a user with the "db_backupoperator" role
can execute certain DBCC commands, as stated in pg. 137
of "SQL Server 2000 Administrator's Pocket consultant.
When I try this as a user with the preceding role, I get
database permission errors. Is this an error, or is there
a bug/bug fix to correct this problem in SQL Server 2000.

Relevant Pages

  • Re: how do you run multiple DBCC commands in one job
    ... work (how to determine on success/on failure is the prior step didn't finish yet?). ... > I'd like to create a job to run multiple DBCC commands in ... > I could create a multiple step CMDEXEC job, ... SQL Server may run all these DBCC ...
    (microsoft.public.sqlserver.server)
  • Re: How can you tell whether a DB is corrupt?
    ... You can run the DBCC commands to check the integrity of the database. ... Vyas, MVP (SQL Server) ... is the corruption of a database always associated with its being not able to ...
    (microsoft.public.sqlserver.server)
  • how do you run multiple DBCC commands in one job
    ... I'd like to create a job to run multiple DBCC commands in ... SQL Server may run all these DBCC ...
    (microsoft.public.sqlserver.server)