Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Kehayias Moving Database Files Detach/Attach or ALTER DATABASE? RE: Moving Database Files Detach/Attach or ALTER DATABASE?

  • September 24, 2010 at 6:59 am

    #1226924

    amarshall-568002 (9/24/2010)

    I didn't think you could move the log file with alter... unless you used enterprise or developer version of SQL.

    Amy

    You can use ALTER DATABASE MODIFY FILE for log files in any edition of SQL Server including Express. Once the command has been executed, you take the database offline, move the file to the new location and then bring the database back online. This is not an Enterprise Only Feature.

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]