restore database from CTP edition to developer edition

hi there,
i m currently using visual studio 2005 beta 2 with SQL server 2005 Developer Edition CTP developing application. i now considering to switch my project to use visual studio 2005 professional edition and SQL server 2005 Developer edition. however i was afraid that my database cannot be restore into SQL server 2005 Developer edition
anyway, can it be restore if i switch?

This worked for me, I backuped and restored the database from the CTP relase to the RTM developer edition.

HTH, Jens Suessmeyer.

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