Databaseguy
MIS
How do I move the location of the log file (LDF) from the default directory somewhere else ? Tyrone Lumley
augerinn@gte.net
augerinn@gte.net
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Moving Log File 1
- Thread starter Databaseguy
- Start date
- Status
-
1
- #2
tlbroadbent
MIS
For user databases:
1- Detach the database.
2- Move the file.
3- Reattach the database.
Moving a system databse is a little more complex. See the following.
If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:
1- Detach the database.
2- Move the file.
3- Reattach the database.
Moving a system databse is a little more complex. See the following.
If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question