Apr 1, 2003 #1 Databaseguy MIS Jul 20, 2001 1,153 US How do I move the location of the log file (LDF) from the default directory somewhere else ? Tyrone Lumley augerinn@gte.net
How do I move the location of the log file (LDF) from the default directory somewhere else ? Tyrone Lumley augerinn@gte.net
Apr 1, 2003 1 #2 tlbroadbent MIS Mar 16, 2001 9,982 US 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. http://support.microsoft.com/default.aspx?kbid=224071 If you want to get the best answer for your question read faq183-874 and faq183-3179. Terry L. Broadbent - DBA SQL Server Page: http://tlbroadbent.home.attbi.com/sql/sql_articles.htm Upvote 0 Downvote
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. http://support.microsoft.com/default.aspx?kbid=224071 If you want to get the best answer for your question read faq183-874 and faq183-3179. Terry L. Broadbent - DBA SQL Server Page: http://tlbroadbent.home.attbi.com/sql/sql_articles.htm