How to install SQL Server database

TipsMake.com - One of the most important steps you must take in SQL Server 2008 is to install data and log files. Failure to properly install these files will cause errors such as disk disputes, usage space. So let's discuss how to install the database file.

How to install SQL Server database Picture 1

Log file

Let's start with the previous log file because this is the easiest part as well as the most popular part. First, let's talk about how to put the log file on your drive: In general, you often want to place the log file on a separate partition rather than placing the same data file. There are 2 reasons: the first is the disk dispute. Each transaction will be recorded on the log file, before it is recorded on the data file. If both files are on the same drive, disk arm will have to work twice as hard to run from there to write to the log file and then run to write to the data. Placing the recorded file on a separate drive is better for file operations because the log file can be recorded continuously, faster than having to run from one place to another. The second reason you should separate these 2 files is to make recovery easier. When partitioning data is corrupted, you can restore the recorded file and return to the last transaction to prevent you from losing data.

Many files recorded

People often confuse that computers work using some recorded files. However, this is not true. The recorded file is recorded continuously, meaning that after a recorded file has been recorded, it is transferred to another file. So if you have 4 log files (Log1, Log2, Log3, Log4). SQL Server 2008 will log Log1, then Log2 . This is different from the operation of the data file. The reason for having multiple files recorded on multiple partitions is space. You should have more drives than using a single partition. Also, it is pointless to put the recorded file on a single partition. It doesn't help you at all.

Data file

You should place the data file on a different partition than the recorded file. When separating the data file from the log file, you can have multiple data files on multiple partitions.

Keep in mind that we should choose physical partitions by logical partitions that can still occur disk arm disputes that we should avoid. The data file is different from the recorded file because it uses the same recording algorithm. This means that all files are recorded in the most equal way possible. For example, you have 4 data files (Data1, Data2, Data3, Data4). When you write the database, SQL Server 2008 will write these files at a certain speed, either fast or slow. You can also put the table in a file to make it easier to control.

File growth (Development of data files)

Another issue to mention is file growth. New users often make mistakes when they usually leave the growth file by default. Here are some tips on how to set growth files:

1. First, you should place both the data file and the log file as large as possible. Depending on the version of SQL Server, the size for file growth is very large. So, it is better to set the capacity first to minimize problems. If you have a single partition for file recording, you should leave the file size equal to the volume of the partition. This will help you not lose data. Continue to do the same for the data file.

2. Secondly, you should set your files to grow automatically.

3. Third, set the data files to grow at the same speed and the recorded files at the same speed. Data files do not necessarily have to be the same speed as the recorded files. however, you should let them have the same development speed.

So we have finished separating the data file with the recorded file in different partitions.