Skip to content

move-database-files.md

Latest commit

 

History

History
48 lines (39 loc) · 2.04 KB

move-database-files.md

File metadata and controls

48 lines (39 loc) · 2.04 KB
title Move database files
description Learn how to move system and user databases by specifying the new file location in the FILENAME clause of the ALTER DATABASE statement.
author WilliamDAssafMSFT
ms.author wiassaf
ms.reviewer randolphwest
ms.date 09/19/2024
ms.service sql
ms.topic conceptual
helpviewer_keywords
disaster recovery [SQL Server], moving database files
files [SQL Server], moving
data files [SQL Server], moving
file moving [SQL Server]
moving full-text catalogs
moving databases
full-text catalogs [SQL Server], moving
moving database files
scheduled disk maintenance [SQL Server]
moving files
relocating database files
planned database relocations [SQL Server]
databases [SQL Server], moving

Move database files

[!INCLUDE SQL Server]

In [!INCLUDE ssNoVersion], 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 option might be useful in the following situations:

  • Failure recovery. For example, the database is in suspect mode, or is shut down, because of a hardware failure.

  • Planned relocation.

  • Relocation for scheduled disk maintenance.

In this section

Article 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.

Related content