So, looks like you have to move the entire database to a separate drive, not just the database file. In other words, you could have sql server installed on c drive but the data and log files can be on d drive. To do this, you have to move that particular database to the d drive. Am I right? please correct me if i am wrong.
thanks ----- Original Message ---- From: Peter Boughton <[EMAIL PROTECTED]> To: SQL <[email protected]> Sent: Tuesday, November 20, 2007 11:17:48 AM Subject: Re: can we change the data folder 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/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2998 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
