I need to install a SQL server for prod environment. There are only two drives in the system one drive with 120 GB and another with 50 GB. How to choose the drives to keep the user defined db data and log files and temp db files.
Best practice in choosing the drives for data and log files while installing sql server in prod environment?
84 Views Asked by sowjanya At
1
There are 1 best solutions below
Related Questions in SQL-SERVER
- SQL server not returning all rows
- Big data with spatial queries/indexing
- Conditional null constraint on Null
- SQL Query - Order by String (which contains number and chars)
- Optimising a slow running SQL Server Stored procedure ordered by calculated fields to return a closest match
- Dynamics CRM Publishing Customizations - Multi Developers
- Is there anyway to set the relationship of many tables from Model?
- Implementation of Rank and Dense Rank in MySQL
- ORM Code First versa Database First in Production
- MVC : Insert data to two tables
- Data streams in case of Merge
- table with multiple IDs but seperate notes need sorting (Tried SQL code to make a union query)
- SQL table Partitioning by Year with ColumnStore index implemented on the table
- Defining which network to use for SQL Server 2012 Management Studio
- Fill a week days in a table with preceding Sundays value
Related Questions in INSTALLATION
- Bundle Multiple Xamarin apps in one pkg installer
- install a R package from directory
- Can I automate auto-app installation on my Android device?
- Stop the installshield installation if a file is not found in vb.net
- GVM: Issue when installing GVM in Ubuntu 14.04
- Not able to format namenode in hadoop-2.6.0 multi node installation
- How to install SFML in ubuntu?
- how to install packages from pypi to anaconda?
- What is PREFIX IN make PREFIX=$HOME/usr/local/OpenBLAS?
- WiX installer - change the install path
- First time app run action depending on how app was installed (Android)
- First time app run action depending on how app was installed (iOS)
- Error while installing HBase on windows
- Produce both versions x32 and x64 under PyInstaller
- Python: Trouble with dill installation
Related Questions in DATA-FILES
- Oracle XE data limit reached - how to reduce tablespace size?
- How to extract specific lines from a huge data file?
- Looping over multiple data files in Python 2.7
- Reading more data files FORTRAN90
- Opening files from working directory
- ClickOnce: How to Dynamically Detect Data Directory Between Debug, Release, and Publish
- Recover MySQL database from data folder without ibdata1
- Reading and Displaying Data Files, Correct results, but code is unfeasible
- Get log file name of database from .mdf file
- How to Determine Tablespace from ROWID if data_object_id is not Unique?
- Is it possible in PostgreSQL to restrict changes for files whose data is not actually changed?
- Python importlib.resources.files() throws UnicodeDecodeError: invalid continuation byte
- Data files from development machine to iOS device
- Making a python package for PIP with some data_files
- How to convert byte data into integers and floats using python?
Related Questions in LOG-FILES
- tomcat unble to sart with clipse
- Python find most recent File and get the size
- where is log file in nodejs app with winston
- Unix: Unexpected behavior of grep command with regex search
- Filter logfile to create a csv report using PowerShell
- Using config file for logging in python
- Folder to dump windows service log files
- How to control SQL Server database log file size?
- Adding space between paths in powershell
- How handle Log File in in selenium webdriver using java
- Backup from external Datasource to AWS S3 (using Data Pipelining)?
- Generating procedure logfile and inserting date time
- How to parse log file using python and store data in database?
- SQL Server 2k5 - Backup Of Database Without Log File(s)
- What is the proper way to create an apache-style log file using Erlang?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Your question too broad to have simple answer.
Take this points into consideration:
It is equally possible: