Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wal99005
Starting Member
2 Posts |
 Posted - 2001-09-28 : 15:10:06
|
| Microsoft SQL Server documentation states that members of the sysadmin or dbowner roles are able to restore a database. As expected (coming from Microsoft) the documentation _might_ be wrong!? I created a user for a database, and set the user to dbowner. When the restore database is attempted, SQL Server comes back with error 42000, stating only sysadmins and dbowners can do this. Does SP3 fix this? Is there some workaround I don't know about? Any help would be useful. Thanks.Edited by - wal99005 on 09/28/2001 15:11:13 |
|
|
|
|
|
DB Restore Error 42000