BUG: DOC Error: Documentation Incorrectly States that DB_Owner role has Restore Database Permissions (295121)

The information in this article applies to:

Microsoft SQL Server 7.0

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

Modification Type:	Major	Last Reviewed:	10/16/2002
Keywords:	kbBug kbDSupport KB295121