How do I move a SQL Server log to another drive?

Question

You can use the same method to move the data file from one drive to another drive. Step 0: Create a sample database. USE master. . Step 1: Capture Database Details. USE SampleDatabase. . Step 2: Detach Database. . Step 3: Move LDF (or MDF) File Manually. . Step 4: Attach the Database.

How do I change the location of a SQL log file?

View or change the default locations for database files1In Object Explorer, right-click on your server and click Properties.2In the left panel on that Properties page, click the Database settings tab.3In Database default locations, view the current default locations for new data files and new log files.

How do I move a log from one drive to another?

In a nutshell, the three main steps involved in moving a log file to new location are:1Detach the database.2Move log file to new location.3Attach the database by referencing the new location of the transaction log file.

How do I move data and log files in SQL Server?

In SQL Server, you can move system and user databases by specifying the new file location in the FILENAME clause of the ALTER DATABASE statement. Data, log, and full-text catalog files can be moved in this way. This may be useful in the following situations: Failure recovery.

How do I change the location of a SQL Server database?

In the Object Explorer right-click the SQL Server Database Engine Instance and select Properties from the menu.1In Server Properties dialog box navigate to Database Settings page as shown below. Under Database default locations you can specify the new path for the Data and Log.2Click the …

Expert · Answer