Share via

Move Database Files

  • Article

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. For example, the database is in suspect mode or has shut down, because of a hardware failure.

  • Planned relocation.

  • Relocation for scheduled disk maintenance.

In This Section

Topic

Description

Move User Databases

Describes the procedures for moving user database files and full-text catalog files to a new location.

Move System Databases

Describes the procedures for moving system database files to a new location.

See Also

Reference

ALTER DATABASE (Transact-SQL)

CREATE DATABASE (Transact-SQL)

Concepts

Database Detach and Attach (SQL Server)