How to assign RESTORE DATABASE Permissions

Hello, I have created a new database with Network Solutions.  THey have created a SQL database user for me which I have set to DB Owner and has the same permissions as dbo.

I am trying to restore this empty database on the server with this script:

RESTORE DATABASE myDatabase
   FROM DISK = 'C:\Inetpub\wwwroot\SQL2005_460116_myDatabase_backup.bak'

I get this error:

Msg 3110, Level 14, State 1, Line 2
User does not have permission to RESTORE database 'myDatabase'.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.


What permisison do I have to set to be able to restore myDatabase.  I only have access to that database, but I have full access to it including security.  Do I need access to master?

User does not have permission to RESTORE database 'myDatabase'.
hoyaabanksAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
you run a GRANT statement:
msdn.microsoft.com/en-us/library/ms178569.aspx
GRANT CREATE DATABASE TO youruser

Open in new window

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
to RESTORE a database, you need CREATE DATABASE permissions on the instance.
0
 
hoyaabanksAuthor Commented:
How Do I add CREATE DATABASE permissions to the instance?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.