3 out of 5 rated this helpful - Rate this topic

Moving Database Files

SQL Server 2005

In SQL Server 2005, 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
Moving User Databases	Describes the procedures for moving user database files and full-text catalog files to a new location.
Moving System Databases	Describes the procedures for moving system database files to a new location.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

Moving Database Files

Concepts

Other Resources

Help and Information

Community Additions