> Just installed MSDE (2000) and its working nicely. But I > can't find the database I created. It doesn't appear to be > in c:\program files\Microsoft SQL Server\MSSQL\Data\ > although there are four data files in there (master, model, > msdbdata, tempdb). None appear to be the one I created and > am already working with. > > I have to missing something stupid... Where do I go to find > the files?
When you create a database, it's up to you to specify where the data and log files will be created. Depending on how you created the database, they could be anywhere, I suppose. You can just search your drives for any SQL data or log files by extension (.mdf and .ldf, I think), or if you created them with the command-line OSQL client, they might be in the directory from which you ran OSQL. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
