December 26, 2011 at 4:35 pm
I have two drive arrays in a server (C and D both of same size) and also have an application(reporting app) running on that server. What's the best way to configure SQL Server? We do lot of inserts and update operations. Larger files will be uploaded through back-end when when interface fails to upload the data. Otherwise use web interface to updates & inserts.
Best practices say to keep your data and log files on separate drive arrays, but is it OK to put them on the same drive and put the application files on the other drive?
What's the appropriate way- keeping application files on one drive and data & log files on other drive OR keeping application files and sql data files on one drive and log files on other drive
December 27, 2011 at 3:58 am
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply