Restore database

Hi!

I am trying to restore a db from the query window in SQL Server Management Studio Express.

The query is like this:

restore database geodb from disk='C:\db\geodb.bck' with move 'geodb' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\geodb.mdf', move 'geodb_log.ldf' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\geodb_log.ldf'

When executing the query, I get this message:

Msg 262, Level 14, State 1, Line 1CREATE DATABASE permission denied in database 'master'.Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.

Do any of you know how to get rid of this message?

Thank you all, BassoBee

Connect with an account which has the capability to do execute the CREATE Database command, either the explicit permissions or who is on a role which can do this perform this action, like db_creator.

HTH, jens K. Suessmeyer.

http://www.sqlserver2005.de