Microsoft KB Archive/295121

= BUG: DOC Error: Documentation Incorrectly States that DB_Owner role has Restore Database Permissions =

Article ID: 295121

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q295121



BUG #: 56722 (SQLBUG_70)

BUG #: 55160 (SQLBUG_70)



SYMPTOMS
SQL Server 7.0 Books Online states that a member of the db_owner role has RESTORE DATABASE permission. However, when a member of the db_owner fixed database role tries to restore a database, the following error message occurs:

Server: Msg 3110, Level 14, State 1, Line 1

Only members of the sysadmin role or the database owner of 'Database_Name' can run RESTORE DATABASE.

Server: Msg 3013, Level 16, State 1, Line 1

Backup or restore operation terminating abnormally.



CAUSE
Members of the db_owner fixed database role do not have RESTORE permissions. This behavior is by design. Fixed database role membership can only be checked when the database is accessible and undamaged. Because this is not always the case when the RESTORE statement is executed, members of the db_owner fixed database role do not have RESTORE permissions.



WORKAROUND
Only members of the sysadmin role or the database owner (dbo) can restore the database.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.



MORE INFORMATION
SQL Server 2000 Books Online has the correct information.

Besides SQL Server 7.0 Books Online, the current versions of some Microsoft Developer Network (MSDN) and TechNet articles, such as the following, also contain incorrect information:

TechNet; topic: Migrating Oracle Databases to SQL Server 2000

MSDN; topic: Migrating Oracle Databases to Microsoft SQL Server 7.0

Additional query words: db_owner restore permission

Keywords: kbbug kbpending KB295121

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.