SQL Server Data Directories

For each Instance you create in Microsoft SQL you can specify how you want to separate the data directories:

  1. Data root directory – this will define where the binaries directory and the system database directory will be.
  2. User database directory – this is the location where all the user defined databases will be stored. It is usually used for READ operations.
  3. User database log directory – this is the location where the transaction logs for the user databases will be stored. It is usually used for WRITE operations.
  4. Temp DB directory – tempdb is also a system database and it is used to stored and manage temporary objects that are created during sorting or querying. Tempdb does not persist after SQL Server shuts down. This will contain the primary data file for the TempDB database..
  5. Temp DB log directory – this will contain the transaction log file for the TempDB database.
  6. Backup directory

It is best to separate these data directories depending on your hardware constraints.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s