O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using ALTER DATABASE

The ALTER DATABASE option for moving user database files was added in SQL Server 2005. This option involves the following steps:

1. Take the database offline.

2. Manually move the file(s) to the new location.

3. Run the ALTER DATABASE command to set the FILENAME property to the new file location.

4. Bring the database online.

The following example uses the ALTER DATABASE command to move the log file for the AdventureWorks2012 database to the root of the C: drive.

ALTER DATABASE AdventureWorks2012 MODIFY FILE (NAME = AdventureWorks2012_Log,  FILENAME = 'C:\AdventureWorks2012_log.ldf')

Caution

Use caution when specifying the FILENAME parameter to move a database log file. If the FILENAME setting ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required