[dba-SQLServer] Create error

catching up on email here... but one common error that occurs on sql server
is that it won't create directory paths for you.  in the future when you try
this again and you get the error, first verify that the path structure
exists first :)


-Francisco
http://sqlthis.blogspot.com | Tsql and More...


On Mon, Sep 22, 2008 at 11:10 AM, jean-paul <jnatola at hotmail.com> wrote:

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