[dba-SQLServer] Create error

Darryl Collins Darryl.Collins at coles.com.au
Mon Sep 22 18:40:56 CDT 2008


heh.. I told you these folks were good ;) <g>

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
jean-paul
Sent: Tuesday, 23 September 2008 4:10 AM
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] Create error



well i dont know what happened , but now it is working-

thanks













> From: jnatola at hotmail.com
> To: dba-sqlserver at databaseadvisors.com
> Date: Mon, 22 Sep 2008 13:54:59 -0400
> Subject: [dba-SQLServer] Create error
>
>
> Hi all,
>
> Please bear with me as Im new to SQL ,
> ;m having an issue with creating a DB  i just installed  windows 2003 r2   and sql05  the install went well  no errors etc..
>
>
> I have changed the default locations for the DB's  to E: for Tlogs and F: for the DB
>
> I'm using  windows authentication ,  my user account is both domain admin and local admin on the server - its not a DC-
> and I'm not on compressed drives
>
>
> The issue when I try to create a database  I get the following;
>
> Create failed for database 'test1' (Microsoft.SqlServer.Smo)
>
> An exception occurred while executing a Transact-SQL statement or batch
>
> Directory lookup for the file e:\SQL_DBs\test1.mdf" failed with the operating system error 2 (the system cannot find the file specified
>
> CREATE DATABSASE failed. Some file names listed could not be created. Check realted errors
> (Microsoft SQL Server, Error: 5133)
>
>
>
>
>
>
> TIA
>
> J
>
>
>
>
>
>
>
>
> _________________________________________________________________
> See how Windows connects the people, information, and fun that are part of your life.
> http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>

_________________________________________________________________
See how Windows Mobile brings your life together—at home, work, or on the go.
http://clk.atdmt.com/MRT/go/msnnkwxp1020093182mrt/direct/01/
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


This email and any attachments may contain privileged and confidential information
and are intended for the named addressee only. If you have received this e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this e-mail
has been sent to you in error. It is your responsibility to check this e-mail and
any attachments for viruses.  No warranty is made that this material is free from
computer virus or any other defect or error.  Any loss/damage incurred by using this
material is not the sender's responsibility.  The sender's entire liability will be
limited to resupplying the material.





More information about the dba-SQLServer mailing list