[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/