Putting data and logs on separate drives is the recommended best practice for SQL Server. What Peter suggests is also correct. If you are going to put everything in the same box, I would definitely try to add extra drives, since that will be a bottleneck.
-Mike Chabot On Nov 20, 2007 12:47 PM, 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2997 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
