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

Restore .mdf file

Hi

How to restore .mdf file in server database using sqlserver management studiocreate a dummy db under ur db server and then on right click u have the
option to restore the database.. using this u can achieve this|||

Quote:

Originally Posted by vinaykeshav

create a dummy db under ur db server and then on right click u have the
option to restore the database.. using this u can achieve this

hi vinay,

i am doing same way. buts its saying that ,its not a valid Microsoft tape format backup set|||our .mdf file may b corrupted..
first tk a backup of some other db and while restoring make sure the name of the db is same...

Quote:

Originally Posted by Scadhasini

hi vinay,

i am doing same way. buts its saying that ,its not a valid Microsoft tape format backup set

|||

Quote:

Originally Posted by vinaykeshav

our .mdf file may b corrupted..
first tk a backup of some other db and while restoring make sure the name of the db is same...

its working all db's . but i am trying to restore .mdf file. i am working with dnn4.while creating dnn web application i installed db in Database.mdf file.
now i am trying copy this in to server db.but is not working.|||In SQL Query Analyzer, back up a database by running the following command:
BACKUP DATABASE DatabaseName TO TAPE = TapeDriveName WITH FORMAT, BLOCKSIZE=65536, NOUNLOAD
Notes This command formats the tape with a block size of 64 KB. Therefore, the tape can be used by SQL Server 2000 and Windows Server 2003.

try to backup using above cmd and try restoring ..

Quote:

Originally Posted by Scadhasini

its working all db's . but i am trying to restore .mdf file. i am working with dnn4.while creating dnn web application i installed db in Database.mdf file.
now i am trying copy this in to server db.but is not working.

|||

Quote:

Originally Posted by vinaykeshav

In SQL Query Analyzer, back up a database by running the following command:
BACKUP DATABASE DatabaseName TO TAPE = TapeDriveName WITH FORMAT, BLOCKSIZE=65536, NOUNLOAD
Notes This command formats the tape with a block size of 64 KB. Therefore, the tape can be used by SQL Server 2000 and Windows Server 2003.

try to backup using above cmd and try restoring ..

I am working with sqlserver 2005 and windowsXP.i dont have sqlserver2000