Databases should really go on an entirely seperate machine to the web server.
But anyway, this looks like something that might work: http://support.microsoft.com/kb/224071 ( FYI, it's the third entry in a Google search for "ms sql server change data folder" ) On 11/20/07, Discover Antartica <[EMAIL PROTECTED]> wrote: > > Our CF application is slowing down or sometimes not working due to > the lack of space on the drive sql server is installed. > if the sql server is installed on c drive, can we install the data and log > files on a different drive? > Typically, the data and log files are in C:\Program Files\Microsoft SQL > Server\ > folder. > can i change that folder for holding the data and log files to a different > drive than on which > the sql server is installed. > > This should help our coldfusion application come back to life. > Regards > DA > > > > ____________________________________________________________________________________ > Be a better pen pal. > Text or chat with friends inside Yahoo! Mail. See how. > http://overview.mail.yahoo.com/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2996 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
