Move SQL Server transaction log to another disk
- by Jim Lahman
When restoring a database backup, by default, SQL Server places the database files in the master database file directory. In this example, that location is in L:\MSSQL10.CHTL\MSSQL\DATA as shown by the issuance of sp_helpfile Hence, the restored files for the database CHTL_L2_DB are in the same directory Per SQL…