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 |
|
maagt
Starting Member
20 Posts |
 Posted - 2008-11-04 : 21:36:32
|
| Hi there, is anyone know how to set the ID permission only for backup and restore purpose beside using 'sa' login??i've tested dbcreator and db_backupoperator but its not allow to restore, and i can't assign sysadmin permission on the ID too. I'm doubt is there any method i can do that??Please help, thanks. |
|
|
Elisabeth Redei
Starting Member
15 Posts |
Posted - 2008-11-05 : 15:06:12
|
| Hi,Only sysadmins and dbcreator roles plus the owner of the database (dbo) can RESTORE if the database already exists. If the database doesn't already exist, you need to have CREATE DATABASE permissions.HTH!/Elisabethelisabeth@sqlserverland.com |
 |
|
|
maagt
Starting Member
20 Posts |
Posted - 2008-11-06 : 21:02:51
|
Hi Elisabeth,thank you so much for the reply.  |
|
|
|
|
|
|
ID for restoration