In this article, we will see how to change default data file and transaction log files location in SQL Server.
By default database files are stored in DATA folder of respective instance.
It is always best practice to to maintain data and transaction log files in different disks in order to get the following advantages:
1. Minimize data loss.
2. High Performance.
3. To avoid disk space regular issues.
4. To avoid page corruption issues.
Best Practices:
Continue reading How to change default data file and transaction log files location in SQL Server