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.