<div>
<div class="content wysiwyg-content">
How to move SQL system and temp databases. &nbsp; &nbsp;As well as the FTdata folder, Jobs folder and logs folder. &nbsp; &nbsp; &nbsp;I just loaded a brand new SQL 2016 standard edition. &nbsp; During the installation I set the paths as follows. &nbsp; &nbsp; D:\SQL Data for data. &nbsp; &nbsp;D:\SQL Data\ for log ... &nbsp;and D:\SQL Backup for backup. &nbsp; &nbsp; &nbsp;my intent was to keep backups simple. &nbsp; &nbsp; However the installation created another folder by default. &nbsp; &nbsp;D:\MSSQL13.MSSQLSERVER\MSS<wbr />QL &nbsp; &nbsp;and then put another Data folder with the system database and temp database. &nbsp; &nbsp; As well as the other folders mentioned above.<br />
<br />
I would like to move this all to my folders I created manually for ease of backup. &nbsp; &nbsp; All but I suppose the tempdb which I do not need to backup. &nbsp; Perhaps though another root folder D:\SQL temp would be good for me to stay along the lines of keeping things simply. &nbsp; &nbsp; <br />
<br />
Is this normal for the installer to do this. &nbsp; &nbsp;Would it be easier to remove and start over?
</div>
</div>


How to move SQL system and temp databases.    As well as the FTdata folder, Jobs folder and logs folder.      I just loaded a brand new SQL 2016 standard edition.   During the installation I set the paths as follows.     D:\SQL Data for data.    D:\SQL Data\ for log ...  and D:\SQL Backup for backup.      my intent was to keep backups simple.     However the installation created another folder by default.    D:\MSSQL13.MSSQLSERVER\MSSQL    and then put another Data folder with the system database and temp database.     As well as the other folders mentioned above.

I would like to move this all to my folders I created manually for ease of backup.     All but I suppose the tempdb which I do not need to backup.   Perhaps though another root folder D:\SQL temp would be good for me to stay along the lines of keeping things simply.     

Is this normal for the installer to do this.    Would it be easier to remove and start over?

How to move SQL system and temp databases.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Installation is the act of making a computer program program ready for execution. Because the process varies programs often come with a specialized program responsible for doing whatever is needed for their installation. Installation may be part of a larger software deployment process. Cross platform installer builders that produce installers for Windows, Mac OS X and Linux include InstallAnywhere, InstallBuilder and Install4J. Installers for Microsoft Windows include Windows Installer, InstallShield, and Wise Installation Studio; free installer-authoring tools include NSIS, IzPack, Clickteam, InnoSetup, InstallSimple and WiX. Mac OS X includes Installer, and also includes a separate software updating application.

Installation

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.