Monday, March 26, 2012

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
Thanks Tibor.
It's already existed!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> glsD:uRmHKJ5EHHA.3932@.TK2MSFTNGP02.phx.g bl...
> 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@.hotmail.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@.hotmail.com> wrote in message
news:ez1JmU5EHHA.3540@.TK2MSFTNGP02.phx.gbl...
> Thanks Tibor.
> It's already existed!
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> glsD:uRmHKJ5EHHA.3932@.TK2MSFTNGP02.phx.g bl...
>

No comments:

Post a Comment