RESTORE DATABASE question

Hi,

In my SQL Server 2000,

RESTORE DATABASE ETCService
FROM TAPE = '\\.\Tape0'

it gave me an error saying I have no right to do the Restore.
What kind of privilege do I need for doing the Restore Database?
Thanks for help.


Jason

It depends on whether the database you want to restore already exist or not.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/


"Jason Huang" < JasonHuang8888@hotma
il.com> wrote in message
news:OWpIs%234EHHA.3780@TK2MSFTNGP02.phx.gbl...
> Hi,
>
> In my SQL Server 2000,
>
> RESTORE DATABASE ETCService
>   FROM TAPE = '\\.\Tape0'
>
> it gave me an error saying I have no right to do the Restore.
> What kind of privilege do I need for doing the Restore Database?
> Thanks for help.
>
>
> Jason
>

Thanks Tibor.
It's already existed!

"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com>  撰寫於郵件新聞:uRmHK
J5EH
HA.3932@TK2MSFTNGP02.phx.gbl...
> It depends on whether the database you want to restore already exist or
> not.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "Jason Huang" < JasonHuang8888@hotma
il.com> wrote in message
> news:OWpIs%234EHHA.3780@TK2MSFTNGP02.phx.gbl... 
>
>

Jason

Are  you a member of sysadmin server role dbcreator fixed server role?
Probably not, am I right?

db_owner fixed database role do not have RESTORE permissions.




"Jason Huang" < JasonHuang8888@hotma
il.com> wrote in message
news:ez1JmU5EHHA.3540@TK2MSFTNGP02.phx.gbl...
> Thanks Tibor.
> It's already existed!
>
> "Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com>
>  撰寫於郵件新聞:uRmHK
J5EHHA.3932@TK2MSFTNGP02.phx.gbl... 
>
>

Here's a section from Books Online, RESTORE DATABASE, Permissions:

"If the database being restored does not exist, the user must have CREATE DA
TABASE permissions to be
able to execute RESTORE. If the database exists, RESTORE permissions default
 to members of the
sysadmin and dbcreator fixed server roles and the owner (dbo) of the databas
e (for the FROM
DATABASE_SNAPSHOT option, the database always exists).

RESTORE permissions are given to roles in which membership information is al
ways readily available
to the server. Because fixed database role membership can be checked only wh
en the database is
accessible and undamaged, which is not always the case when RESTORE is execu
ted, members of the
db_owner fixed database role do not have RESTORE permissions."



--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/


"Jason Huang" < JasonHuang8888@hotma
il.com> wrote in message
news:ez1JmU5EHHA.3540@TK2MSFTNGP02.phx.gbl...
> Thanks Tibor.
> It's already existed!
>
> "Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com>
>  撰寫於郵件新聞:uRmHK
J5EHHA.3932@TK2MSFTNGP02.phx.gbl... 
>
>