Where would be the best place to locate the database and log files on a public server running SQL 2000? Should they be left in the Program Files\MS SQL Server\Data folder, or moved to inetpub/wwwroot/db?
Also does this forum work with MSDE or do I need a full Microsoft SQL server license?
< Moved to Help: Database: MS SQL Server by Shaggy />
Either location could work for the db & log files. I would leave them in the default location and wouldn't put them anywhere near the inetpub folder though. Its best to keep all mdf & ldf files in one or two folders as opposed to multiple folders.
The forum works with MSDE, Access, MySql, Sql Server 2000 & 2005. Under Microsoft's licencing MSDE is not supposed to be used as a backend for a website.
Also, using MSDE may limit the ability of your website to respond to higher traffic levels. MSDE 2000 will limit the number of simultaneous connections without performance degradation to 10.
Topic Locked
Posted - 08 December 2005 : 08:14:53
