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
 SQL Server Administration (2005)
 Cannot Create any new database

Author  Topic 

ybastian
Starting Member

1 Post

Posted - 2009-01-30 : 02:02:08
I cannot create any new database. It gives me following error message:-

CREATE DATABASE failed. Some file names listed could not be created. Chek related errors (Microsoft SQL Server, Error: 5133).

Condition:-
- I work on MS SQL Server 2005 Std on MS Windows 2003 Ent w/SP2
- I tried to create a DB in local HDD drive
- But, Restore DB from a backup file (as new DB name) has no problem at all.

Anyone can help me?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-01-30 : 02:23:26
What is the meaning of local HDD drive?


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

AvanthaSiriwardana
Yak Posting Veteran

78 Posts

Posted - 2009-01-30 : 02:52:41
Are you db admin?

Avantha Siriwardana
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-30 : 09:49:57
quote:
Originally posted by webfred

What is the meaning of local HDD drive?

Hard Disk Drive.


No, you're never too old to Yak'n'Roll if you're too young to die.



Seems like you don't have proper permission to create database.
Go to Top of Page

saurabhsrivastava
Posting Yak Master

216 Posts

Posted - 2009-01-30 : 15:23:42
Are you running ? CREATE DATABASE DB_NAME; If yes check default location for data files to ensure that names are not colliding.
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-01-30 : 17:34:34
quote:
Originally posted by sodeep

quote:
Originally posted by webfred

What is the meaning of local HDD drive?

Hard Disk Drive.


No, you're never too old to Yak'n'Roll if you're too young to die.



Seems like you don't have proper permission to create database.


Hard Disk Drive - yes that was clear to me.
I wanted him to tell me what's his meaning of LOCAL hdd


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -