Restore Error:Create failed for database Error

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Restore Error:Create failed for database Error

Author

Topic

Sep410
Posting Yak Master

117 Posts

Posted - 2008-08-16 : 10:28:39

Hi All,

I want to restore a database and I get this error:
Create failed for database ''.Microsoft.SqlServer.Express.SMo
What is wrong?

Sep

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-16 : 11:24:38

Post the restore command.

Sep410
Posting Yak Master

117 Posts

Posted - 2008-08-16 : 17:59:15

Actually I want to do this manually and I don't know any other way. I tried to create new database and I got this error :

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Create failed for Database 'g'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3068&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

please help me.

Sep

chadmat
The Chadinator

1974 Posts

Posted - 2008-08-16 : 18:26:36

Do you have the apporpriate permissions to create a DB?

-Chad

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-16 : 21:38:50

You should be in dbcreator server role.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources