You can have SQL Server on C:\ drive, your system databases on D:\ drive, your paging file on E:\ drive, the log file of your database on F:\ drive, the data file of your database on G:\ drive, etc. You can also divide up your data file into multiple smaller data files and scatter them around. So you can essentially configure the server any way you want.
The way to move a SQL Server database is you detach it using the detach command, then move the physical files on your hard drive, then reattach the database using files in their new location. The detach/attach commands are located in the right-click menu in SQL Server Mangement Studio. Moving the system databases can be a little more tricky, but I don't think you are asking about that. Good luck, Mike Chabot On Nov 21, 2007 7:03 AM, Discover Antartica <[EMAIL PROTECTED]> wrote: > 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2999 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
